April 28, 2005 at 8:22 am
people,
help !!!!
i manually changed the max connection from my sql server, i just put 1 (one)
and ... i can't access it anymore.. i can't enter, i can't do anything.. help!!
where i can change it back ?
my server is gonne!!!
thank you.
April 28, 2005 at 8:44 am
1. Try to start SQL Server from command prompt like sqlservr.exe -E -m in single use mode.
2. Login to SQL Server with Query Analyzer.
3. Run follow command.
sp_configure 'allow update', 1
reconfigure with override
sp_configure 'user connections', 0
reconfigure with override
sp_configure 'allow update', 0
reconfigure with override
4. Go back command windows and press CTRL-C to stop SQL Server.
5. Restart SQL Server.
April 28, 2005 at 3:06 pm
If that gives you problems, be sure you close the object browser in QA. It uses it's own connection.
April 29, 2005 at 5:27 am
people,
thanks...
Allen, i din´t use your response, but thanks..
i just copied some files from a friend (master db.. and others, the default db), i was screaming, trying everything... and worked... lost my users, but that i can fix.
well, now i know how to fixed.
thank you guys
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply