SQL Sever Create login account

Since I haven't used SQL sever for almost 2 years, I just started to feel strange again. Used to review the SQL Sever and make a personal note. Easy to review after a good time.

To create a server login account:

(Disclaimer: Create an account with the command will not, perhaps later need to add to the post.) )

1, before creating database users to detect whether to open a mixed login database.

Log on to the database as an administrator, right-click the database root to open the server properties security settings mixed login. Restart the server after you have set up a mixed login.

Restart the server, right-click on the server on the left "stop", and then right-click the server "open". This eliminates the need to restart the database in the Management service.

2, set the login account, and to set whether to login account and access to the server.

Log on to the database using an administrator, open the Coogan directory and open the security login name, and right-click "Login" to open the new login.

Create a new login account, and in the login name-new setting, the identity of the login is Windows authentication or SQL Server authentication.

I forgot to set up the database that the account is available, or you can not use the database you created the account. Set the Access database for the user in the login name-new user mapping.

Why did you create an account missing login? This still involves "login name-new" status setting. Set the "Allow connection to the database engine" and "Log on".