caliAl Posted September 24, 2007 Share Posted September 24, 2007 As the title says I stupidly deleted the Builtin\Administrator group now can’t loginin SQL Server 2005. Is there anyway get back in? I did not setup the server up so I’m unsure what the SA password is. As a last resort could I rebuild the Master database and then over write with backup? Thanks, Alan Link to comment Share on other sites More sharing options...
JustGav Posted September 24, 2007 Share Posted September 24, 2007 Do you not perhaps have mixed mode authentication? Try with the domain admin.... Mind you I'm not a SQL expert. Link to comment Share on other sites More sharing options...
grahamc Posted September 25, 2007 Share Posted September 25, 2007 On the server itself... you should have an NT group with a name like this: [servername]\SQLServer2005MSSQLUser[servername]$MSSQLSERVER This user group has SA rights within SQL. Add yourself to this group and then you should be able to get access. The other option is, that generally speaking, as a standard most place will change the sql services to run as domain accounts, try using that. Technically speaking that group should be removed, once you have setup the security correctly! Hope this helps! Link to comment Share on other sites More sharing options...
grahamc Posted September 25, 2007 Share Posted September 25, 2007 Do you not perhaps have mixed mode authentication? Try with the domain admin.... Mind you I'm not a SQL expert. Builtin\admins is the group that allows a domain admin account access Link to comment Share on other sites More sharing options...
JustGav Posted September 25, 2007 Share Posted September 25, 2007 Builtin\admins is the group that allows a domain admin account access Like I said, I'm not an MSSQL expert... I design the big computer rooms for you lot to shove your silly SQL boxes into *grin* Link to comment Share on other sites More sharing options...
caliAl Posted September 25, 2007 Author Share Posted September 25, 2007 Emergency over I got in by starting SQL in single user mode and the used sqlcmd to run EXEC sp_addsrvrolemember 'MYDOMAIN\USER', 'sysadmin'; GO Thanks guys Link to comment Share on other sites More sharing options...
JustGav Posted September 25, 2007 Share Posted September 25, 2007 Completely... off topic... CaliAl, your avatar is going perfectly in time with the Groove Coverage track I'm listening to... *weird* Link to comment Share on other sites More sharing options...
caliAl Posted September 25, 2007 Author Share Posted September 25, 2007 lol maybe he's hijacking your MP3 player Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now