• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 766
  • Last Modified:

SQL 2005 Max 2 User connections - need more

Please help! I am new to SQL.
I have a windows 2003 server with SQL 2005. All service packs and updates. I recently added VERITAS backup agent to do daily backups properly. I rebooted the PC after being up for 66 days. After the reboot I get the following message:
Could not connect because the maximum number of '2' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]

I have tried to login to SQl server management studio, but it does not let me
I have tried using the sp_configure with in Analysis services, no luck
I have tried the run command
I have tried from the CMD prompt – sp_configure is not recognized!

Any suggestions?
Thank you in advanced!
D.
0
DarrylRT
Asked:
DarrylRT
1 Solution
 
DarrylRTAuthor Commented:
All,
The answer was to disable the network cards and then open up "SQl Server Management Studio". Once I disabled the two network cards I was able to get the properties and make the connections adjustment. After rebooting the PC everything is now working. Hope this will help someone else in the future!

Thank you,
Darryl
0
 
Anthony PerkinsCommented:
Great!  Now, please close the question.  Here is how :

I answered my question myself. What do I do?
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70
0
 
GranModCommented:
Closed, 500 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now