How to limit connections to SQL Server until all databases are ONLINE!

Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this company was to have all databases online before any of their ten…

8

Did you know... SQL Server 2000 cluster Resource Fails to come online with error SuperSocket Info: Bind failed on TCP port 5184 reported in errorlog!

In order to change the Virtual IP of the sql server 2000 clustered instance we need to follow the following KB article http://support.microsoft.com/kb/244980 However If we try to change the Virtual IP by mapping the Virtual Server Name of the sql server resource to the New Virtual IP in the DNS alone then sql server…

0

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 your day to day work. When you start working on this new…

1