Add a user admin to Ms SQL 2005

Source: Internet
Author: User

Tags: role enter ext engine fill ACK Pop SOF technology share

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: