HA!

ROTFLOL!

Then the only thing left is the firewall issue Ian mentioned.

Tell me about it!

At least I'm not going to waste a day's worth of "making it purty" now that I know it wasn't my fault. @=)

Try deleting the Linked Server and recreating it. Sometimes that's the only thing that can help in situations like this.

Fiona,

Make sure your font sizes are also all the same. This is another issue that can cause line up problems between subreports and main reports.

Not that it helped me...

Are you sure you haven't typo'd the Server name itself?

Fiona,

I'm having the same problem. Everything's lined up in preview, but not in the Report Server website. I think it's a rendering issue, but I can't figure out...

That tells me the account you were using had something wrong with it. Maybe a typo or maybe a permissions issue. Once you figure out what the problem...

Make sure the user account that you've got set up with this linked server has the appropriate permissions on the database for the T-SQL query you're trying to run. ...

What's the exact text of the new error message?

All the above suggestions are assuming you've already installed SQL Server with the wrong collation.

If you haven't installed it yet, you can change the collation during the install...

Oh, and what service pack is running on your 2005 Cluster? SP1, SP1 with hotfix or SP2?

Sunny,

What Service packs for SQL 2000 are you running on all your machines?

And do what Ian suggested, try to set up linked servers between the non-clustered servers and see if...

Have you verified that the other SQL Servers have Remote Connections enabled?

Check the Surface Area Configuration Tool on each of the servers. If Remote Connections is not enabled, you'll...

Deleting it from the programs menu only deletes the shortcut to the program. Go back to Add/Remove Programs and try uninstalling it from there again.

Once done, go into Windows...