Im trying to put sql 2005 master database in single user mode. this is what i have done so far with no luck.

1. stop all related SQL services //so that nothing can log in before i do
2. from cmd prompt i issue command net start mssqlserver -m or /m
3. when i log into studio manager i notice master still isnt in single mode
4. i tried to put it in single user mode via the GUI also wont allow me

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it. If you have to use of the Setup command to rebuild the master database has changed in this Microsoft SQL Server release. Without the master page you can not successfully start the SQL server.

SQL server 2005 is the best database. Master database is the one which is absolutely must have database. Without SQL Server database can not be started. It creates master, model, msdb, tempdb resource and distribution.

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum

Featured Links*

Looking for more Windows Networking info?

Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing!View a sample newsletter.