Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

How to backup SQL Server databases to a mapped drive

While taking backups for SQL Server databases onto a mapped drive you might get the following error: " The system cannot find the path specified." This is because a network share that you map using a local drive letter will not be visible to a SQL Server Read More...
Posted Friday, February 27, 2009 9:00 AM by Pariks | 5 Comments

Log Reader Agent Fails when the Sql server instance is failed over to Node 2

We have observed a number of case where we use sql server replication on a clustered instance of sql server and when we try to failover from Node 1 to Node 2 the Log Reader agent may fail to start with the following error Error messages: The process could Read More...
Posted Monday, November 24, 2008 12:09 PM by sanjayap | 2 Comments
Filed under: ,

Security considerations for SQL Server installation on Windows Server 2008

Did you know that Windows Server 2008 installation, by default, enables the Windows firewall to be ON just like Windows Vista. So there is a possibility that in the previous installations, you have not been using the Windows Firewall and disabled it for Read More...
Posted Thursday, July 03, 2008 12:31 PM by sanjayap | 1 Comments

Use of Kerberos Authentication in SQL Server 2005

Kerberos is a network authentication protocol which can be used only with TCP/IP protocol. So if the client connects to the sql server with the Named Pipe Alias Kerberos is not used. Every service that will use Kerberos authentication needs to have an Read More...
Posted Tuesday, May 06, 2008 3:45 PM by sanjayap | 2 Comments
 
Page view tracker