Why can't I create Historical Charts from MS SQL server named instance

Ensure you connect via port rather named instance

Active Console Historical Charts

Add a new database connection (Tools > Settings > Database > Manual Database Entries +)

Connection Name: any

Database: Name of your database

Vendor: SQLServer

User: <SQL Authenticated User not Windows authenticated>

Password: <password for the above user>

Servers:

Hostname: IP Address or Hostname depending on SQL Server configuration

Do not include the instance name

Port: <port> of the Instance

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

Why can't I create Historical Charts from MS SQL server named instance

Comments

Articles in this section

Related articles