Problem with Warehouse on MOMSQL01

Hi All,

 

I have a strange and anoying problem with my Hosted Exchange Instalation. My Warehouse dont want to gather data from PlanManager databse. FABRIKAM\MOMService is set to db_reader role, but my SSIS. Here is my SQL Log for this specific error

Message
Executed as user: Fabricam\MOMService. …0.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.   
Started:  3:26:09 PM  Error: 2008-01-11 15:26:10.80    
Code: 0xC0202009    
Source: pwdb40SSIS Connection manager "ProvisionSourceDbDataConnection"    
Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred.
Error code: 0x80004005.  An OLE DB record is available. 
Source: "Microsoft SQL Native Client" 
Hresult: 0x80004005 
Description: "Login failed for user 'Fabricam\MOMService'.".  An OLE DB record is available. 
Source: "Microsoft SQL Native Client" 
Hresult: 0x80004005 
Description: "Cannot open database "planmanager" requested by the login. The login failed.". 
End Error 
Error: 2008-01-11 15:26:10.80    
Code: 0xC020801C    
Source: AssetTypesUpdates OLE DB Source [1]    
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connect…  The package execution fa…  The step failed.

Any Ideas ?

Read More

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s