How to define DSN for SQL Server Named Instance using dynamic port (without specifying port)?

[gajalakshmi2901]

Hi Team,

We have a SQL Server running on a named instance and configured to use a dynamic port. I need to define a data source name (DSN) for tools like sql_exporter or other clients without explicitly specifying the port number.

Is there a way to do this so that the SQL Server Browser service resolves the instance name and directs the connection properly?

Any configuration examples or guidance would be appreciated.

[burningalchemist]

hey @gajalakshmi2901, please have a look here:

#515