When SQL server enables the SA account, the Microsoft SQL Server Error Code 15535 is displayed. solution:

Source: Internet
Author: User
Tags microsoft sql server 2005 management studio microsoft sql server management studio sql server management sql server management studio
Use Microsoft SQL Server 2008 to connect to a server running Microsoft SQL Server 2005.

Open the Properties dialog box and enter the SQL server administrator account. Then, Run "sa" to log on to SQL Server Management studio. You have changed to "Sa logon attribute", and then click OK.

In this case, you will receive the following error message:

Title: Microsoft SQL Server Management Studio
------------------------------
Failed to change logon 'sa. (Microsoft. sqlserver. SMO)
------------------------------
Other information: exceptions that occur when a Transact-SQL statement or batch processing is executed. (Microsoft. sqlserver. connectioninfo)
------------------------------
Creden cannot be set for the main SA. (Microsoft SQL Server, error: 15535)
------------------------------

Cause

If the ing to certificate check box is not selected on the general logon properties-sa dialog box, this problem occurs. If selected, this check box does not indicate that SQL Server 2008 will try to delete any creden。 mapped to your login creden. Because your creden cannot be set to "sa" login, you will receive an exception message. When you click OK to close this dialog box

Solution
To solve this problem, make sure that the ing to creden check box on the General Tab Of the --- logon properties-sa dialog box is selected before changing the "sa" Logon attribute and clicking OK to close the dialog box.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.