Geneos - Why can't I connect Express Reports to my MS SQL server named instance

The end of support for the Express Reports feature of Gateway ended on 31 December 2021.

https://docs.itrsgroup.com/docs/all/compatibility-matrix/geneos/compat-matrix.htm#Removed_features_..37

Ensure you connect via port rather named instance

Express Reports

Configure the datasource in the GSE

Name: <Name>

Options: SQLServer

Server Name: <IP Address>

Database name: <Database name>

Port: <port of instance>

Authentication:

User name: <SQL Authenticated User not Windows authenticated>

Password: <password for the above user>

By default named instances will be set to use dynamic ports. This means when the SQL Server restarts it can start on a different port. This will cause connections to fail, so best to set the instance to use a specific port

Articles in this section

Geneos - Why can't I connect Express Reports to my MS SQL server named instance

Comments

Articles in this section

Related articles