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.