Page 1 of 1

Connecting to SQL Server with non default port number

Posted: Mon 25 May 2020 22:08
by parisa
Hi there,

We use SDAC 9.1.3 in D2007 and got a question about port number settings in MSConnection.

When SQL server is listening on a non default (1433) port number, by changing port number property of MSConnection to the proper port number, MS Connection can connect to sql server using Server Authentication. However if authentication is set to Windows authentication, this does not happen.

Is it by design or we are missing something?

Thanks for your help,
Parisa

Re: Connecting to SQL Server with non default port number

Posted: Wed 03 Jun 2020 12:48
by Stellar
Thank you for the information. In order for us to give a more detailed answer, provide the exact error message.