Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » sp_configure   (RSS)
Cumulative update package 6 for SQL Server 2005 Service Pack 2 - available now
Another set of Cumulative update package ready to download for SQL Server 2005 Service Pack 2, again only by the way of contacting the CSS. From our CumulativeUpdate blog series here is another one to add up as well and this CU6 package is only intended Read More...
Posted: Wednesday, February 20, 2008 1:39 AM by SQL Master | 5 Comments
Filed under: , , , , , , , ,
Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed."
The above error is obvious when you have setup the SQL Server instance to accept only 1 connection. The default setting for number of user connections is '0' which accepts unlimited connections. With similar settings one of my friend have had issues and Read More...
Posted: Wednesday, September 26, 2007 3:27 AM by SQL Master | 2 Comments
Filed under: , , , , , , , ,