troubleshooting Question

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

Avatar of lapucca
lapucca asked on
Microsoft SQL Server 2005
5 Comments1 Solution1554 ViewsLast Modified:
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:


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:
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros