Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter.Bij@klm.com
Starting Member
12 Posts |
 Posted - 2003-03-11 : 09:26:40
|
| Can Anyone tell me how I can reset the max-number of logins to zero; Someone accidentally changed the maxnumber of logins to 1, which is SQL-server itselfs |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-11 : 11:20:09
|
| start sql server in minimal configuration mode. (At a DOS Prompt):sqlservr -fThen use sp_configure to change the values back to whatever you want. Don't forget "reconfigure with override".Stop SQL from the prompt, and restart normally. -Chad |
 |
|
|
|
|
|
Reset max-logins to zero