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
Right-click on any blank space inside the ms sql server enterprise interface and select new login.
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.
Next, go to the server roles tab. And check all the server roles that you can see.
Finally, go to the database access tab. And select the database which will be managed by the user. Set the database roles to public.
Click ok. And type in the password that you inputted a while ago.
You will now see that the user that you created is already in the list.
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.