Monday, March 19, 2012

Error when creating new connection in DTS Designer

64b SQL2005 EE and all clent tools installed on the same server. Im trying to create a new connection in DTS Designer but after succesful test of the connection it errors out with

The new connection manager couldnt be created. Additional info : Exeption from HRESULT 0xC0010014

Any idea whats the problem here?

This might be caused by a problem described here:

http://support.microsoft.com/kb/913817

|||Im logged in with local admin account. Does that count? Still SSIS is running under Network Servise|||Usually the service does the component enumeration and caches the results, so this is performed without admin rights. You can check if this is an issue by temporary disabling the service, and trying this again (restart BIDS first). If this is caused by permission issue, you'll likely succeed because BIDS will do the component enumeration itself (this harms performance, but avoids Network Service restrictions).

No comments:

Post a Comment