SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server Linked Servers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikyerii
Starting Member

3 Posts

Posted - 01/22/2013 :  01:38:30  Show Profile  Reply with Quote
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

USA
203 Posts

Posted - 01/22/2013 :  01:42:38  Show Profile  Visit prett's Homepage  Reply with Quote
Try adding ", @datasrc=@ServerName" to your sp_addlinkedserver statement.
Go to Top of Page

mikyerii
Starting Member

3 Posts

Posted - 01/22/2013 :  01:58:24  Show Profile  Reply with Quote
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..

Edited by - mikyerii on 01/22/2013 02:01:19
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 01/22/2013 :  10:59:33  Show Profile  Reply with Quote
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

USA
203 Posts

Posted - 01/22/2013 :  22:42:27  Show Profile  Visit prett's Homepage  Reply with Quote
Please check this post: http://www.sqlservercentral.com/Forums/Topic473766-146-1.aspx
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000