SQL connection between ScanEngine and DB Test

Owned by Conor McCann
Last updated: May 04, 2018
1 min read

In environments where ScanEngine reside on dedicated server and iQSonar DB on dedicated server. time to time we can experience an connection issues from ScanEngine to DB server and running stored proc on DB server "exec sp_who2" might not give us an answer why we can't see the user used to run ScanEngine connection to DB.

Step-by-step guide

Here is simple way of testing the connection without having to install any SQL tools.

  1. On ScanEngine server create an blank file with UDL file name extension.
  2. Double click on the file.
  3. Popup window will show up as shown bellow.

4. Fill out the Server name in section 1.

5. Choose the correct Authentication, either SQL Auth or Windows integrated ( Make sure you are logged in as the user you want to test connection with)

6. If the connection to the SQL server is established the section 3; will give a dropdown menu with all DB's running on the server specified in section 1.

7. Hit Test connection so the tool will attempt to connect to specified DB with set credentials.