"SQL SERVER" FAQ

Account

Lazy by default, all default features are installed on the virtual server, so there is no process to set up the SA account, which naturally only enters the database from Windows authentication. Then you have to add login privileges to the SA account.

The steps are as follows:

1. Windows Authentication login database, expand instance-"security, find the login name, expand to see that the SA account is actually added by default, but the password is the default

2. Double-click the sa account, enter settings, first modify the sa password

3. Cancel the "Enforce Password policy"

4. Select the Page Check Status page to make sure that "allow connection to Database engine" and "login" are selected as "Grant" and "enabled" respectively

5. After completing this, it is important to remember the right-click property on the current DB instance to modify server authentication in the Security page for SQL Server and Windows Authentication mode.

6. Restart the DB instance.

If you forget to do the fifth step, use the sa login times 18456 error.

"SQL SERVER" FAQ