[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 827
  • Last Modified:

connection string problem

Error: 2011-09-28 10:07:47.08

Code: 0xC0202009

Source: RMT_Upload_EFW_AOPS Connection manager "DestinationConnectionOLEDB"

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

End Error

Error: 2011-09-28 10:07:47.10

Code: 0xC00291EC

Source: Update Job Status - Started Execute SQL Task

Description: Failed to acquire connection "DestinationConnectionOLEDB". Connection may not be configured correctly or you may not have the right permissions on this connection.

End Error
0
parpaa
Asked:
parpaa
1 Solution
 
MrNeticCommented:
Hi,
That is very generic... can you check that the destination was online, or some account was revoked access ?
0
 
Lee SavidgeCommented:
Has someone changed the sa password?
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
parpaa,

The error is in plain English, it just can't acquire the connection, check your connection managers and credentials!

Can you explain what you were doing instead of posting just an error? are you testing in BIDS? or that was a running package and now stopped working?

Please explain..
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure the SQL Server is accessible using SSMS.

If not then add exception in firewall, Enable remote connection, enable pipeline and protocols.

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now