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.

Am Wed, 12 Jul 2006 14:10:19 -0400 schrieb steve:

You could use SQL Server Management Studio, connect with
windows-Authorization to the server/instance, then under Security/Login (i
don't know exactly the names, i have a german version), you can right-click
on "sa", select "properties" and then you can change the password.

bye, Helmut

In addition to Helmut's suggestion, there are two other ways for changing the
'sa' password:

1) USE [master]
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'blah' MUST_CHANGE
GO

2) From a command shell (start > run > cmd)
    OSQL -S <YOUR_SERVERNAME_GOES_HERE> -E
    1> EXEC sp_password NULL, 'blah', 'sa'
    2> GO

Regards,

Keith Wilson
Microsoft SQL Server

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


Show quoteHide quote

Sql 2005 can't update maintenance plans?
backup remote database to local hard drive or local database?
Error 0x80041010 WinMgmt when launching SQL SERVER MANAGEMENT STUD
How do you insert a carriage return in Management Studio?
Unicode encoding with SQL Management Studio