If you get a message that the SQL Edition is not valid for the Windows Edition, then you need to use a different Edition of SQL 2005 that is valid.

If...

You can avoid the learning curve of Metro and give your server a bit more performance by running it in Core mode.

We are only part-way through migrating from W2008R2 to...

A few things to consider:

1) Windows 2008 does not take advantage of Second-Level dress Translation (SLAT), while Windows 2008 R2 and above does. This typically gives a 5% performance...

Have you looked at S3Browser. There are both GUI and command-line versions available.

The unzipped version should look like the screenshot below. We normally just copy the media over the network to whatever server we want to run the install on.

There are a few choices...

a) You can mount the iso file in a virtual DVD drive on the server where you want to run the install

b) You can install a...

SSRS will go to sleep after about 20 minutes of no-one using it. The next person who uses it will wait for about a minute for SSRS to wak...

Using a domain user account for SQL Agent works fine in SQL 2012 (and SQL 2005, 2008, 2008R2, 2014), you just have to give it the correct rights.

It needs:

Act...

That is true! SQL does not support a hostname over 8 characters.

You can create a SQL cluster without MSDTC, but normally MSDTC would be involved.

There is nothing stopping you creating a single-node MSDTC cluster to live with your single-node SQL cluster.

If...

We use Amanda Enterprise to back up directly to S3 (no intermediate staging).

This takes our standard SQL backups and all the non-DB files that need backup and puts them all...

I agree that the SQL Server license model is badly designed, and I would much prefer a model based around capacity rather than features. Also the 'virtualisation tax' of...

You need to install SQL 2005 backward compatibility and the DTS designer components in order to edit DTS packages with SQL 2008. Ther are also some post-install steps you...

It sounds like you are fairly new to SQL Server replication. There is a lot to learn, and you never stop learning. We have used replication for...

The most reliable fix is to reinstall Windows.

You may be able to get things working by hacking the registry, but you will probably take longer to get things working with...