I am sure I have got native DTS packages to run on SQL Server 2005 64-bit, so it may be worth building a test environment with this configuration to see...

If you have someone in your organisation who already knows how to use DoubleTake for non-database files, then ask them about setup and configuration. There may be some site...

You will need a separate IP address, network name and disk volumes for the AS cluster. You will also need to supply the ASDOMAIN parameter, and the AS service...

I have had no particular problems installing SQL Server 2005 on Windows 2008 (or W2008 R2), but you do need to be aware of compatibility issues.

SQL 2005 requires .Net 2.0,...

martyn, your approach sounds like a good approach given the constraints you have.

Overall, my understanding is that most people prefer to put SSRS on dedicated servers, even if they use...

Getting SSRS to install on a cluster is tricky. It is a problem I am still working through and do not have a complete answer.

One way to get it...

You have to download FineBuild to get the Reference document.

The oldest version of FineBuild still has a separate download for the Reference Document, but I recommend you download the latest...

I do not think there is any way to get your jobs generated with meaningful names. The only option is to change the names after they have been generated.

I...

You cannot transfer a SSIS package from SQL 2005 or above to SQL 2000 DTS. SSIS and DTS are two separate products.

You can install SSIS on a SQL Server...

And how do you get the development team to be bothered about production performance?

Simples.

You include performance criteria in the development sign-off requirements. These are often known as...

SOA and OR tools are definitely becoming a standard. They can allow more rapid development than many other approaches, but often come with an implied promise that they can...

If you are trying to lock down security then revoking all access to public in the master database is not the best way to do this. What you have...

PS Also check out http://articles.techrepublic.com.com/5100-22_11-5270774.html to see if access is restricted to specific registry keys.

I have had this situation in the past and every time it was a Windows security issue.

The troubleshooting you have done has in my mind proved that the target server...

You then say that previously you had other instances of SQL installed, you then tried a SQL 2008...