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