all groups > sql server reporting services > july 2005 >
You're in the

sql server reporting services

group:

Created a subscription but doesn't run


Created a subscription but doesn't run macfly92 NO[at]SPAM tiscali-dot-fr.no-spam.invalid
7/23/2005 12:58:23 AM
sql server reporting services: 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 hel
Re: Created a subscription but doesn't run Mike Epprecht (SQL MVP)
7/24/2005 12:31:27 AM
Hi

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/

[quoted text, click to view]

re:Created a subscription but doesn't run macfly92 NO[at]SPAM tiscali-dot-fr.no-spam.invalid
7/27/2005 1:09:55 AM
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
re:Created a subscription but doesn't run gene hunter via SQLMonster.com
8/5/2005 12:00:00 AM
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.



[quoted text, click to view]

--
Gene Hunter


Message posted via SQLMonster.com
AddThis Social Bookmark Button