Creating service account for MSSQL monitoring in Nectus

,

Creating MS SQL DB Monitoring Service Account for Nectus

 

Step 1 : Connect to MS SQL Server

 

 

Step 2 : Under “Security” tab, open “Logins” section.

 

 

Step 3 : Right-click on “Logins” section , and select “New Login”.

 

 

Step 4 : Fill in the required information for the new account.

 

 

Step 5 : In “New Login” window “General” tab specify:

  1. Specify the Login Name.
  2. Select SQL Server authentication.
  3. Uncheck the “Enforce password policy”

 

 

Step 6: For “Server Roles” select “sysadmin” and “public”.

 

 

Step 7: for “User Mapping” select the database and also select database role as “db_datareader”.

 

 

/by