locked
Problem to change sa password RRS feed

  • Question

  • Hi,
    Any advice to this problem?
    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=11.0.3000.0+((SQL11_PCU_Main).121019-1322+)&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%20SQL%20Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=15535&LinkId=20476
    
    ------------------------------
    BUTTONS:
    
    OK
    ------------------------------



    Many Thanks & Best Regards, Hua Min

    Friday, April 28, 2017 8:31 AM

Answers

  • The error did happen even if I only selected to "Enable" the sa account.

    Apparently you had mistakenly checked some more. Anyway, rather than fiddling in the UI and guessing what is going to produce, just run

    ALTER LOGIN sa ENABLE

    • Marked as answer by Jackson_1990 Thursday, May 4, 2017 3:00 AM
    Wednesday, May 3, 2017 9:05 PM

All replies

  • Use the Script button on the top of the form and the post the command that is generated, so that we can understand what you are trying to do. Mask any passwords.

    It would also help if you explained why you want to do what you are trying to do.

    Friday, April 28, 2017 10:40 AM
  • Please see:

    https://support.microsoft.com/en-us/help/956177/you-receive-an-exception-in-sql-server-2008-when-you-try-to-modify-the-properties-of-the-sql-server-administrator-account-by-using-sql-server-management-studio

    Friday, April 28, 2017 12:13 PM
  • The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.

    https://mssqltrek.com/2012/09/03/cannot-set-a-credential-for-principal-sa-microsoft-sql-server-error15535/


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Friday, April 28, 2017 12:15 PM
  • Hi,
    I then try to choose 'Map to Credential' and also to choose 'Enable account' but then I've got this

    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=11.0.3000.0+((SQL11_PCU_Main).121019-1322+)&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%20SQL%20Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=15535&LinkId=20476
    
    ------------------------------
    BUTTONS:
    
    OK
    ------------------------------



    Many Thanks & Best Regards, Hua Min

    Tuesday, May 2, 2017 4:46 AM
  • I then try to choose 'Map to Credential' and also to choose 'Enable account' but then I've got this

    And judging from the error message you get, that is not possible.

    But if you want to map sa to a credential, why does the thread title talk about changing sa password? Those are two completely different things.

    Tuesday, May 2, 2017 9:54 PM
  • The error did happen even if I only selected to "Enable" the sa account.

    Many Thanks & Best Regards, Hua Min

    Wednesday, May 3, 2017 3:45 AM
  • The error did happen even if I only selected to "Enable" the sa account.

    Apparently you had mistakenly checked some more. Anyway, rather than fiddling in the UI and guessing what is going to produce, just run

    ALTER LOGIN sa ENABLE

    • Marked as answer by Jackson_1990 Thursday, May 4, 2017 3:00 AM
    Wednesday, May 3, 2017 9:05 PM