Also - I seem to recall on our SMTP server, we had to allow the server IP access. Most SMTP servers should have some level of security so they are...

Might be a dumb question - but did you use rsconfig to configure email for Reporting Services?

I use an SMTP server for this, not Database mail.

Check your settings in rsconfig

Greg...

OK.

There are a number of pieces to having Kerberos set up properly. And it also requires a Domain Admin to setup the endpoints.

Have some other bookmarks and tips that may...

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...

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...

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,...

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...