sql is tcp 1433, udp 1434.

HTH

I've passed the upgrade exam back in Jan and the only real differenced between 2005 and 2008 as far as the exam was concerned was Spatial Data, Compression, CDC and...

Now I'm worried!

I've got my exam this weds coming (2 days time!) and was reasonably confident; Not so sure now!!!

Is the error from your own custom error reporting or Built-In SQL?

Have you tried using dbo.sp_send_dbmail ?

Depends on a couple of factors:

- Are your disks on a SAN?

- How big are your DB's likely to be?

- How active are your DB's ?

- Whay type of data...

I would also suggest putting in a DNS Alias for your SQL Connection String; i.e. SQLReporting > 10.0.0.1; that way if you ever need to migrate your database out to...

Another option is SQLH2 which comes with a reporting pack and a comprehensive stack of supporting tables.

http://www.microsoft.com/downloads/details.aspx?familyid=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en