1 Create SQL User
In SQL Management Studio, create an SQL user with read privileges to your LS Central Database.
Follow these steps to create the login and user
- In SQL Server Management Studio, connect to the LS Central SQL server.
- Navigate to Security > Logins.
- Right-click the Logins folder, and select New Login ....
- On the General page:
- Select a login name.
- Select SQL Server authentication.
- Enter a password and confirm it.
- Save the login name and the password for later use; you will need to enter them when running the deployment script.
- Clear the User must change password at next login check box.
- We also recommend that you clear the Enforce password expiration check box.
- On the User Mapping page:
- In Users mapped to this login > Select the LS Central source database.
- In Database role membership for 'dbname' > Check db_datareader
- Click OK.