x

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.

more ▼

asked Mar 22, 2011 at 03:53 AM in Default

avatar image

binoy 1
22 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Mar 22, 2011 at 03:55 AM

avatar image

ThomasRushton ♦♦
42.2k 20 57 53

Am I correct thinking this only work's if you have local windows admin access which the OP doesnt have?

Mar 22, 2011 at 03:59 AM DaniSQL

@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.

Mar 22, 2011 at 04:01 AM ThomasRushton ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x109

asked: Mar 22, 2011 at 03:53 AM

Seen: 836 times

Last Updated: Mar 22, 2011 at 03:53 AM

Copyright 2018 Redgate Software. Privacy Policy