Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2008-09-25 : 20:28:37
|
| Hello! I was trying to test linked server on configured from two different SQL Server 2005 64-bit servers to SQL Server 2000 SP3. The initial error on both source servers was: 'Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "<LinkedServerName>"'. This has been addressed by applying MS patch: http://support.microsoft.com/kb/906954 One of the SQL Server 2005 64-bit servers is working fine now. This is a non-clustered server. But I am getting different error on second (active/passive cluster) SQL Server 2005 64-bit:OLE DB provider "SQLNCLI" for linked server "172.16.5.232" returned message "Unspecified error".OLE DB provider "SQLNCLI" for linked server "172.16.5.232" returned message "Communication link failure".OLE DB provider "SQLNCLI" for linked server "172.16.5.232" returned message "Communication link failure".Msg 121, Level 16, State 1, Line 0TCP Provider: The semaphore timeout period has expired. Both source servers are in the same domain/network and Netwrok guys are swearing that firewall is fully open for this traffic. I was running netwrok sniffer, WireShark, and didn't find any lost packages or errors. I was running SQL Profiler on SQL 2000 server and gather several meta data call on SQL 2000 before it errored out on SQL Server 2005 64-bit side. I also saw successful TCP connection established from source server using netstat. I am not sure if this is clustered related or something else. Any help is greately appreciated, Igor |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-25 : 21:00:21
|
| So inscat.sql has been installed in SQL 2000 server. Try with Openquery.It should be working. What SP level and patches you have on SQL 2005 Clustered. |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2008-09-26 : 01:33:19
|
You may be missing SPN entries for the service account.If The linked server is using NT passthrough authentication then the server needs to be able to delegate permissions for both nodes of the cluster.SEE active directory Service principal name. You can do anything at www.zombo.com |
|
|
|
jelong
Starting Member
1 Post |
Posted - 2009-02-09 : 16:36:15
|
| Basically you can add any database linked server which is supporting ODBC.Try this (actually it's about SQL server 6.5 linked server on SQL 2005)http://knol.google.com/k/jeyong-park/add-sql-server-65-linked-server-in-sql/3vywlm4f31xae/6#view |
|
|
|
|
|
|
Problem with linked server in SQL 2005 64-bit