August 10, 2007 at 12:56 pm
An employee left and they are the owner of reports. Now the reports won't run. Is there anyway to change the report owner?
August 11, 2007 at 2:27 am
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.
November 15, 2012 at 9:14 am
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?
November 16, 2012 at 8:09 am
I use this; Run it against the reportserver db.
DECLARE @OldUserID uniqueidentifier
DECLARE @NewUserID uniqueidentifier
SELECT @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%'
** we also created a ReportSub/domain user account and we use that account in the NewUser spot mentioned above.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply