• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

SQL 2005 master database

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
duster
Just Arrived
Just Arrived


Joined: 06 May 2005
Posts: 0


Offline

PostPosted: Fri Apr 23, 2010 6:40 pm    Post subject: SQL 2005 master database Reply with quote

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

any ideas?
Back to top
View user's profile Send private message
operat0r2
Just Arrived
Just Arrived


Joined: 26 Apr 2010
Posts: 0


Offline

PostPosted: Mon Apr 26, 2010 5:56 pm    Post subject: Reply with quote

maybe the user can't run in single mode you can try sysrun.exe c:\windows\cmd.exe and start it from the command line and not from net start etc ...

you can also use M$ process explorer and run it as SYSTEM and see if any SQL threads are open just search for SQL and kill any tasks you find Smile

also google and make sure you got the syntax right to start sql as single I dont thing its net start ... from what I can remember ?
Back to top
View user's profile Send private message Visit poster's website
abrasmith89
Just Arrived
Just Arrived


Joined: 17 Dec 2010
Posts: 0


Offline

PostPosted: Fri Dec 17, 2010 11:58 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
racyhall11
Just Arrived
Just Arrived


Joined: 18 Dec 2010
Posts: 0


Offline

PostPosted: Sat Dec 18, 2010 7:28 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


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

Community Area

Log in | Register