We have a test server running Windows Server 2008 R2 that I want to put SQL Server 2008 onto. I have an MSDN subscription and thought I could install (x64 version) SQL2008 but the installation warned me this wasn't compatible with this version of windows (reporting that I am running Windows 7).
When I log onto my MSDN to download an update the only SQL Server R2 options I have are for Express edition or Enterprise evaluation (I am logged in to subscriber downloads). Is there no standard R2 edition or am I missing something?
Best Answer
The 2008 install warns you that there are known compatibility issues. This is correct.
Ignore the warning (i.e. run the install), then install the latest service pack for SQL Server 2008 (and the latest cumulative update) and you are ok.
The warning is explicitly for the non-sp1 version of SQL Server 2008. There are known issues. They got fixed in a service pack.