Thursday, March 8, 2012

Changing SA Password in SQL 2005

Hello, All
Is there a way to change the sa password in SQL 2005 without knowing the
existing password?
I tried everything I can find online to change the password but nothing
works.
This is on my test server so I am opened to anything.
Thank you.Not one that I've ever known of. That would be a huge security
hole...imagine walking up to any-ol' SQL Server instance and setting your
own 'sa' password.
Bill
"steve" <steve@.nothing.com> wrote in message
news:uG1LP8dpGHA.3600@.TK2MSFTNGP04.phx.gbl...
> Hello, All
> Is there a way to change the sa password in SQL 2005 without knowing the
> existing password?
> I tried everything I can find online to change the password but nothing
> works.
> This is on my test server so I am opened to anything.
> Thank you.
>|||A CONTROL SERVER grantee is able to change the sa password without knowing
the current password. (A sysadmin has CONTROL SERVER.)
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill Blakey" <bill.blakey@.sage.com> wrote in message
news:e75gXhepGHA.516@.TK2MSFTNGP05.phx.gbl...
> Not one that I've ever known of. That would be a huge security
> hole...imagine walking up to any-ol' SQL Server instance and setting your
> own 'sa' password.
> --
> Bill
> "steve" <steve@.nothing.com> wrote in message
> news:uG1LP8dpGHA.3600@.TK2MSFTNGP04.phx.gbl...
>

No comments:

Post a Comment