Today, we will introduce how to perform one-step debugging through the debugging function of the query analyzer. This is also a very practical technique. Q: How can I perform one-step debugging through the debugging function of the query analyzer? A: The specific steps are as follows: 1. Set the server [authentication] attribute to [hybrid mode] (window and SQL identity)
Today, we will introduce how to perform one-step debugging through the debugging function of the query analyzer. This is also a very practical technique. Q: How can I perform one-step debugging through the debugging function of the query analyzer? A: The specific steps are as follows: 1. Set the server [authentication] attribute to [hybrid mode] (window and SQL identity)
Today I will introduce howPassQueryAnalyzerOfDebuggingFunctionProceedSingle StepDebuggingThis is also a very practical technique.
Q: How can IPassQueryAnalyzerOfDebuggingFunctionProceedSingle StepDebugging?
A: The procedure is as follows:
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: 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 ).Pass【QueryAnalyzer]ProceedDebugging;
If you want other accountsDebugging, You also need the following settings:
1. Run dcomcnfg.exe on the worker server;
2. In [default security mechanism] [default access permission], click [edit default value] to select allowDebuggingFor example, the users user type. The sample account contains the users Group;
3. Restart the sqlserver service;
4. Create a user with the same password as the service account on the client, such as sample;
You can do this.PassQueryAnalyzerOfDebuggingFunctionProceedSingle StepDebugging.
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 will fail due to the following error:
You must change the user password before the first logon.