I was trying to install MSSQL 2008 server on Windows 2008 server R2 Standard Machine, but I got this message:

Program Compatibility Assistant, And that I should apply SQL server 2008 SP 1

I don't get it? Why doesn't it not work with this version I have? How should I solve this problem?


It will install however right after you install SQL Server 2008, you need to install Service Pack 1.

You can download SQL Server 2008 Service Pack 1 from here.

  • okej thanks a lot, how do I get the updates for SQL server 2008??
    – Nezdet
    Apr 3 '10 at 4:12
  • 1
    You can download it off the net at: microsoft.com/downloads/…
    – Thomas
    Apr 3 '10 at 4:53

It does not work with the version you have because the version you have is terribly outdated and was released efore WIndows 2008 R2. Microsoft fixed compatibility issues in the service pack 1.

Given that by now there is service pack 2 released, and asignificant number of cumulative update packs - what exactly is the problem you have? DO you INSIST on running an old, outdated and buggy version of SQL Server?

Just install it, then apply the latest service pack and the latest CU.

  • Thanks a lot for your anser,, How will I find the updates,, cause I was trying with windoww update,, and it could'nt find the updates.
    – Nezdet
    Apr 3 '10 at 4:20
  • SHould I download them one by one from windows download page or??
    – Nezdet
    Apr 3 '10 at 4:25
  • 1
    AFAIK, SP2 for SQL Server has not yet been released.
    – Thomas
    Apr 3 '10 at 4:55
  • 2
    SP2 for SQL Server isn't slated to be released until Q3/2010. blogs.msdn.com/sqlreleaseservices/archive/2010/02/12/…
    – Thomas
    Apr 3 '10 at 4:57
  • Yes, sorry. The main point still stands - install, update latest SP, latest CU. NO reason not to.
    – TomTom
    Apr 3 '10 at 6:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy