Possible errors and causes when testing the SQL connection with IROSQL

[Aime]

When testing the SQL connection with IROSQL, you may run into some errors.

[Aime · Accepted solution]

Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server [..]

Possible Causes:

• Need to run CMD as the user that is set in the password configuration OR be logged into the server session and running CMD as the user set in the password configurations.
• The command line is mistyped. In the example picture below, it is because there is a / instead of a \ in this line "192.168.19.4/Monitor".

Error: Login failed for user [...]

• User that is running CMD doesn't have permission to the database.

Error: Invalid object name 'Pool1'

Possible Cause:

• The table name is incorrect or does not exist in the database.

Error: Database 'QoEMetricsB' does not exist. Make sure that the name is entered correctly.

• Name of database is incorrect or doesn't exist.