Hello, I am getting an error when trying to run a report: An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'MITSAssets'. (rsErrorImpersonatingUser) Log on failed. Ensure the user name and password are correct. (rsLogonFailed) Logon failure: unknown user name or bad password I am able to got to http://vossql1/Reports/Pages/Folder.aspx but when clicking on any report http://vossql1/Reports/Pages/Report.aspx?ItemPath=%2fAssets+Detailed+per+Data+Center I am getting the error above. Apparently the dbo of the database is gone... how could I retrieve the access to it... I tried an sp_changedbowner and I am getting an error: Msg 15110, Level 16, State 1, Line 1 The proposed new database owner is already a user or aliased in the database. I restarted the SQL Server and the SQL Reporting services... still no luck I deleted my account from the Database and readded it with the sp_changedbowner, restarted services ==> no luck What should I run or pass as command to get access? Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support

How did you come to the conclusion the ownership is the problem? Are you tryingt o set ownership to sa? if not, do so. Did you validate if you can log into the database by other means such as SSMS or running the report locally in BIDS? Ted Krueger Blog on lessthandot.com @onpnt on twitter

we don't use sa in our environment. Yes I could connect to the database with no problem. I find the issue it was under the MITSAssets there is a connection set to the user account (which has chnaged his password!!!) which created the database, I will change it to a service account with no password change. MITS > Properties > Credentials stored securely in the report server Thanks, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support