Hi,
we have an internal SQL 2008 Server and a remote Postgre SQL Server and want to import data from Postgre to MSSQL. We made tests with Excel and an OLEDB driver and it was succesful, so we do not have any firewall problems.
Then I tried to create a linked server in MSSQL, entered name and host, changed the remote login to a specific user, but it failed. The error message said the the Postgre SQL server could not be reached at port 5432, the standard port. Thats correct... because I need to use a different port 5504 to connect through the remote Firewall.
How can I change the used port to my special port?
Any help is very much appreciated!
Regards
Oliver