Error: 17809, Severity: 20, State: 1
Could not connect. The maximum number of '12' configured
user connections are already connected. The system
administrator can change the maximum to a higher value
using sp_configure.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Can someone please inform me of what to do?
The only SQL program I have running is a program called
SnapTracker.
Please advise.Hi Michael,
What version of SQL Server are you running? IF this is SQL Server 7.0, or
2000, check the sp_configure "user connections" value.
By default the run value should be 0, meaning that SQL Server will
dynamically manage user connections. Most likely you have it set to 12.
One program could create more than one connections, so the fact that only
one program running doesn't mean that there is only one connection.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
No comments:
Post a Comment