Creating new users in ms sql 7

This is the final part of the tutorial series on ms sql 7 database. In this tutorial, I’m going to show you how you can create new database users using sql server enterprise manager. This will allow you to login as an administrator to an application which uses sql server authentication before you can access it.

First, you need to expand  the console root  > Microsoft SQL Servers > SQL Server Groups > Name of your computer (mine is NREW) > Security >Logins

image

Right-click on any blank space inside the ms sql server enterprise interface and select new login.

image

Type in the name that you want to use. Mine is WERN. Then select the authentication method as SQL Server authentication. Type in the password that you want to use. Make sure that you can remember this password.

image

Next, go to the server roles tab. And check all the server roles that you can see.

image

Finally, go to the database access tab. And select the database which will be managed by the user. Set the database roles to public.

image

Click ok. And type in the password that you inputted a while ago.

image

You will now see that the user that you created is already in the list.

image

You can use the user that you created to authenticate yourself whenever an application which connects to ms sql 7 requires you to input a password or select an administrator.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s