SQLServerCentral / Reporting Services / Reporting Services / Change a Report Owner / Latest Posts

RE: Change a Report Owner

dclemens — Fri, 16 Nov 2012 08:09:12 GMT

I use this; Run it against the reportserver db.[code="sql"]DECLARE @OldUserID uniqueidentifierDECLARE @NewUserID uniqueidentifierSELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = '<NewUser/domain>'SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = '<OldUser/domain>'UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID and laststatus like 'Failure%'[/code]** we also created a ReportSub/domain user account and we use that account in the NewUser spot mentioned above.

RE: Change a Report Owner

mcortez — Thu, 15 Nov 2012 09:14:32 GMT

My Users are having the same problem. We have SSRS installed in SharePoint Integrated mode. All the reports were deployed by one User who left the company. When they disabled said User's account the reports stopped working. They re-enabled it as a temporary solution, but have yet to find a permanent solution. Are there best practices to deploying the reports with a system account so the reports are not owned by a specific User?

RE: Change a Report Owner

Jomar Imbat — Sat, 11 Aug 2007 02:27:00 GMT

I might be able to give you some advice if you can provide a better detail such as the error description. How do you interact with the report is it thru the Report Manager, is there a job that actually execute the report, a snapshot?All reports run in the context of a user, I figured the user account must have been disabled or removed from your active directory. If you still have access to the report than chances are you can update the data source and change the credential being use by the report but firstly verify if the account has access to the database or server to be access by the report.

Change a Report Owner

SW_Lindsay — Fri, 10 Aug 2007 12:56:00 GMT

An employee left and they are the owner of reports. Now the reports won't run. Is there anyway to change the report owner?