asked on

Got error when I change password for SA in sql 2005 Management Studio

I have version 9.0.5000
Login into SQL Server using Windows Authentication. Is this sql server not setup for mix mode? I thought I did select that mode. But I can't remember what the sa password is. How can I reset that? Thanks

TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed for Login 'sa'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Login&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot set a credential for principal 'sa'. (Microsoft SQL Server, Error: 15535)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5000&EvtSrc=MSSQLServer&EvtID=15535&LinkId=20476

ASKER CERTIFIED SOLUTION

giladhecht

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lapucca

ASKER

Hi, I did "give the AD user all the priviliges in the server properties" but where is "script" that I need to give myself permission? Right now I still get the same error. thanks.

giladhecht

script is a button in the properties page,you press on it before pressing apply.
but it's not mandatory.

lapucca

ASKER

Hi , I didn't see the script button but I check the Map to Credential checkbox and I am able to change the password. However, the sa user is disabled. I enable and save but got error 15535, error as below:
TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed for Login 'sa'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Login&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot set a credential for principal 'sa'. (Microsoft SQL Server, Error: 15535)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5000&EvtSrc=MSSQLServer&EvtID=15535&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Pit Z

uinstall and then install new mssql with new password