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
Connecting to SQL Server with non default port number
Re: Connecting to SQL Server with non default port number
Thank you for the information. In order for us to give a more detailed answer, provide the exact error message.