Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

4 Answers 4

up vote 6 down vote accepted

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.

share|improve this answer
    
+1 for information, but -1 for spelling? (Sorry if English is not your native language though) –  Guy Mar 10 '10 at 20:41
    
+1, and spelling fixed! ;) –  Darth Satan Mar 10 '10 at 23:50
    
Thanks - I've installed SQL fine, just downloading SP1 for x64 now. –  Dan Mar 12 '10 at 13:35
    
Non-native engllish speaker, Guy ;) Apology accepted. –  TomTom Mar 14 '10 at 7:31

SQL 2008 is the latest released version of MS SQL server, I would suggest this is the correct version. The reason it is failing is likely:

The .NET 3.5 framework is not enabled on Windows 2008 R2 by default - see this KB article

share|improve this answer

Checkout the requirements for installing SQL Server 2008 Hardware and Software Requirements for Installing SQL Server 2008. As per the link, you cannot install Enterprise edition on Win7. You can try Express or Standard edition.

share|improve this answer
    
Dan has Windows Server 2008 not Windows 7 –  Dave M Mar 10 '10 at 18:58
    
my bad, miss read the question. –  Vivek Kumbhar Mar 10 '10 at 19:01

To run SQL Server 2008 on Windows Server 2008 R2, you need to install SQL Server 2008 SP1. You can either install this after the fact, or create a slipstreamed installation point.

See Microsoft Support: How to update or slipstream an installation of SQL Server 2008

I use a slipstreamed installation point and run setup.exe from the command line - this is much faster, since you don't have to click through the setup wizard or wait for the 'Setup Support files' to install.

Just open an elevated command prompt and run this command to install SQL, Analysis Services, Reporting Services, SQL Management Studio and BIDS in about 15 minutes:

C:\SQL2008SP1Slipstreamed\Setup.exe /q /ACTION=Install /FEATURES=SQL,FullText,AS,RS,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="NT Authority\Network Service" /RSSVCACCOUNT="NT Authority\Network Service" /ASSVCACCOUNT="NT Authority\Network Service" /AGTSVCACCOUNT="NT Authority\Network Service" /SQLSVCStartuptype=2 /RSSVCStartupType=2 /ASSVCSTARTUPTYPE=2 /AGTSVCSTARTUPTYPE=2 /BROWSERSVCStartupType=2 /SQLSYSADMINACCOUNTS="Builtin\Administrators" /ASSYSADMINACCOUNTS="Builtin\Administrators" /SQMREPORTING=1 /ERRORREPORTING=1 /INDICATEPROGRESS

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.