Seems to me that the account that is starting up the IIS server does not have permissions to read the ReportServer database.

In Enterprise Manager, open the ReportServer DB, go...

Also you may need to talk to the network gods , have them setup a trusted domain  group (this have to be setup on both...

You can try changing the Connect property of the tables, to change the Database name and/or the server name. But since this property is Read-only, the only way around I...

Unfortunately, MS does not support SMTP authentication (as of SP1). Don't know if SP2 will do, but more likely it won't.

See this link, or check the MS SQL Server newsgroups:

Create a parameter on the Report named Parm1, listing the month's names, and for value use the month number.

Then, in the query add the following to the WHERE clause:

month(DateField) =...

There is a documented bug in Access (at least was on 97), that when Access reads a SQL Server table, it only looks for the first index available. If that...

In my previous job we had Gentran running on a SQL Server database directly, and we queried its tables directly (CAUTION: you have to be EXTREMELY careful when doing that,...

My experience tells me that you always need at least one time the size of the table to be reindex of free space. So if the table is 2 GB...

Here are few more tips:

• Did you upgraded your database, or build-it from scratch on 2K3?. Sometimes the wizzard does not do a good job when converting complex forms/queries.
• In EM check...

If you have tables that are read-only, re-link them again but skip the part where you select the fields for the primary key. This will make the table read-only, eliminating...

I don't have any stats on it either, but a data warehouse from a vendor I work with is case sensitive. They mentioned that speed was the deciding factor for the...

Wow!, works great!.You're the man!

Added a few seconds to the execution, but works exceptionally well.

Thanks a lot!!!

Try this: compare the setting on both server on:

a) Transaction log mode. Maybe the Test is in Simple (non logged) mode, and prod may be full, more robust, but slower.

b) Autogrow...

I had the same problem before, but fortunately, the DB was separated in several filegroups. So we ran the DBCC CHECKFILEGROUP on each of them separately, and time them to...

See the webcast called "Advanced Reporting w SQL 2005". Even that the title reads "2005", the code they showed works for 2K too. They had a VB.Net app that reendered...