April 11, 2012 at 7:12 am
could you help me please.
Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI" for linked server "LK_SGSOL_SGXP" reported an error. Authentication failed.
[SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "LK_SGSOL_SGXP".
[SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI" for linked server "LK_SGSOL_SGXP" returned message "Invalid authorization specification".
[SQLSTATE 01000] (Error 7412). The step failed.
Boucicaut
April 11, 2012 at 7:44 am
That error pretty much says it all. The link server is unable to authenticate. There are a lot of things that could be causing this. If this worked in the past then it might be that something on the network changed (firewall, etc). It could be the password changed for the link server authentication...
Try running a query in SSMS from the box where the job is running and pull some data through the link server. My guess is that it will fail with much the same message. Authentication issues are really hard to resolve remotely.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply