{"id":401,"date":"2009-11-25T18:44:58","date_gmt":"2009-11-25T16:44:58","guid":{"rendered":"http:\/\/mariusbancila.ro\/blog\/?p=401"},"modified":"2009-11-25T18:44:58","modified_gmt":"2009-11-25T16:44:58","slug":"problems-installing-sql-server-2008","status":"publish","type":"post","link":"https:\/\/mariusbancila.ro\/blog\/2009\/11\/25\/problems-installing-sql-server-2008\/","title":{"rendered":"Problems Installing SQL Server 2008"},"content":{"rendered":"

I ran across a breaking error while trying to install SQL Server 2008 on a Windows 7 machine. The rule “Previous releases of Microsoft Visual Studio 2008” failed. Here is the error message that I received.<\/p>\n

\"Rule
Rule "Previous releases of Microsoft Visual Studio 2008" failed.<\/figcaption><\/figure>\n

That was odd, because I actually had Visual Studio 2008 with SP1 installed on that machine. So I start looking for answers and found this Knowledge Base article (KB956139)<\/a> from Microsoft that said that if Visual Studio 2008 SP1 was installed then “No action is required.<\/strong>” Obviously that didn’t help at all.<\/p>\n

Then I start looking into the logs (which are located under C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\). There is a log file called Detail.txt<\/strong> that revealed the following error:<\/p>\n

2009-11-25 17:09:35 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey SOFTWARE\\Microsoft\\DevDiv\\VS\\Servicing\\9.0\\IDE
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey 1033
\n2009-11-25 17:09:35 Slp: Sco: Attempting to get registry value SP
\n2009-11-25 17:09:35 Slp: Sco: Attempting to get registry value kind for value SP
\n2009-11-25 17:09:35 Slp: Found Microsoft Visual Studio 2008 edition IDE, language 1033, SP level 0.
\n2009-11-25 17:09:35 Slp: Microsoft Visual Studio 2008 edition IDE, language 1033 does not have required SP level. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.
\n2009-11-25 17:09:35 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey SOFTWARE\\Microsoft\\DevDiv\\VS\\Servicing\\9.0\\STD
\n2009-11-25 17:09:35 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey SOFTWARE\\Microsoft\\DevDiv\\VS\\Servicing\\9.0\\PRO
\n2009-11-25 17:09:35 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey SOFTWARE\\Microsoft\\DevDiv\\VS\\Servicing\\9.0\\VSTD
\n2009-11-25 17:09:35 Slp: Sco: Attempting to open registry subkey 1033
\n2009-11-25 17:09:35 Slp: Sco: Attempting to get registry value SP
\n2009-11-25 17:09:35 Slp: Sco: Attempting to get registry value kind for value SP
\n2009-11-25 17:09:35 Slp: Found Microsoft Visual Studio 2008 edition VSTD, language 1033, SP level 1.
\n[…]
\n2009-11-25 17:09:35 Slp: Rule evaluation done : Failed<\/p><\/blockquote>\n

It looked like the IDE’s version was not correctly specified in the registry under HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\DevDiv\\VS\\Servicing\\9.0\\IDE. This post from Heath Stewart’s blog<\/a> explains how to detect the version of Visual Studio 2008. The SQL Server 2008 installer looks in the right place, so the only explanation was that there was incorrect data there. So I started regedit.exe and looked at the key. To my surprise there was no IDE key there.<\/p>\n

\"No
No key for IDE<\/figcaption><\/figure>\n

But then I remember I was running Windows 7 64-bit and there are several registry editors (I’m still confused which to use when). So I opened the one located under C:\\Windows\\SysWOW64\\ and this one shown more keys under DevDiv, and under Servicing\\9.0 I could also see IDE.<\/p>\n

\"Incorrect
Incorrect version of VS 2008 IDE<\/figcaption><\/figure>\n

As you can see from the screenshot, the SP value was 0, and SPName was “RTM”. The Visual Studio 2008 SP1 installer didn’t update these keys. (Well, that wasn’t such a big surprise, because the Visual Studio 2008 SP1 installer really sucks, but that’s another story.) So, what I did was to change those keys as shown in the following image. SP and SPIndex should have the value 1, and SPName should be “SP1”.<\/p>\n

\"These
These are the correct values<\/figcaption><\/figure>\n

Also, make sure that the same values under the parent (Servicing\\9.0) are 1.<\/p>\n

\"Correct
Correct values for SP and SPIndex unde Servicing\\9.0<\/figcaption><\/figure>\n

After making these changes I ran the setup again, and this time it worked like a charm. If you run into the same error and Visual Studio 2008 SP1 is installed then check these registry values and make sure they indicate that SP1 is installed.<\/p>\n","protected":false},"excerpt":{"rendered":"

I ran across a breaking error while trying to install SQL Server 2008 on a Windows 7 machine. The rule “Previous releases of Microsoft Visual Studio 2008” failed. Here is the error message that I received. That was odd, because I actually had Visual Studio 2008 with SP1 installed on that machine. So I start … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[52,10],"tags":[56,177,178,176,33],"class_list":["post-401","post","type-post","status-publish","format-standard","hentry","category-tools","category-visual-studio","tag-errors","tag-installer","tag-sp1","tag-sqlserver2008","tag-vs2008"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t