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 |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2013-06-10 : 11:40:17
|
| Hi,I have linked server ,into I have just one table ,how I can add another tables to the linked serverThanks a lot!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-10 : 12:56:47
|
| you dont need to add tables to linked server, if you've linked server setup and if mapped login have sufficient priviledges, you should be able to access all tables in a given schema------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-06-10 : 13:24:03
|
| Maybe I dont understund good,but I have this errrorSELECT SUM([nb_Qte])FROM [LMPIDB02\PROD].[Distribution].[dbo].[FactEcritureVente] sLEFT JOIN [LMPIDB02\PROD].[Distribution].dbo.DimDetailEcritureVente d ON s.[sk_DetailEcritureVente] = d.[sk_DetailEcritureVente] WHERE sk_edition = 110271 --AND d.cd_TypeEcriture = 'C'error:Msg 7314, Level 16, State 1, Line 2The OLE DB provider "SQLNCLI10" for linked server "LMPIDB02\PROD" does not contain the table ""Distribution"."dbo"."FactEcritureVente"". The table either does not exist or the current user does not have permissions on that table. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-10 : 13:37:11
|
| so that means the mapped login was denied access to that object or set of objects explicitly. In that case you need to ask admin to GRANT you select access on the table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-06-10 : 13:55:40
|
| thanks,I'll check |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-06-10 : 14:13:21
|
| thanks,I'll check |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-06-10 : 16:26:49
|
| Hi,how I can resolve this error?OLE DB provider "SQLNCLI10" for linked server "LMPIDB02\PROD" returned message "Login timeout expired".OLE DB provider "SQLNCLI10" for linked server "LMPIDB02\PROD" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-11 : 01:30:23
|
quote:
Originally posted by nord
Hi,how I can resolve this error?OLE DB provider "SQLNCLI10" for linked server "LMPIDB02\PROD" returned message "Login timeout expired".OLE DB provider "SQLNCLI10" for linked server "LMPIDB02\PROD" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. Thanks
Sounds like the instance to which you setup linked server is currently down. Check connecting directly to other instance using SSMS if possible. If not remote desktop to physical server machine running the other instance and check if sql server service is running------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|
|
linked server