Mapping the login to the database

The next thing we need to do is to properly map this login to the TestMakerFree database we added earlier. From the navigation menu to the left, switch to the User Mapping tab. Click on the checkbox to the right of the TestMakerFree database, and then write TestMakerFree in the User cell and assign the db_owner membership role:

As soon as we click on the OK button, a new TestMakerFree user will be added to the TestMakerFree Database with full administrative rights.

We can easily confirm that by going back to the root Databases folder and expanding it to TestMakerFree | Security | Users:

That's it! Now we'll be able to access our brand new TestMakerFree database with a standard connection string using the credentials we just created.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.9.169