Last post Mar 13, 2017 05:00 AM by Chris Zhao
Mar 11, 2017 06:56 PM|gv.praveen|LINK
I need to insert data from table in Database in One Linked Server to data to table in Database to another Linked Server. I tried to run query in SSMS by connecting to Sevr1 ,but i got error "The OLE DB provider "SQLNCLI11" for linked server "Sevr2" does
not contain the table ""DB2"."dbo"."tbl_2"". The table either does not exist or the current user does not have permissions on that table."
I have the both the tbl2 in DB2, so it should be related to permission.Can please help me?
Insert Into [Sevr1].[DB1].[dbo].tbl_1
Select * From [Sevr2].[DB2].[dbo].tbl_2
Thanks in advance.
Mar 13, 2017 05:00 AM|Chris Zhao|LINK
When you create a linked server, you need to provide the credentials and mapping to one of your local server accounts.
Please ensure that the credentials which you used to create the linked server has enough permissions and you have used the mapping account to login your local server.