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 |
|
ewe1d@yahoo.de
Starting Member
17 Posts |
 Posted - 2004-10-27 : 08:21:53
|
| Hi,Have just applied Service Pack 3a to an SQL 2000 Developer Edition, rebooted and SQL Server has started automatically, but in Single-User mode? Why has it done this and how can I put it back in multi-user mode?(I backed up Master after the reboot)Would appreciate any helpChidd |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2004-10-27 : 09:17:16
|
| TryUSE masterEXEC sp_dboption 'Northwind', 'single user', 'FALSE'Or In EM right click the database > properties then goto the options tab and uncheck the restrict accessAndy |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-10-27 : 09:49:56
|
| Is it the server itself, or a database that is in single user mode? If the SQL Server is in single user mode, only one connection can be made to the entire server. If it's a database, people can connect to other DBs, but only one can connect to the DB which is single-user.The ways to correct this are different, so it will help if you tell us which it is? |
|
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-10-28 : 03:43:37
|
| Hi,it's the server itself. I am working as the administrator and connect to the server in Ent. Manager, I can't then open a connection in Query Analyser. I restarted the server and the problem went away but it would be nice to know why?Chidd |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2004-10-28 : 04:34:30
|
Found this on Microsoft as an addition to Readme for SP3 quote:
Setup Runs in Single-User ModeTo install SQL Server 2000 SP3, SQL Server must be in single-user mode. The Setup starts SQL Server in single-user mode. To prevent any other application from having control of the first server process ID (SPID), complete the following tasks: • Close all applications that are running, including third-party monitoring tools on the computer that is running SQL Server. • Disconnect or shut down all the application servers that connect to the computer that is running SQL Server. • Disconnect the network cable, if you can. You may also change any logon passwords for connected application servers; however, you must remember to change them back to their original password after the setup completes.
Doesnt say anything about SQL server not returning to a "normal" state or about Developer Edition[url]http://support.microsoft.com/kb/330022/EN-US/[/url] |
|
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-10-28 : 05:23:44
|
| Hi,Maybe that's it. I let the installer stop the SQL services for me, then it installed the service pack and did a reboot.Thanks for the link.. |
|
|
|
|
|
|
|
|
Server single-user