User domain\A were granted rights to create subsription on server1 User domain\A created 30 subsriptions ,all of them were working fine till user domain\A left company and his account was locked all subsription created by domain\A stop working question Can I change owner of subsription from domain\A to service account with 'sa' privelage without droping and recreating subsription Can I modify owner directly in Reporting databaase objects ? Thank you

found it http://blogs.msdn.com/b/miah/archive/2008/07/10/tip-change-the-owner-of-report-server-subscription.aspx