Add a user in MS-SQL (ConnectWise, Kaseya, TigerPaw, & N-Able Users)

Brian Dosal -

Here are the steps to setup a user in MS-SQL

 

Step 1 - Open Microsoft SQL Server Management Studio.

 

Step 2 - Right click the Logins folder under the Security folder, then click ‘New Login…’.

steps1-21.jpg

Step 3 - Check the ‘SQL Server authentication’ radio button.  (Windows Authenticated users cannot be supported.  Due to the nature of our agent, Windows Authenticated users work sometimes, at best.  SQL Server Authenticated users are the only way we can guarantee a correct login to the database).

 

Step 4 - Uncheck the ‘Enforce password policy’ option (if unable to leave unchecked, just uncheck the requirement of ‘changing password in next log in’).

 

Step 5 - Fill in Login Name and password.

steps3-5.jpg

Step 6 - Select the ‘User Mapping’ page in the left panel.

 

Step 7 - PERMISSIONS - Click the checkbox next to each database the agent needs access to, ensuring that the ‘db_datareader’ checkbox is selected below for each database.  For Connectwise Datasource users wanting to use TIME ENTRY information for reporting - please allow for additional SQL permissions to use stored functions.  Video here - http://goo.gl/P3xeP

 

Step 8 - Click OK, and you’re done.

steps6-8.jpg

Have more questions? Submit a request

Comments

Powered by Zendesk