1. Start SQL Server Management Studioand you will see
2, there is an authentication. There are two options in this authentication drop-down list:
Windows authentication and SQL Server authentication .
What is the difference between them:
Windows Authentication means: You can log in using the user name and password of your computer's Windows system. If your computer does not have a password set, then you do not need to enter a user name and password, directly click the connection can log in.
We typically use the second type of authentication: SQL Server authentication . Because, if we later use the database on other computers, we can also use. (How we use Windows authentication , its disadvantage is that portability is not strong.) )
It is most reasonable to log in with a user name and password created with SQL Server .
3. Select authentication First:Windows authentication . Then click Connect .
Then choose: Security -- login name . Right-click login , select the new login name inside
Select New SQL Server authentication and enter a login name and password
We must remove the check box with the mandatory password expiration (X)
4, to the server, click the right mouse button, select the properties inside
5, enter the security . As you can see, the default in Server Authentication is the Windows authentication Mode , which is changed to SQL Server and Windows Authentication mode. shutdown software Restart will not take effect
6, Control Panel, management tools, services, locate the SQL Server Browser Service, change the startup type to Automatic, and start
SQL Server Logon Failure issue