Password for SA

Can I find out the password for the "sa" account from Enterprise Manager?
When I originally installed the 120 evaluation license for SQL Server, I did
so under Windows Authentication. Up until recently I have only connected to
the server through the start menu using Enterprise Manager and I am never a
sked for a password. I assu
me that is because it sees that I am already authenticated by my Windows XP
login.
Thanks for your help with this.You can't retrieve the password. You can, however, reset the sa password
using sp_password. Open Query Analyzer, connect as a windows administrator
account, and run:
EXEC sp_password 'sa', 'newpassword'
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jack Wachtler" <jack_wachtler@.comcast.net> wrote in message
news:F57EAC27-8ED5-4E7C-9A95-3340A4527CA9@.microsoft.com...
> Can I find out the password for the "sa" account from Enterprise Manager?
> When I originally installed the 120 evaluation license for SQL Server, I
> did so under Windows Authentication. Up until recently I have only
> connected to the server through the start menu using Enterprise Manager
> and I am never asked for a password. I assume that is because it sees that
> I am already authenticated by my Windows XP login.
> Thanks for your help with this.|||Aaron
Thanks for your answer it was very helpful.
However in my case I got the following error message
Server: Msg 15007, Level 16, State 1, Procedure sp_password, Line 40
The login 'PONTIAC\kvaughn2' does not exist.
The above listed account is a Administrator. The OS is Windows 2000 sp4.
Help?
-- Aaron Bertrand [MVP] wrote: --
You can't retrieve the password. You can, however, reset the sa password
using sp_password. Open Query Analyzer, connect as a windows administrator
account, and run:
EXEC sp_password 'sa', 'newpassword'
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jack Wachtler" <jack_wachtler@.comcast.net> wrote in message
news:F57EAC27-8ED5-4E7C-9A95-3340A4527CA9@.microsoft.com...[vbcol=seagreen]
> Can I find out the password for the "sa" account from Enterprise Manager?
> did so under Windows Authentication. Up until recently I have only
> connected to the server through the start menu using Enterprise Manager
> and I am never asked for a password. I assume that is because it sees that
> I am already authenticated by my Windows XP login.|||This happens when you connect to the server as PONTIAC\kvaughn2, and run
sp_password as I suggested, changing the password for the login sa? Or are
you mixing things up and trying to change the password for kvaughn2? You
can't do the latter, this is controlled by Windows, since this is a Windows
user, not a SQL login.
My impression from your initial post is that you wanted to change the
password for the sa account, not for a Windows account.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kevin Vaughn" <kvaughn@.pontiac.k12.mi.us> wrote in message
news:9908BC29-CE30-43BB-9C03-F4CA8797C4D0@.microsoft.com...
> Aaron
> Thanks for your answer it was very helpful.
> However in my case I got the following error message
> Server: Msg 15007, Level 16, State 1, Procedure sp_password, Line 40
> The login 'PONTIAC\kvaughn2' does not exist.
> The above listed account is a Administrator. The OS is Windows 2000 sp4.
> Help?
> -- Aaron Bertrand [MVP] wrote: --
> You can't retrieve the password. You can, however, reset the sa
> password
> using sp_password. Open Query Analyzer, connect as a windows
> administrator
> account, and run:
> EXEC sp_password 'sa', 'newpassword'
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "Jack Wachtler" <jack_wachtler@.comcast.net> wrote in message
> news:F57EAC27-8ED5-4E7C-9A95-3340A4527CA9@.microsoft.com...
> Manager?
> Server, I
> Manager
> sees that
>
>|||Aaron your imperssion is correct I am only trying to change the "sa" passwor
d. Additionally thinking that there might be a problem with the kvaughn2 acc
ount I tried a different administrator account and got the same result. Tha
nk you for replying to my p
ost.
Kevin
-- Aaron Bertrand [MVP] wrote: --
This happens when you connect to the server as PONTIAC\kvaughn2, and run
sp_password as I suggested, changing the password for the login sa? Or are
you mixing things up and trying to change the password for kvaughn2? You
can't do the latter, this is controlled by Windows, since this is a Windows
user, not a SQL login.
My impression from your initial post is that you wanted to change the
password for the sa account, not for a Windows account.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kevin Vaughn" <kvaughn@.pontiac.k12.mi.us> wrote in message
news:9908BC29-CE30-43BB-9C03-F4CA8797C4D0@.microsoft.com...[vbcol=seagreen]
> Aaron
> Thanks for your answer it was very helpful.
> However in my case I got the following error message
> The login 'PONTIAC\kvaughn2' does not exist.
> password
> using sp_password. Open Query Analyzer, connect as a windows
> administrator
> account, and run:
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
> news:F57EAC27-8ED5-4E7C-9A95-3340A4527CA9@.microsoft.com...
> Manager?
> Server, I
> Manager
> sees that|||Your result doesn't make sense to me. If you can successfully connect to
master, and kvaughn2 is in fact an administrator account and has not been
explicitly denied any privileges, you should be able to successfully run
sp_password.
I may have botched the syntax I sent. Try this one:
EXEC sp_password NULL, 'sa', 'newpassword'
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kevin Vaughn" <kvaughn@.pontiac.k12.mi.us> wrote in message
news:8D6552A5-F16A-4A12-8188-27E68F9D291D@.microsoft.com...[vbcol=seagreen]
> Aaron your imperssion is correct I am only trying to change the "sa"
> password. Additionally thinking that there might be a problem with the
> kvaughn2 account I tried a different administrator account and got the
> same result. Thank you for replying to my post.
> Kevin
>
> -- Aaron Bertrand [MVP] wrote: --
> This happens when you connect to the server as PONTIAC\kvaughn2, and
> run
> sp_password as I suggested, changing the password for the login sa?
> Or are
> you mixing things up and trying to change the password for kvaughn2?
> You
> can't do the latter, this is controlled by Windows, since this is a
> Windows
> user, not a SQL login.
> My impression from your initial post is that you wanted to change the
> password for the sa account, not for a Windows account.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "Kevin Vaughn" <kvaughn@.pontiac.k12.mi.us> wrote in message
> news:9908BC29-CE30-43BB-9C03-F4CA8797C4D0@.microsoft.com...
> 40
> sp4.
> sa|||I can't get anything right these days.
EXEC sp_password NULL, 'newpassword', 'sa'
I got it right in another thread, I'm sure...
In any case, it's always useful to tell us what version of SQL Server you
are using...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Excellent! with the command below the message box displays "password change
d"
-- Aaron Bertrand [MVP] wrote: --
I can't get anything right these days.
EXEC sp_password NULL, 'newpassword', 'sa'
I got it right in another thread, I'm sure...
In any case, it's always useful to tell us what version of SQL Server you
are using...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/