SA Password Unknown

Question

SA Password Unknown

Viewing 10 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

george sibbald (1/2/2012)
The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe us?

Feeling ignored there George? 😉

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

george sibbald SSC Guru Points: 104210 More actions · Answer 2

GilaMonster (1/2/2012)
george sibbald (1/2/2012)
The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe us?
Feeling ignored there George? 😉

yep. 🙂 Hence my little 'quotation' below.

thats my first new years resolution gone already.

---------------------------------------------------------------------

george sibbald SSC Guru Points: 104210 More actions · Answer 3

Welsh Corgi (1/2/2012)
george sibbald (1/2/2012)
The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe us?
🙁
I mentioned that I was closing the other threat and to not respond to it.
Sorry but I saw it and I believed you, I got hit with a bunch of other stuff.
Thank you very much for the good advise. I should have thanked everyone initially.

the other thread was phrased differently so it made more sense to post the solution there. I wasn't even sure you were asking exactly the same thing here. When this thread wandered round to the same solution I decided to back pauls answer up.

Anyway no matter, I've got all my toys back in the pram now.

---------------------------------------------------------------------

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Well thank you and I'm sorry for not thanking you and others.

Please accept my apology. :blush:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

george sibbald SSC Guru Points: 104210 More actions · Answer 5

Welsh Corgi (1/2/2012)
Well thank you and I'm sorry for not thanking you and others.
Please accept my apology. :blush:

of course, and my apologies for being tetchy.

---------------------------------------------------------------------

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

I tried logging in as SA after unlocking it and I got an error the the account was not associated with a trusted connection.

I checked further and realized that the SA Account is Disabled.

I tried the following and I was unsuccessful in enabling the Account.

ALTER LOGIN sa ENABLE

I get an error 15151 can't alter the login because it does not exist or you do not have permission.

How do you verify that a Command was accepted? I did not get a message was I entered the Command to Change the SA Password.

It is an instance of SQLServer 2005 Express running on Windows 7 64 bit and the Developer is a member of the Administrators Group

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 7

What authentication are you using? Mixed Mode or Windows?

SQL Express has a default of disabling the SA account in Windows authentication mode per MS: http://msdn.microsoft.com/en-US/library/ms345154(v=SQL.90).aspx

...
The SA or System Admin account is disabled by default if Windows Authentication is used. Normal users on the machine have almost no privileges on the SQL Server Express instance. A Local administrator on the server must explicitly grant relevant permissions for normal users so that they can use SQL functionality.
The SA login is a special login in SQL Server, and is a member of the system administrator (sysadmin) role. It is used predominantly in configurations that use the SQL authentication mode, and is not used in Windows authentication mode. ...

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

Brandie,

The machine is configured to use Mixed Mode Authenication.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 9

Are you logged in as a local admin / sysadmin when trying to make this change? If you read the entry, it says "local admin" must grant normal users permissions, so I'm wondering if it's required for turning on the SA account.

Also, I'm confused why the SA account is disabled if SQL was installed in Mixed Mode. It should have required a password during install. But then, I've never installed Express, so I don't know what all the prompts are for it.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 10

AHA! Try using square brackets around the login name:

http://blog.sqlauthority.com/2008/12/24/sql-server-disable-and-enable-user-sa/%5B/url%5D

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.