Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

On a Wndows Server 2008 R2 64 bits, I installed Visual Studio 2010 Express, which installed a SQL Server 2008 Express:

start menu with SSMS

Trying to install a SQL Server Management Studio, first I'm required to install Service Pack 1. But when trying to do so, I got the following error:

There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom Setup page, then provide valid parameters or click Help for more information.

As shown in this image:

installer error message

Then I uninstalled all SQL Server 2008 components from my server and tried to install Full SQL Server from this Microsoft download page.

(when installing, I would select Express Edition)

No luck, when trying to run setup.exe I get the following errors:

This program has known compatability issues.

installer error messages

Then I click n "Check for solutions online" button, but then I get other errors:

Your version of SQL Server 2008 isn't compatible with this version of Windows.

error explanation

share|improve this question
add comment

1 Answer

You need to install SQL Server 2008 first, then before running or rebooting install SQL Server 2008 Service Pack 1.

You are attempting to install the service pack files first, without an existing base installation of SQL Server 2008. Since the Service Pack 1 package does not contain a full installation of SQL Server, you must have already installed the non-service-pack version. The other option would be to create a slip-streamed version of SQL Server 2008 setup by, essentially, combining the Service Pack 1 with the original version on DVD - then installing directly from that. Check https://duckduckgo.com/?q=%22sql+server%22+slipstream+setup for more info.

Don't click "Check for solutions online", click "Run Program" instead. After that completes, install Service Pack 1.

share|improve this answer
add comment

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.