The job failed with following error.
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:
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.
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.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- 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
- Quality time with kids: Let’s have a Quality Audit
- Parental guidance how to control your kid in elementary school not obeying teacher
- Parental guidance for child development post terrible twos
- Parental guidance on how to handle child when they show their first infatuation at elementary school
- How to Handle fit of temper by fixing baby screen time
- Are Words Important
Online SQL/Powershell Classes @ http://tuitionaffordable.webstarts.com