CODEWITHSUNDEEP
sql-server-2008sa
y_zyx
y_zyx

Reputation: 642

sql server 2008 enable sa account

I logged into my PC with administrator account. When I try to enable the 'sa' account of SQL Server 2008, I get the following error:

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.1600.1+((KJ_RTM).100402-1540+)&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.1399&EvtSrc=MSSQLServer&EvtID=15535&LinkId=20476

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

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

Upvotes: 1

Views: 8586

Answers (2)

silverfox
silverfox

Reputation: 5272

Have you tried Microsoft KB956177 before?

To resolve this issue, make sure that you select the Map To Credential check box on the General tab of the Login Properties - sa dialog box before you change the "sa" login properties and then click OK to close the dialog box.

Upvotes: 4

Md. Humayun Rashid
Md. Humayun Rashid

Reputation: 1

To resolve this issue, make sure that you select the Map To Credential check box on the General tab of the Login Properties - sa dialog box before you change the "sa" login properties and then click OK to close the dialog box.

Upvotes: 0

Related Questions