question

binoy 1 avatar image
binoy 1 asked

SA is locked out

My SA account is LOCKED and Local Administrator Account is not available.(SQLSERVER 2005/WIn2008) In this scenario, how can I log on to sql server.
login
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
http://msdn.microsoft.com/en-us/library/dd207004.aspx Basically, restart the SQL Server service in single user mode when logged into the server as a member of the local administrator group. Then you can (re-)create the appropriate SQL Server administrator account, restart the server in normal mode, and away you go.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@DaniSQL - yes. If the OP doesn't have it, then, damn. If this is one of those "segregation of duties" issues, then he needs to get his local server admin to log him in as appropriate, or to temporarily grant him Admin rights over the server.
3 Likes 3 ·
DaniSQL avatar image DaniSQL commented ·
Am I correct thinking this only work's if you have local windows admin access which the OP doesnt have?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.