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."steve" <steve@.nothing.com> wrote in message
news:eFh7v7dpGHA.220@.TK2MSFTNGP05.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.
>
Connect to SQL Server as a sysadmin and change it.
alter login sa with password='Di55ab1eTh1sAcc0un7'
David

No comments:

Post a Comment