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...

Are you running the BC file included in the SQL 2008 media? If you are then it would have been better to have included backward compatibility as one of...

The SEE_MASK_NOZONECHECKS environment variable does not normally exist. When it does not exist Windows assumes the setting is off. Use the command SET SEE_MASK_NOZONECHECKS=1 to turn it on,...