cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQLServer connection port not 1433

we’ve just found out that SQL Server we need to use for FlexNet Manager will use a different port from the default one, the 1444 port.

How should I use this port when I run the command Config.ps1 \ FNMS Windows Authentication.xml during the final steps of the configuration?

Thanks for the answer

(1) Solution

When running the PowerShell script, on the pop up form where you enter the name of the SQL Server, you will need to enter the server name and the port number enclosed in quotes, such as the following.  You must include the quotes.

'servername,port'

 

If a dedicated SQL instance is also being used, then the syntax would be

'servername\instance,port'

View solution in original post

(3) Replies

When running the PowerShell script, on the pop up form where you enter the name of the SQL Server, you will need to enter the server name and the port number enclosed in quotes, such as the following.  You must include the quotes.

'servername,port'

 

If a dedicated SQL instance is also being used, then the syntax would be

'servername\instance,port'

Quotes were needed in FNMS versions prior to 2019 R2. In migrations to 2019 R2 this and last week I found quotes not needed anymore.