Thursday, August 23, 2012

Change max user connections to 1 now cant connect

Problem
Thinking it was a good idea, i changed max user connections to 1. Well, now i cannot connect to the server through SSMS. It results in error 223.

Solution
1. Start -> Run->cmd
2. sqlcmd -A -S <yourserver> -E
3.sp_configure 'show advanced options', 1
4. GO
5. Hit Enter, this will say "Configuration option 'show advanced options' changed...."
6. RECONFIGURE
7. GO
8. Hit Enter, it'll say nothing
9. sp_configure 'user connections', 0
10. GO
11. Hit Enter, it'll say "Configuration user connections' changed..."
12. RECONFIGURE
13. GO
14. It'll say nothing
15. Restart the SQL Server

http://social.msdn.microsoft.com/Forums/zh/sqldatabaseengine/thread/d3797fc1-357d-461d-b95e-233eb537c203

No comments:

Post a Comment

There was an error in this gadget