Do you have any access request process that is documented in the company?

This may garner some clues. Especially if MyGroup is new on the Domain.

Also consider notifying the users before...

Mario is probably right about the double hop.

Can you setup Kerberos on the machines?

http://support.microsoft.com/?kbid=319723

We have IIS and RS on one machine, SQL and SSAS on another, and it works fine...

And I also think you may want to review this.

You mentioned installing SP2 then 'adding' RS.

After you've SP's SQL Server, you should use a command prompt to add or remove...

How to switch between x64 and 32 bit frameworks for IIS

http://support.microsoft.com/kb/894435

Although you should only need to do this if hosting something on the IIS server that is 32 bit only....

We use our SAN for spreading out some of the files. So some limitations may also depend on other network infrastructure you can leverage.

Lots of different things come into play....

We run Reporting Services on an x64 bit VMware. Seems to run OK doing batch scheduled reports.

I don't know that I'd run our SSAS instance on one though. I'd...

Ben -

Save this script as an .asp file (after changing the server - I'd use the Fully Qualified Name of your SQL Server) and host it on the same web...

Ben -

Take a look at the security logs on all the servers involved. You should see a failure, and it might not be on the server you expect. It could...

I tend to agree with Damon - bringing back 600,000 rows, especially when someone is interested in no more than 20, is both difficult and not very scalable.

More details...

Please do a search for kerberos and sql server on microsoft's site and review some of the setup.

This might be a good start.

http://support.microsoft.com/?kbid=319723

There are a number of steps, and it...

Kerberos can be setup on the network, but endpoints for the services and machines are a separate setup.

Did you verify that the machines involved are allowed to delegate?

And that all...

If RS web site and data reside on different servers, you need to set up Kerberos. This will allow the credentials to be passed from machine to machine.

A domain admin...

Michael is right - only Enterprise Edition and Developer Editions support data driven subscriptions.

Greg E

Was this a clean install? And was RS configured before any service packs applied?

And is the account admin on the box?

If the RS db is on another server, you have...

Steve is right - you should do all changes to SQL 2005 through the cdonfiguration managers ( including the separate Reporting Services RSConfig utility ).

Running as a local admin account...