Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simpleton
Starting Member
25 Posts |
 Posted - 2008-02-13 : 10:13:50
|
| We recently had an employee leave, and now the SQL Report subscriptions that he owned are not working. When I go to re-save the subscriptions, I see an error like this:"The user or group name 'MyDomain\jimmy' is not recognized. (rsUnknownUserName)"Any way I can "take" ownership of these orphaned subscriptions?I don't want to recreate them all.. (Like 50 of them) |
|
|
simpleton
Starting Member
25 Posts |
Posted - 2008-02-13 : 12:54:42
|
| I'm all fixed now.I just re-assigned the Subscriptions by swapping the UserID's in the "Subscriptions" database.In the ReportServer Database, there's a table called Users. Select UserName, UserID from UsersFind your user that left.Select * from Subscriptions where OwnerID = '<UserID>' |
 |
|
|
|
|
|
User deleted and now subscriptions are not working