威力手記本

當 Reporting Services 的訂閱擁有者離職或被 AD 刪除後，相關的訂閱會被失效而無法發送，除了用管理者身分去一個一個重新定義訂閱以外，簡單的方法是使用 SQL 語法，將舊的人員改成新的人員。

SQL 如下:

DECLARE @OldUserID uniqueidentifier
DECLARE @NewUserID uniqueidentifier
SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAINA\OldUser'
SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAINA\NewUser'
UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID

SQL 參考來源 : Tip: Change the Owner of SQL Reporting Services Subscription