August 31, 2009 at 8:48 am
I have a reporting services setup that I inherited. SQL 2005 SP3. I am a sysadmin on SQL Server, administrator on the server, and I also have an account with domain admin rights that I have tried. I am unable to view any subscriptions for reports. I see SQL Agent jobs for reporting services. I know that some files (XLS) are being placed on a network share based on a report on the report server. However if I go to that report I can not see any subscriptions.
Does anyone know how I can view the subscriptions? I need to make a change but I have no information as the previous admin is no longer available. So I assume it was created under his account, but thats just a guess. I want to alter the schedule/delivery options if I can get to see the subscription.
Thankss.
September 1, 2009 at 12:32 am
Use subscription table in Reportserver database
select * from subscriptions
Hope this will help you
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply