Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Installing SQL 2008 R2 in a Hyper-V environment

Posted on 2012-03-21
8
Medium Priority
?
1,157 Views
Last Modified: 2012-03-29
I've recently installed Windows 2008 R2 Enterprise and created a virtual server within with Windows 2008 R2 Standard. I've installed all of the necesarry roles required for SQL. I created my SQL service accounts. When I go to install SQL 2008 R2 I get the below error and of course there is no information when I click the link.

TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------

The following error has occurred:

External component has thrown an exception.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x987D2693%25400xE8A9805D

------------------------------
BUTTONS:

OK
------------------------------
0
Comment
Question by:ISCBrussels
  • 4
  • 3
8 Comments
 
LVL 84

Expert Comment

by:David Johnson, CD, MVP
ID: 37751837
Installing in a virtual environment is identical to installing in a real environment. In the precheck do you get any warnings or errors? What type of install are you trying to do?
0
 
LVL 5

Expert Comment

by:CarlosDominguez
ID: 37752641
Please confirm if you have a normal (release) or a debug build of the Windows Server 2008 R2 OS.
This error could be related to installing SQL in a debug version of Windows.
0
 

Author Comment

by:ISCBrussels
ID: 37764641
I installed an MSDN membership free license of Server 2008 R2. I thought installing it in a virtual environment would be the same as a normal environment but the error is still odd. I've tried adding all the possible memory and processors to the virtual machine to see if that was causing the problem but no luck.

I had no errors on the pre-check before SQL tried to install, that's what makes it even more confusing.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:ISCBrussels
ID: 37764850
Today I tried installing SQL developer instead of the Standard version to see if it made any difference but nope, same errors. I've included some screen shots of what I'm getting. Maybe it will be some sort of clue. I'm probably missing something simple but I don't have previous experience with installing SQL 2008 R2 and even less in a Hyper-V environment. Any help would be very much appreciated.
sql-error-installation.doc
0
 
LVL 5

Expert Comment

by:CarlosDominguez
ID: 37765527
Dear ISCBrussels,
Exactly, I think that the problem is the build of the OS. You have downloaded a checked build (debug build) from MSDN.
Please run "regedit.exe" and go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion
Please let me know the values of the key BuildLabEx, and if you can see something like "checked" or "debug" in any other key in that branch.
0
 

Author Comment

by:ISCBrussels
ID: 37765625
7600.16385.amd64chk.win7_rtm.090713-1255

and it has multiprocessor checked.
0
 
LVL 5

Accepted Solution

by:
CarlosDominguez earned 2000 total points
ID: 37765709
Exactly. the "chk" letters, and then "multiprocessor checked". Checked means debug version of the operating system. This is the reason of the problem you are having with SQL Server 2008 R2.

If you could install using a new media of Windows Server 2008 R2, then you will solve the problem.
I don't know if there could be any other way to avoid the error.
0
 
LVL 5

Expert Comment

by:CarlosDominguez
ID: 37765741
Unfortunately, cross-build type in-place upgrades (for example, fre to chk or chk to fre) are not supported. You have to do a clean install.
http://technet.microsoft.com/en-us/library/dd979563(v=ws.10).aspx
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, Virtual Machines are used equally by small and large scale organizations. However the issue is that VMDK files are also prone to corruption. So, in this article we are looking at how to recover VMDK files from hard disk of host operating s…
Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question