Concurrent Logons

[FireBlade954]

I'm using SQL2000 SP2 on Win2K Adv Server SP3. We run an application that accesses an SQL database. As of this morning, it only allows one user to be logged in at a time. Concurrent connections is set to zero on the server. This has happened once before and previously I had to rebuild the server from scratch to fix it. I tried uninstalling SQL and restoring the database but that didn't work. I had to format and re-install the OS as well. Obviously, I don't want to do this again, so any help offered would be great.

Thanks

 

[MeanGreen]

It sounds like your database has been set to single user mode. In Enterprise manager try right clicking on your database and choose properties. Then under the options tab, make sure Single User is not checked.

Hope this helps.

 

[FireBlade954]

I have checked that. Strange thing is that all databases on this server are behaving the same way. I have another server I use as a backup server and it is fine using the same data. This leads me to believe that the problem is accross the server rather than database specific.

 

[FireBlade954]

I fixed it by applying SQL Service Pack 2 again. I have no idea why this fixed it or what the cause was, but am happy to have a quiet phone again.

 

[fluteplr]

If I were you I would start looking for and changing all the Admin passwords. It seems unlikely to me that this is happening all by itself.