Add a user admin to Ms SQL 2005

In Microsoft SQL Server 2005, add an administrator (owner) user admin to the database interlib. Effects such as the following:

Actions such as the following:

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 name: admin,password:333555. Cancel "Enforce password Policy", default database Select "Interlib", (2) See:

Figure (2) Login admin

3) on the "User Mappings" tab, tick "Interlib", Database role membership tick "db_owner", (3) What you see:

Figure (3) Set admin permissions to "db_owner"

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

Add a user admin to Ms SQL 2005