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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server Linked Servers

Author  Topic 

mikyerii
Starting Member

3 Posts

Posted - 2013-01-22 : 01:38:30
I am trying to implement Linked Servers. but I am having problems establishing connection to my two servers:



I have already created the linked server SRV-AXDEV under SRV-APP1 with the following configurations:





This is the list of my databases in SRV-AXDEV




But when I try to run this query:

Select * from [SRV-AXDEV].[GFII_AX2009_DB_LIVE].[dbo].[InventTable]


I keep on getting this error:


Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "SRV-AXDEV" does not contain the table ""GFII_AX2009_DB_LIVE"."dbo"."InventTable"". The table either does not exist or the current user does not have permissions on that table.


I hope you could help me with this problem.

Thank you very much!

prett
Posting Yak Master

212 Posts

Posted - 2013-01-22 : 01:42:38
Try adding ", @datasrc=@ServerName" to your sp_addlinkedserver statement.
Go to Top of Page

mikyerii
Starting Member

3 Posts

Posted - 2013-01-22 : 01:58:24
But I have read in msdn that if the @srvproduct is SQL Server then provider_name, data_source, location, provider_string, and catalog do not have to be specified.

I have tried it though but still throws out the same error..
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-22 : 10:59:33
have you done all these steps?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164892

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2013-01-22 : 22:42:27
Please check this post: http://www.sqlservercentral.com/Forums/Topic473766-146-1.aspx
Go to Top of Page
   

- Advertisement -