Add a user admin for Ms SQL 2005

In Microsoft SQL Server 2005, add an administrator (owner) user admin for database interlib. The effect is as follows:

The operation is as follows:

1) First enter database engine SQL 2005 with "Windows Authentication";

2) Point Open Database Node-"Security/Login Name-" Right click "Login Name"-"New login Name"-"SQL Server identity Authentication-" Login: admin, Password: 333555, cancel "Enforce password Policy", default database Select "Interlib", (2) Shown:

Figure (2) Login admin

3) on the "User Mapping" tab, tick "Interlib" and database role membership tick "db_owner", as shown in (3):

Figure (3) Set admin permissions to "db_owner"

4) Refresh the database, you can see "interlib/Security/user", there is admin.