November 18, 2008 at 10:11 pm
Hi,
We have two servers, one in dev and one in production.
Both are identical in terms of SQL Server setup.
SELECT @@Version on both returns exactly the same result as below:
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
On both of these servers we have created a linked server to IBM DB2 database on AS400. Both of these linked servers are exactly the same.
Now the problem is that a OPENQUERY query on dev runs perfectly fine while the same query in production fails with this error:
Msg 7372, Level 16, State 4, Line 1
Cannot get properties from OLE DB provider "IBMDASQL" for linked server "SAP_HOL_D01".
Note: Only difference between dev and production is that production server is a clustered server.
Pls help to resolve this problem.
Regards
RSingh
November 20, 2008 at 12:06 pm
Sounds like a security issue.. run a trace on the linked server when you run your query from the other server... if it's part of a cluster.. are you sure the sql resource group is running on the linked server? Are you connecting to the cluster sql name or the server directly? Can you register the production server ok in Studio Manager? Are you using names pipes or tcp/ip to connect?
As a basic test, can u set up a odbc connection to the production server from ur dev box?
I may be way off the mark but these are things that spring to mind..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply