June 11, 2012 at 1:47 pm
Message
Executed as user: . Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:36:22 PM Error: 2012-06-11 14:36:23.22 Code: 0xC0202009 Source: FixReportingIssues Connection manager "TransactionalDBConnection" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005
SSIS sql job is failed, below is error and job status is 'between entries'. Please advice
June 11, 2012 at 2:23 pm
The part you care about is what I trimmed out of the original error.
laddu4700 (6/11/2012)
Description: "Login failed for user 'Domain\sqlservice'.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot open database "AGRESSO_QA" requested by the login. The login failed.". End Error Error: 2012-06-11 14:36:23.22
Security issues. To confirm you'll need to RDC to that machine as that login and see if you can access the database in question with that login. My guess is your SQLAgent user doesn't have any rights to it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 11:19 pm
Craig is right. Either give LANDAUER\sqlservice read/write permission on the AGRESSO_QA database, or execute the jobstep with a proxy.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 12, 2012 at 12:37 pm
Resolved.
Permissiion issue only.
Thanks to all
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply