Query why analyzer cannot be debugged in one step _ MySQL

Source: Internet
Author: User
To query the reason why analyzer cannot be debugged in one step, take the following steps:
1. set the server authentication attribute to hybrid mode (window and SQL authentication)


2. on the control panel, open service and open properties for the MSSQLSERVER service. on the logon page, set the logon identity to the local account and password of the server, such as administrator and password 123;
3. restart the sqlserver service. at this time, the service refers to the SQL server Service in [SQL service manager;
Assume that the [account] is set to administrator.
The result is that the administrator of the local server account and the administrator on the client (and the password of this account must be the same as the server password) can be debugged through [query Analyzer;
If you want to enable debugging for [other accounts], you also need the following settings:
1. run dcomcnfg.exe on the worker server;
2. in [default security mechanism], click [edit default value] on the right side of [default access permission] to select the account type that allows debugging, such as the users user type. the sample account contains the users Group;
3. restart the sqlserver service;
3. create a user with the same password as the service account on the client, such as sample;
In this step, you can perform one-step debugging through the debugging function of the query analyzer.

Note: In step 2, change "start service account". you must change the user password before the first logon.
Otherwise, event log:
An attempt to log on with the current password fails due to the following errors:
You must change the user password before the first logon.

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.