Specific steps are as follows:
1. Set the server [Authentication] property to [Mixed mode] (Window and SQL authentication)
2. Open [Service] in [Control Panel] to open [MSSQLSERVER] service to open [Properties], select [Login] page, set the login as
Server local account and this account password, such as Administrator, password 123;
3. Restart SQL Server service, at this time, the service is the SQL Server service in [SQL Service Manager];
Suppose [Account] Set to Administrator
The effect of this at this time is that the server local account Administrator and the Administrator on the client (and the password of the account should be identical to the server password) can be commissioned by [Query Analyzer];
If you want the [other account], you can set it as follows:
1. Run dcomcnfg.exe on [Server];
2, click [Default Access Permissions] on the [Default Security Mechanism] to click [Edit Default] to select the account type that allows debugging, such as the UserS user type, the Sample account includes the UserS group;
3, restart the SQLServer service;
3. Create the same user as the service account password on the client, such as SAMPLE;
To do this, you can use the query analyzer's debugging function for single-step debugging.
Note: The second step is changed "Start Service Account", and the user password must be changed before the first login.
Otherwise, Event Log:
The attempt to log in with the current password failed due to the following errors:
You must change the user password before you log in for the first time.
