The error message is quite obvious, it means that SQL Server is configured to accept only 2 connections. This can be changed using sp_configure 'user connections', 0. By default SQL will have that option set as 0 hence it accepts unlimited connections. Not sure who changed it in your case, check it though. disable remote connections, stop SQL Server and then start it in single user mode and try to establish a connection at the earliest and then change the options using sp_configure then stop and start SQL in normal mode.
http://sqlserver-qa.net/blogs/tools/archive/2007/09/26/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.aspx
The above link might help you begin with.
- Deepak
Deepak | Mark the answers if it helps to solve your problem |
