Error in connection

Hi All,

I am facing a peculiar problem since I changed my database settings to Mixed mode from Windows authentication only.

My package in SSIS is not running at all. Error is listed below:

[OLE_SRC_Account [46]] Error: The AcquireConnection method call to the connection manager "OLE_SRC_CRSOLTP" failed with error code 0xC0202009.

I tried removing and adding the connections using both windows and SQL authentication,but without success.Under SQL authentication password is not saved,nor the database name and server.

Please tell me what can be done. Work at a critical stage.

Thanks in advance

Regards,

Aman

[675 byte] By [amananand] at [2007-12-23]