Sue_W
asked on
Received this error while trying to set up Linked Server in Sql Server 2000 - OLE/DB provider returned message: CWBCO1011 - Remote port could not be resolved
I have set up a linked servers on my development and test 2000 sql servers successfully but I cannot seem to set uo and connect successfully on my production 2000 sql server.
On production when I click the Linked Server - table - I get this error:
Error 7339: OLE DB provider 'IBMDA400' reported an error. OLE error trace [OLE/DB Provider: 'IBMDA400' IDBIntialize: Intialize returned 0X800004005:]'
When I try to use the linked server in an OpenQuery in sql query analyzer I get the following error:
'Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'IBMDA400' reported an error.
[OLE/DB provider returned message: CWBCO1011 - Remote port could not be resolved ]
OLE DB error trace [OLE/DB Provider 'IBMDA400' IDBInitialize::Initialize returned 0x80004005: ].'
I have another production sql server running 2005 where I successfully connect using a linked server.
I use a windows account on both production sql servers and I use Local system accounts on the development and test server. I had read somewhere that the windows account makes a difference but I don't see how since I have two servers using the same windows account to run the sql server and sql server agent services and one works but the other does not.
The Linked Servers are connectin to an iSeries. I verified that the two production machines are using the same verison of the iSeries Access for Windows.
Any help troubleshooting the issue will be appreciated.
On production when I click the Linked Server - table - I get this error:
Error 7339: OLE DB provider 'IBMDA400' reported an error. OLE error trace [OLE/DB Provider: 'IBMDA400' IDBIntialize: Intialize returned 0X800004005:]'
When I try to use the linked server in an OpenQuery in sql query analyzer I get the following error:
'Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'IBMDA400' reported an error.
[OLE/DB provider returned message: CWBCO1011 - Remote port could not be resolved ]
OLE DB error trace [OLE/DB Provider 'IBMDA400' IDBInitialize::Initialize returned 0x80004005: ].'
I have another production sql server running 2005 where I successfully connect using a linked server.
I use a windows account on both production sql servers and I use Local system accounts on the development and test server. I had read somewhere that the windows account makes a difference but I don't see how since I have two servers using the same windows account to run the sql server and sql server agent services and one works but the other does not.
The Linked Servers are connectin to an iSeries. I verified that the two production machines are using the same verison of the iSeries Access for Windows.
Any help troubleshooting the issue will be appreciated.
On the server that fails, can you actually connect using the iSeries client tools?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can connect to the iSeries using iSeries for Windows Access client on the server that fails. I've had the network admin to check for port blocking.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.