SQL Server R2 New user and specifies the user's database

First, the experimental environment

Operating system: Windows Server 2008

Database: SQL Server R2

Second, the specific steps:

1. Open SQL Server Management Studio and log in as Windows authentication, such as:

2. Under Object Explorer, right-click Security ==> logon name ==> New login:

3. After opening the new Login dialog box, enter the appropriate login name, password, and default database on the right side of the general

4. Under User Mappings tab

5. Under Status tab

Confirm when the input is complete.

6. Under Object Explorer, right-click the instance name and select Properties

After selecting the hybrid authentication mode under the Security tab, determine

7. Restart the SQL Server service

Get!

SQL Server R2 New user and specifies the user's database