By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

SA Password?

P: n/a
Folks,

Sorry 'bout this. I'm sure it must be an FAQ, but I can't find the answer
after many hours of looking :-(

I don't know the SA password any more. Is there a mechanism for setting (or
resetting) this to a known value? My assumption is that the encryption is
sufficiently strong that it can't be discovered from viewing the data ?

Yes - I have physical access to the machine, with Administrator logon
privilege.
Any help would be most welcome!

Season's Greetings, etc

HazBin
Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
> Yes - I have physical access to the machine, with Administrator logon
privilege.
Try to connect using Query Analyzer with a trusted connection. This will
allow sysadmin access unless you've removed BUILTIN\Administrators SQL
access. You can then change the 'sa' password with:

EXEC sp_password, NULL, '<new sa password>', 'sa'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"HazBin" <Ha****@had.net> wrote in message
news:Xn*************************@212.23.3.119... Folks,

Sorry 'bout this. I'm sure it must be an FAQ, but I can't find the answer
after many hours of looking :-(

I don't know the SA password any more. Is there a mechanism for setting
(or
resetting) this to a known value? My assumption is that the encryption is
sufficiently strong that it can't be discovered from viewing the data ?

Yes - I have physical access to the machine, with Administrator logon
privilege.
Any help would be most welcome!

Season's Greetings, etc

HazBin

Jul 23 '05 #2

P: n/a
Hey "hasbeen" haha...just kidding. Here is your answer.
Sorry 'bout this. I'm sure it must be an FAQ, but I can't find the answer
after many hours of looking :-(


SQL default is to have builtin\administrators as SA. So if you add yourself to
the local administrator of the SERVER (controlled by the OS), then you should
have SA rights. Then you can go into the Enterprise Manager and change the SA
password to your heart's content.

Joe
MCDBA, MCSD, OCP


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.