In this little How-To-Do I show how to create a new database user in SQL Server Management Studio that has read-only privileges. The prerequisite for this is SQL Server 2012 with Mangement Studio installed. In the next few weeks, I will write a corresponding test lab guide. I will make it available for download here as soon as it is ready. Here I show how to build and configure a lab environment. Here already times an excerpt…

First, start SQL Server Management Studio and log in either with the Windows account you specified during installation or alternatively with the user “sa” and the corresponding password. In the left half of the window you will find the Object Explorer. Here you expand the Security tree and open the Logins folder. Then right-click the Logins folder and click the “New Login” item in the context menu.

In the New Login window, assign a login name, e.g. User_Export, and select SQL Authentication under it. Then assign a strong password consisting of lowercase letters, uppercase letters, numbers and special characters and repeat your entry. Remove the check marks in front of Force password expiration and user must change the password at the next login. Leave the default database set to Master and select German as the default language. Then select the Server Roles page in the top left window.

In the Server Roles section, check the box in front of public and go to User Assignment page.

In the user mapping under Users assigned to this login, you select the databases to which the new user can log in, e.g. eazybusiness, mandant_2, etc. Below that, under Membership in database role for eazybusiness, you define the user’s permissions for each database. In this case, the user should be allowed to read only. So put a check mark in front of db_datareader and public respectively. You can then complete the process by clicking OK.

Do you have questions or need an individual offer? Do not hesitate to contact us.


    eBakery requires the contact information you provide to contact you regarding our products and services. You can unsubscribe from these notifications at any time. For information on unsubscribing, as well as our privacy practices and commitment to protecting your privacy, please see our Privacy Policy.*.

    • 0/5
    • 0 ratings
    0 ratingsX
    Very bad! Bad Hmmm Oke Good!
    0% 0% 0% 0% 0%

    Haben Sie Fragen oder brauchen ein individuelles Angebot? Zögern Sie nicht, uns zu kontaktieren.


      eBakery requires the contact information you provide to contact you regarding our products and services. You can unsubscribe from these notifications at any time. For information on unsubscribing, as well as our privacy practices and commitment to protecting your privacy, please see our Privacy Policy.*.

      Related Posts

      Leave a Comment

      Hat dir der Artikel gefallen?

      Dann melde dich doch zu unserem Newsletter an!

      Neben unseren Blog Themen informieren wir dich darin regelmäßig zu neuen Features und Tutorials