MSDE 15457 error and SA logon failure, not associated with a trusted SQL server connection

Source: Internet
Author: User
Tags mssqlserver

Install MSDE on the machine.
Error: 15457, severity: 0, status: 1

The installation fails. As a result, the service is successfully started.
But cannot be connected with the query Analyzer

Result: Open the server network utility and add the TCP/IP to the started database. In this way, the query analyzer can be used to connect to the database.
However, the SA user name and password cannot be used for Logon. An error occurs.
Sa logon failed, not associated with the trusted SQL server connection

I searched the internet and found that the server was configured as a Windows logon instead of a hybrid logon.
Open Enterprise Manager
-- Right-click the server instance
-- Edit SQL Server Registration attributes
-- Select "use SQL Server and Windows Authentication"
In this way, you can

Use the Registry to modify the MSDE logon Mode
To switch Windows Account Authentication Mode to SQL Authentication mode, follow these steps:
1. Stop MSSQLServer and all other related services (such as SQLServerAgent ).
2. Open the Registry Editor.
3. Find one of the following sub-items (depending on whether MSDE is installed as the default MSDE instance or as a named instance ):
HKEY_LOCAL_MACHINE // software // Microsoft // MSSQLServer
-Or-
HKEY_LOCAL_MACHINE // software // Microsoft SQL Server // <Instance name> // MSSQLServer //
4. In the right pane, double-click the loginmode subitem.
5. In the DWORD Editor dialog box, set the value of this subitem to 2. Make sure that the hex option is selected, and then click OK. (By default, the value of the Windows loginmode registry subitem is set to 1. If the SQL Authentication mode is enabled, this value is 2 .)
6. Restart the MSSQLServer and SQLServerAgent services for the change to take effect. So far, the SQL verification mode has been switched over.

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.