Error 15274. SQL Job Linked Server Failure. Access to the remote server is denied as current security context is not trusted.

The job failed with following error.

Message
Executed as user: domain\user. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274). The step failed.

Or you can also get following error when you are using Linked Server in job:

Message
Executed as user: domain\user. The OLE DB provider “SQLNCLI” for linked server “Servername” reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider “SQLNCLI” for linked server “servername”. [SQLSTATE 42000] (Error 7303) OLE DB provider “SQLNCLI” for linked server “servername” returned message “Invalid authorization specification”. [SQLSTATE 01000] (Error 7412) OLE DB provider “SQLNCLI” for linked server “servername” returned message “Invalid connection string attribute”. [SQLSTATE 01000] (Error 7412). The step failed.

Another Nice Feed http://mssqlcorruptiontackle.blogspot.com/2010/12/mssql-server-dbcc-loginfo-status-2-log.html

Resolution:

The resolution of this error is straight forward. This error informs that the account is not getting authenticated at other servers. Make your job run using following consultation.

1. Note down the account under which sql server agent service is running.
2. Create this account as the admin on both the boxes between which the linked server is established.
3. Make this account as the owner of the job.
4. Don’t add this account in the “run as” for any job step.
5. Add this account for linked server access and click on impersonate.

Your job will succeed now. http://mssqlcorruptiontackle.blogspot.com/2010/12/ms-sql-corruption.html

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

Along with technical learning I would like to share some great articles for anyone interested in the betterment of his/her family life

Regards
Online SQL/Powershell Classes @ http://tuitionaffordable.webstarts.com

Advertisements

4 comments

  1. Coloring books are usually utilized by children, though coloring books for adults are
    also available. Formative assessment – Formative assessment is mostly accomplished after a course or project.
    ISRO has over the years built many field installations and works together with all the
    international space research community on many important bilateral and multilateral research agreements.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s