Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change a Report Owner Expand / Collapse
Author
Message
Posted Friday, August 10, 2007 12:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 19, 2013 6:49 AM
Points: 120, Visits: 291

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

 

Post #389807
Posted Saturday, August 11, 2007 2:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 11, 2007 1:48 AM
Points: 4, Visits: 1
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.
Post #389950
Posted Thursday, November 15, 2012 9:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 16, 2012 11:51 AM
Points: 2, Visits: 17
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?
Post #1385234
Posted Friday, November 16, 2012 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 6, Visits: 354
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.
Post #1385720
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse