Connecting to SQL Server with non default port number
Posted: Mon 25 May 2020 22:08
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
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