changing the 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.What is the error message you are getting? Are you connecting as a member of
sysadmin? Try connecting using Windows Authentication as a local
Administrator.
Ben Nevarez, MCDBA, OCP
Database Administrator
"steve" wrote:

> 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.
>
>
>|||maybe if you are an administrator of SQL Server, you can change the password
of another account. (using the management console)
so if you use the local windows administrator account, then you can
certainly access the server as an administrtor, then you can change the
password.
but if your security model use only SQL accounts and you don't have another
account with enough privilege, then you can't change the password of another
account.
I hope this will help you
"steve" <steve@.nothing.com> wrote in message
news:uifjW6dpGHA.4196@.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.
>
>|||Hi Steve,
Does this help?
EXEC sp_password NULL, 'newpass','sa'
Need to be a sysadmin to run this however.
David Tan,
Production DBA
Webcentral
www.webcentral.com.au
"steve" wrote:

> 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.
>
>
>

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

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...
>