.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

shutting down SQL server correctly

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server
 

I will like to know what the correct procedure of shutting down SQL server, I often see people simply stop/restart the SQL service from the services section within windows.

Is the correct way to set the database offline and online etc.




View Complete Post


More Related Resource Links

The report server instance is not configured correctly. Please use the Reporting Services Configurat

  
Hello All, I am having problem in configuring report server in SharePoint 2010 Central Administration. The Scenario is explained below: We have farm with two Servers with following components installed: 1. APPSERVER : SharePoint 2010, SSRS(2008 R2) and Reporting Services Add in (installed using credentials    (domain/sharepointuser)) 2.  SQLSERVER: SQL SERVER 2008 R2, Report Server Database (installed using credentials    (domain/sqluser)) Steps followed: a. Configured Report Server on APPSERVER with database in SQL SERVER. We browsed the report server url (http://localhost/reportserver) successfully b. Installed Reporting Services Addin on APPSERVER c. In SharePoint Central Administration, Under Reporting Services Integration, we gave the report server web server url as http://localhost/reportserver , authentication as Windows Authentication and credentials which are used to install SQL SERVER (domain/sqluser) d. We also added a new group called WSS_WPG Error is given below: The report server instance is not configured correctly. Please use the Reporting Services Configuration tool to create a report server database in SharePoint integrated mode before setting integration options for this SharePoint Web application. Thanks in Advance  

how to format server tag correctly?

  
I'm trying to display images in a GridView, but have a problem with this code:<asp:TemplateField> <ItemTemplate> <asp:Image ID="Image1" Height = "100" Width = "100" runat="server" //Error message here ImageUrl = = '<%# Eval("ID", "ImageProd.aspx?ImageID={0}")%>' /> //Warning here </ItemTemplate> </asp:TemplateField>The error message says: "Server tag is not correctly formatted."and the warning says: "Validation (ASP.Net): If this attribute value is enclosed in quotation marks, the quotation marks must match." I have this same warning on another interface where I just display one picture and not in a GridView and the image displays fine.Warning 7 Validation (ASP.Net): If this attribute value is enclosed in quotation marks, the quotation marks must match. C:\Users\karask\Desktop\Pejgan\AdminInnehåll.aspx 86 32 C:\...\Pejgan\

SQL Server SP3 was not correctly installed

  

Hi,


i am running MS SQL Server 2005 Enterpreis Edition x64.
There are several local disks on the server of sql: ?:\ , X:\ ...
The SQL Server is installed on C:\Program Files\Microsoft SQL Server\

The SP3 was installed on SQL Server using WSUS.
Recently i have found out that there is a folder on disk X:\ (X:\596166c4744e026ff11d) with a lot of files and folders like "hotfixsql", "hotfixdts" etc.
I have tried to remove this folder but I got an error message:
Cannot delete sqlrun_tools: Access is denied. Make sure the disk is not full or write-protected and that the file is not currently in use.
In file X:\596166c4744e026ff11d\1033\eula.txt I have found the following info:
MICROSOFT SQL SERVER 2005 SERVICE PACK 3

So these hotfixes have to do with SQL Server.

I have to move disc X:\ but I can not do it because of these strange files...

But why are these files not on disk C:\?
And why are they necessary for SQL Server?

Please help me..


Thank you for your time
Evgeniya


Report shows correctly when viewed from report server, but not at all when viewed from DB server

  

Hello,

I've set up SQL Server 2008 R2 on a Windows 2008 server ("SQLDB").  It includes the Reporting Services databases from the SSRS 2008 R2 files-only installation, also on Windows 2008 server ("SQLRS").  The problem I'm having is that reports are rendering when viewed on the report server SQLRS, but not when viewed on the SQL Server SQLDB via the same URL.  The error message is:

"An error has occurred during reporting processing. (rsProcessingAborted)  Cannot create a connection to data source 'SourceDB'. (rsErrorOpeningConnection)  For more information about this error navigate to the report server on the local server machine, or enable remote errors"

In Report Services Manager, I've added my login in "Site Settings" and assigned my login System Administrator and System User roles.  In Report Services Home folder, I've assigned all roles to my user account: Browser, Content Manager, My Reports, Publisher, and Report Builder.  In SQL Server, I've given my login execute permissions to all report stored procedures.

Assuming I'm logged into SQLDB with my regular login, shouldn't I be able to run the report server app and view the reports as if I were running the report server app as myself on SQLRS?

Thanks,
Eric


Cannot Browse cube correctly after upgrading SQL Server 2005 to SQL Server 2008

  

I upgraded to SQL Server 2008 from 2005 and now when browsing my cubes only one measure displays at a time e.g. i can view two measures actual month and YTD the two displays but when i drag a dimension to the row, the actual month disappears and only YTD displays. if i remove the YTD measure the actual month shows again. Without the dimensions in the rows they both show. Does anybody have a suggestion on how to resolve this? it worked perfectly well before the upgrade.

 


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

SQL Server Backup and Restore (video)

  
Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend