Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday 18 February 2019

The OLE DB provider SQLNCLI for linked server does not contain the table dbname.dbo.tablename. The table either does not exist or the current user does not have permissions on that table. [SQLSTATE 42000] (Error 7314) or Executed as user: NT SERVICE\SQLSERVERAGENT. Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452).

Executed as user: domain\administrator. The OLE DB provider SQLNCLI for linked server  does not contain the table dbname.dbo.tablename. The table either does not exist or the current user does not have permissions on that table. [SQLSTATE 42000] (Error 7314). The step failed.

(OR)

Message
Executed as user: NT SERVICE\SQLSERVERAGENT. Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452).  The step failed.

Solution:

1) First check job is running account have exists on both source and destination
2) job running account have access to the linked server whether test is succeeded or not
3) kindly go to Linked server properties then security tab then be made using login context as sysadmin login with password the SQL job will run sysadmin login otherwise linked server using job will run SQL Agent service(Windows Authentication account)

Right click Linked server and then choose properties

choose security tab

kindly give job running account(SQL Authentication) with password in (be made using login context) radio button

then save the job

No comments:

Post a Comment