Linked Server Sqlstate 01000 Error 7412
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server [sqlstate 42000] (error 7303) 2008 » SQL Server 2008 - General » Agent Job Authentication error accessing... sqlstate 01000 (error 7412) ole db provider Agent Job Authentication error accessing linked server Rate Topic Display Mode Topic Options Author Message CarunclesCaruncles Posted Thursday,
Ole Db Provider "sqlncli10" For Linked Server Returned Message Timeout
February 13, 2014 9:40 AM SSC Journeyman Group: General Forum Members Last Login: Friday, February 26, 2016 7:31 AM Points: 90, Visits: 231 I have a SQL agent job which has
[sqlstate 42000] (error 7399)
been running daily for a year. It fires a stored proc which populates a table then runs this statement:Exec Xp_Cmdshell 'bcp Sfidata.dbo.tblOrderDetail IN "C:\OWDCGiftOrderTransfer\tblorderdetailOWDC.txt" -n -S OWDC -U sa -P password'OWDC is a linked server at another location.I made some changes to the proc, but did not touch the line above. Now I'm getting this error when the job runs from sql severity 16 sql message id 7412 the Agent:Date 2/13/2014 9:45:38 AMLog Job History (Export GiftOrders and GiftCerts to OWDC)Step ID 1Server VSQL2Job Name Export GiftOrders and GiftCerts to OWDCStep Name Gather Recent Gift Orders and Send DetailDuration 00:00:00Sql Severity 16Sql Message ID 7412Operator Emailed Operator Net sent Operator Paged Retries Attempted 1MessageExecuted as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI10" for linked server "owdc" reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "owdc". [SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI10" for linked server "owdc" returned message "Invalid authorization specification". [SQLSTATE 01000] (Error 7412). NOTE: The step was retried the requested number of times (1) without succeeding. The step failed.However, I can run the proc from SSMS and it runs fine and gives no errors. Anyone have any ideas what could have changed and caused this error?Thanx! Wallace HoustonSunnyland Farms, Inc."We must endeavor to persevere." Post #1541303 RatanDeep Saha RatanDeep Saha Posted Friday, February 14, 2014 8:33 AM SSChasing Mays Group: General Forum Members Last Login: Wednesday, October 12, 2016 7:07 AM Points:
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/linked server query failure when run via SQL Server Agent job linked server query failure when run via SQL Server Agent job [Answered]RSS 1 reply Last post Jul 16, 2015 05:35 AM by Nan Yu ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply gunderj Member 90 Points 239 Posts linked server query failure when run via SQL http://www.sqlservercentral.com/Forums/Topic1541303-391-1.aspx Server Agent job Jul 15, 2015 11:39 AM|gunderj|LINK The below query using a linked server works fine when run directly in SSMS "New Query" tab, SELECT * FROM [myServer.NNNC.K1.ORG].[tmsng].[dbo].[audLog] where id = 20919152 GO When I put the same query into a job and run the job (right click, start job from SSMS), I get this error... Executed as user: NT https://forums.asp.net/t/2059667.aspx?linked+server+query+failure+when+run+via+SQL+Server+Agent+job AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI10" for linked server "myServer.NNNC.K1.ORG" reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "myServer.NNNC.K1.ORG". [SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI10" for linked server "myServer.NNNC.K1.ORG" returned message "Invalid authorization specification". [SQLSTATE 01000] (Error 7412). The step failed. The linked server is setup to use Windows authentication Can someone please help? I have spent a day searching for solution but most posts are foe cluster setup which we do not use. Thanks Reply Nan Yu Star 14671 Points 2330 Posts Microsoft Re: linked server query failure when run via SQL Server Agent job Jul 16, 2015 05:35 AM|Nan Yu|LINK Hi gunderj , That seems because sql agent account needs permission on linked server .Right-click the linked server ,click properties and go to the security tab to find what security context are you using in linked server and make sure sql agent account is granted permission on the linked server . Please refer to links for more details: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151487. http://www.sqlservercentral.com/Forums/Topic1541303-391-1.aspx. http://www.sqlservercentral.com/Forums/Topic341351-9-1.aspx. Be
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads https://social.msdn.microsoft.com/Forums/sqlserver/en-US/37eb2350-c0f9-46a2-ac3a-19479de7e722/linked-server-error?forum=sqlintegrationservices Remove From My Forums Answered by: Linked Server Error SQL Server > SQL Server Integration Services Question 0 Sign in to vote Hello guys, I get one issue when I tried to run a job. It gives me below error. Please help me out linked server from this. Executed as user: CONTECH\sqlserver. TCP Provider: The semaphore timeout period has expired. [SQLSTATE 07008] (Error 121) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) Session Provider: Physical connection is not usable [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) OLE DB [sqlstate 42000] (error provider "SQLNCLI" for linked server "SQL2" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "SQL2" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed. Thank s in advance. Maulik Tuesday, January 17, 2012 5:46 AM Reply | Quote Answers 0 Sign in to vote Please refer to the below link for the solution http://blogs.msdn.com/b/jneave/archive/2011/04/15/tcp-provider-error-semaphore-timeout-from-an-ssis-package.aspx Proposed as answer by Onur Omer Ozturk Tuesday, January 17, 2012 12:13 PM Marked as answer by Eileen Zhao Monday, January 23, 2012 2:23 AM Tuesday, January 17, 2012 6