Connecting to SQL Server with non default port number

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
parisa
Posts: 3
Joined: Fri 06 Jun 2014 19:38

Connecting to SQL Server with non default port number

Post by parisa » 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

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Connecting to SQL Server with non default port number

Post by Stellar » Wed 03 Jun 2020 12:48

Thank you for the information. In order for us to give a more detailed answer, provide the exact error message.

Post Reply