Friday, February 17, 2012

Created a subscription but doesn't run

I recently installed Reporting Services on my compute
I created Reporting Services subscriptions, but they doesn't run a
al
My reports are ok, I can display them without any problem on m
browser, and export them on pdf format. But subscription seems to b
totaly inactive
- reporting services SP1 and SP2 installe
- I tried File Share (with correct credentials) and e-mai
subscriptio
- selected schedule is "hourly", every 5 minutes (for testing
- on "Subscription Details" page, status is "New subscription" an
"Last run" column is empt
Thank you for any helHi
Is SQL Server Agent Running on your SQL Server?
This is requited at this places the jobs into the RS queue when a report is
scheduled.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"MacFly" <macfly92@.tiscali-dot-fr.no-spam.invalid> wrote in message
news:Le6dnVH9WcniQXzfRVn_vQ@.giganews.com...
>I recently installed Reporting Services on my computer
> I created Reporting Services subscriptions, but they doesn't run at
> all
> My reports are ok, I can display them without any problem on my
> browser, and export them on pdf format. But subscription seems to be
> totaly inactive.
> - reporting services SP1 and SP2 installed
> - I tried File Share (with correct credentials) and e-mail
> subscription
> - selected schedule is "hourly", every 5 minutes (for testing)
> - on "Subscription Details" page, status is "New subscription" and
> "Last run" column is empty
> Thank you for any help
>|||Yes, SQL Server Agent is Running on my SQL Server
After multiple attempts, I didn't succeed
My configuration was
SQL Server was on a server running under Windows 2003 Server
Report Server, Report Manager, Report Designer were on my own compute
(for testing), under Win X
I uninstalled Report Server + Report Manager from my XP computer, an
installed them on server running with windows 2003 server (beside SQ
Server) => it works fine
So I still have no answer, I only bypassed the problem..
If anyone has an idea, it still would be welcom|||when you change the login name the service runs under the encrypted data no
longer works. This includes the scheduling since it uses encrypted logins to
login and run the report. you will have to delete encrypted data and restart
the service.
MacFly wrote:
>Yes, SQL Server Agent is Running on my SQL Server
>After multiple attempts, I didn't succeed
>My configuration was
>SQL Server was on a server running under Windows 2003 Server
>Report Server, Report Manager, Report Designer were on my own compute
>(for testing), under Win X
>I uninstalled Report Server + Report Manager from my XP computer, an
>installed them on server running with windows 2003 server (beside SQ
>Server) => it works fine
>So I still have no answer, I only bypassed the problem..
>If anyone has an idea, it still would be welcom
--
Gene Hunter
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1

No comments:

Post a Comment