Service PACK and Windows update

More
2 years 4 months ago #13847 by David McLaughlin
I updated our sql server 2005 to sp4 and did an inline upgrade of windows (from 2003 to 2008). Now my linked server to postgres has stopped working - it just hangs there on any/all queries and never returns. A test connection from SQL Server comes back as a time out failure. PGNP Profiler just stays empty and reports nothing. We are on version 1.3.2262 - what can we try to fix the connection again. (and would you know if it was the service pack or OS upgrade that was the problem.

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #13848 by Moderator
It could be a firewall issue, or something else. Try to test basic connectivity using UDL file. Check Windows EventsLog for errors and warnings.

It is recommended to upgrade OLEDB provider to the latest build as well.

Please Log in or Create an account to join the conversation.

Time to create page: 0.116 seconds
Powered by Kunena Forum