[solved] Predefined MSSSQL Server Database Connection - How To set connection port

[a.guelle]

Hi Advanced Installer support team,

when I am setting up a predefined MSSQL database connection to run some queries, I am not able to set a connection port. The field stays static on "automatic" and is not changeable.
But the automatic port recognition does not work if the port is diffferent to the default TCP 1433.

Whats the trick?

Cheers, Angelo

DatabaseConnection.PNG (46.38 KiB) Viewed 4210 times

[Sorin]

Hello,

For the predefined connection - "Microsoft SQL Server / MSDE" the "Port" field is indeed non-editable. You could specify a port in the "Server" field, after the server name, for example : [SERVER_PROP],[PORT_PROP]

Best regards,
Sorin

[a.guelle]

Hi Sorin,

thank you very much.

Angelo

[Sorin]

You are welcome!

Let me know if you have other questions.

Best regards,
Sorin