General Question

GrayTax's avatar

Why can I not install MS SQL Server Express 2008 R2?

Asked by GrayTax (551points) October 21st, 2011

I’ve installed Visual Studio 2008 SP1 (an apparent requirement for the installation of MSSQL Server Express 2008 R2), but I still can’t continue with the installation of MSSQL due to it failing the SP1 check.

I had the same SQL Server edition running fine not six months ago but had to uninstall; what could have gone wrong between then and now, and how can I fix this?

Observing members: 0 Composing members: 0

4 Answers

blueiiznh's avatar

Please provide details on what and how it fails the precheck.

Zaku's avatar

Ya, as blueiznh wrote, it’s hard to know without more info about the reported error. So I don’t know. I have installed it ok several times, including on a machine with Visual Studio 2008 SP1. The MS forums would be a good place to ask.

Oh, and is there really a Visual Studio requirement? I have a client who has installed SQL Server 2008 R2 on two computers, neither of which do I think has any Visual Studio on it at all.

GrayTax's avatar

What: Fails the Visual Studio SP1 check (it was in the original question =1)

How: As far as I could find out, the SQL Server installer was looking in the wrong place for the registry value that denotes a successful installation of Visual Studio SP1 (or the registry value hadn’t been placed, I don’t know).

Zaku – Apparently so. I was a little surprised as I too was able to install SQL Server 2008 R2 on my desktop 6 months ago, and that certainly didn’t have Visual Studio installed.

Fix: Not the most glamorous way to go about it, but seeing as none of the suggestions on the kb article for it worked I ended up following this command-prompt based fix

blueiiznh's avatar

@GrayTax sorry, but it was a bit unclear as to what error it stated for failing in your OP.

Here are the Microsoft Articles on this:

http://support.microsoft.com/kb/956139

http://blogs.msdn.com/b/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther