SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D


Error - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D

Author
Message
sql crazy kid
sql crazy kid
Right there with Babe
Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)

Group: General Forum Members
Points: 760 Visits: 243
Hi ,

I have a problem with SQL server Job . Job keep failing while executing package . Job and Package on Same server.
If you run package from MANAGEMENT STUDIO from the same server , its works fine.


"DestinationDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D
Description: "Login failed for user 'DOMAIN\SERVER$'.". End Error Error: 2015-05-26 11:27:37.65 Code: 0xC00291EC
Source: EST_NameOfTASK Execute SQL Task
Description: Failed to acquire connection "DBnameDestination".
Connection may not be configured correctly or you may not have the right permissions on this connection. End Error
DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:27:36 Finished: 11:27:37 Elapsed: 1.328 seconds. The package execution failed. The step failed.
michal.lisinski
michal.lisinski
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4148 Visits: 1185
HI
You have to save the password in configuration file.
Regards
Mike
sql crazy kid
sql crazy kid
Right there with Babe
Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)Right there with Babe (760 reputation)

Group: General Forum Members
Points: 760 Visits: 243
Thanks you ..
I got the issue now . In the configuration file , connection string was defined for Windows authentication . Since I am logged in and running through the management studio its works . But on SQL job its doesn't use windows authentication hence failed . As solution i have configured my connection string with SQL Authentication and worked well.:-P
Crazybabu
Crazybabu
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 5
Hi,

is there any other way to achieve this without configuration
Lowell
Lowell
SSC Guru
SSC Guru (182K reputation)SSC Guru (182K reputation)SSC Guru (182K reputation)SSC Guru (182K reputation)SSC Guru (182K reputation)SSC Guru (182K reputation)SSC Guru (182K reputation)SSC Guru (182K reputation)

Group: General Forum Members
Points: 182319 Visits: 41569
yes. you can create a credential with windows credentials, and then a proxy in SQL agent.

with that in place, you can modify the job step that calls the SSIS package to use that credential instead of the default.


here's a decent article on how to set it up:

https://www.simple-talk.com/sql/database-administration/setting-up-your-sql-server-agent-correctly/

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search