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

  1. In SQL Server Management Studio, connect to the LS Central SQL server.
  2. Navigate to Security > Logins.
  3. Right-click the Logins folder, and select New Login ....
  4. 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.
  5. 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
  6. Click OK.

 

< Back

Next >