Running on non-default SQL port

Unknown

Running on non-default SQL port

Unknown

Hi,

I am trying to reconfigure a SQL Server database for the existing Dev instance of Decisions and need to run SQL on an alternative non-standard port. How do I reconfigure the port in the connection string? In .Net we typically add “Port=1500;” but I get “Keyword not supported: port” exception in the log when Decisions connection string is modified.

Unknown

Hello,

Can you try updating your connection string syntax to the following: [b]Server=servername,portnumber;[/b]

For additional information, we used the following resources to help answer your query.

https://www.connectionstrings.com/sql-server/
https://www.connectionstrings.com/questions/54081/non-standard-port-with-sql-server-odbc/