Create SQL-login for SuperOffice DB

We need to create an appropriate database login to be used when accessing data the in the SuperOffice database.

PS! Please do not attempt to use an existing login f. ex. crm7. Although this may work, the required privileges and  language settings differ.

1) Start up SQL Management Studio.
Go to Security -> Logins. Right-click Logins and select “New login…”.

 

2)  Enter a sensible login name, and a password that respects the password policy.
Uncheck “Enforce password expiration”.
Set the default database to be the SuperOffice database.
PS! Set the default language to English.

 

3)  Go to the User mapping page.
Map the SuperOffice database to the user.
Give the user membership for the role “db_datareader”.