Browse by Tags

FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005

Published 17 December 7 7:19 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you...

Filed under: sql server, services, kba, alert, database mirroring, principal, restart, debug

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."

Published 26 September 7 5:27 AM | SSQA.net

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...

Filed under: sql server, anti-virus, connections, service, recovery, tcp, restart, maximum, sp_configure