Microsoft SQL Server
  • 1 minute to read
  • Print
  • Share
  • Dark
    Light

Microsoft SQL Server

  • Print
  • Share
  • Dark
    Light

The Microsoft SQL Server Adapter imports device information from arbitrary SQL servers.

The following parameters are required:

  1. Mssql Domain - The hostname / domain of the SQL server
  2. Mssql port - the port of the SQL server
  3. User Name - A user name with read-only permissions
  4. Password - The user's password
  5. Mssql Database - The database to connect to
  6. Mssql table - the name of the table to fetch information from

image.png

Creating A read-only user

To connect to the SQL Server in order to create the required user, you can use Microsoft SQL Server Management Studio. If you don't have it on your local machine, you can probably find it on the machine that SQL Server is installed on.

After connecting to the server, you should do the following:

  1. In case you don't have the name of your database, expand the Databases folder which shows all the databases in this server.
  2. Navigate to the Security folder and expand it. Right-click the Logins folder and choose New Login.

image.png

  1. After choosing New Login, create a user using "SQL Server Authentication". Fill in the details and select your database from the Default Database List.

image.png

4.Navigate to the User Mapping page, and check the check box for the database that your login can access. In the Database role membership list, leave the default option public selected, and select the db_datareader check box.

image.png

  1. Click OK to create the user.
  2. Reconnect with the new user to validate that it was indeed created (File -> Connect Object Explorer)

image.png

Was this article helpful?