Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Change a Report Owner


Change a Report Owner

Author
Message
SW_Lindsay
SW_Lindsay
SSC-Enthusiastic
SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)

Group: General Forum Members
Points: 121 Visits: 309

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


Jomar Imbat
Jomar Imbat
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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.
mcortez
mcortez
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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?
dclemens
dclemens
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 707
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search