does the agent have the correct login credentials to access the source database

SQL Server Reporting Services and Sharepoint Excel services are pretty good ways of delivering information to users.

I try to keep to that configuration, it depends on the amount of money allowed for disks and the projected data size (always wrong)

It took a lot of time on technet and google to track this down, it still happened after moving all the Dbs back to their original homes. there is a...

I have a similar issue, I haven't moved the resource databse but I am still getting the same problem. sp2 installs for everything but the database services. Using the developer...

From the question I assume that its not a cascading parameter so in your parameter page make the available values from the query and set the default value to...

Does IIS allow anonymous access to the site or does it require authentication? If you switch to anonymous, everybody should be able to get to the report but at the...

couple of things spring to mind

1 make sure that his internet browser recognises the reportserver site as a trusted site

2 windows integrated security on the datasource connection

3 that he is...

The space after the S is a typo putting it into the forum post.

The structure of query 1 works on a SQL 2005 update statement with the parenthesis placed...

query 1 's error said incorrect syntax near S - it refused to use an alias

your version of query 1 also generated errors with the use of the alias.

My...

OK it went like this

last week the chief of infrastructure asked all members of my team (sql development and DBA's) to stop and disable the ComputerBrowser service on their pc's...

Don't let my boss know I've been spending his money when he could have made me wait !!

Also check the data connection credentials and make sure that connector is providing good enough credentials;)

In order to do this I used Dundas chart for reporting services, its another cost on top of what youve already spent but it has more functionality than the MS...

I would reinstall Analysis Services 9.0 OLEDB Provider, this is available as a seperate install from the MS download site.

good luck