Is there a way with SSRS 2005 and SSAS 2005 to create report subscriptions?
The only permissions objects for the cubes / cube roles seems to be
Integrated?

Stored Windows credentials, speciying a login with access to SSAS,
should work. I recall that there were some service account issues with
this setting on a Windows 2000 server, but Windows 2003 should be fine:

http://msdn2.microsoft.com/en-us/library/ms160330.aspx
Stored Credentials

You can store the credentials used to access an external data source.
Credentials are stored in reversible encryption in the report server
database. You can specify one set of stored credentials for each data
source used in a report. The credentials you provide retrieve the same
data for every user who runs the report.

Stored credentials are recommended as part of a strategy for accessing
remote database servers. Stored credentials are required if you want to
support subscriptions, or schedule report history generation or report
snapshot refreshes. When a report runs as a background process, the
report server is the agent that executes the report. Because there is no
user context in place, the report server must get credential information
from the report server database in order to connect to a data source.

The user name and password that you specify can be Windows credentials
or a database login. If you specify Windows credentials, the report
server passes the credentials to Windows for subsequent authentication.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

hi,

You can create teh report based on a cube and then set the subscriptions for
the report. The report administration will guide you through the set of tasks
that you will define to create your subscription.

SSRS has the ability to create report subscriptions, where users can request
reports to be emailed to them automatically at various intervals. Teh report
server administrator can also define subscriptions by using various options
such as database driven subscription of reports with variable schedules.

Kind regards,
--------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
------------------------------------------------

"Scott" wrote:

This seemed to work, but I did have to modify the connection information on
the report server only...there does not seem to be a way to put anything but
Integrated Authenticaiton in the Data Source for the report in Visual Studio.

"Deepak Puri" wrote: