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 |
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 1The 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. |
|
|
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.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
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 |
|
|
|
|
|