SQL Server password and logon Problems

1. The system login fails. If the login fails, the login fails after the system password is changed. That is to say, we had previously installed the SQL server software and, you can log on through the Windows Authentication identity, and then modify the Windows Password, and then you will not be able to log on.

Solution:

Click Start> right-click computer> Manage ". Go to the following page:

Click "service and application"-click "service ". Go to the following page:

Find "SQL Server (MSSQLServer)" from the service and right-click "properties ". Go to the following page:

Click "Log on"-change the password. The operation interface is as follows:

Click OK to complete the operation. If you want to try it, you may need to restart the computer several times (I have restarted it several times ).

Principle: database system software is mainly divided into two parts: foreground and background. Password and other configurations are required for connecting to the background at the front end, similar to the parameters required for connecting to the background of the database when we develop the application software (some are in the Code; some are outside the Code .) You can modify these parameters.

2. Sometimes we cannot start SQL Server. The possible reason is that we open another protocol. At this time, we should disable it.

Solution:

Repeat the operation in step 1 to go to the interface of the first image.

Click "services and applications"> "SQL Server Configuration Manager"> "SQL SERVER network configuration"> "MSSQLServer protocol ". The following page is displayed:

Disable. Select via -- Right-click -- disable. Operation completed. If it still fails (or cannot be restarted) and the background cannot be started manually, we recommend that you uninstall it and reinstall it.

Principle: Virtual Interface Architecture (VIA) virtual interface adapter, which is no longer used now and has been replaced. "It was intended to adapt to different hardware vendors and be suitable for different networks, or Java virtual machine, cross-platform, etc., the results are too idealistic, the goal is too big to achieve more complex, and now the TCP/IP protocol is dominant application, so it is replaced-from others ". Now, the adapter is the network card, and the virtual interface is set up as a virtual network card. We can add many types of virtual network cards. The specific operation in win7 is to add it in "Settings manager -- operation -- add obsolete hardware.

3. log on to the SA. SA can log on before, and then login fails.

Solution:

Log on to the SQL server console with win and click "security"-click "Logon Name ". The following page is displayed:

Double-click sa or right-click SA and click Properties. Go to the following page:

Change the password again and click OK. This is generally the case. Of course, to prevent beginners from getting out of date without easy operations, we 'd better click "status" on the drawing to go and check it out. The interface is as follows:

Make sure the status is granted and enabled. Click OK. To avoid unintentional operations by beginners, we recommend that you perform the following operations.

Server -- Right-click Properties (Server property page) -- click "security ". Configure the interface as shown in Figure

Click "OK", right-click "server", and click "restart"

The server mentioned above indicates the selected item.

Principle: you can log on with SA at the beginning, but you won't be able to log on later, mainly because of the "force password policy implementation" and "force password expiration" features. Enforce the password policy: it specifies some restrictions on password settings, such as length. Force Password Expiration: it specifies the password validity period.