Query analyzer single-step debugging settings
1. Set the Server Authentication attribute to hybrid mode (window and SQL authentication)
2. Open [SERVICE] in [control panel], open [properties] of [ms SQL Server] service, and select 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 SQL Server service. In this case, 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:
A、run dcomcnfg.exe on the worker server worker;
B. 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;
C. Restart the SQL Server service;
3. Create a user with the same password as the service account on the client, for example, 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: the attempt to log on with the current password fails due to the following error: You must change the user password before the first logon.