SQL Server 2008 Standard is having a setup failure

Asked By Lynne 200 points N/A Posted on - 06/22/2011

Hi folks,

I have a problem while trying to install SQL Server 2008. I was previously using SQL Server 2005.

So I decided to upgrade to 2008, but instead of upgrading directly using the 2008 wizard, I opted to uninstall SQL Server 2005 first, then install 2008. Halfway during the installation I get the following error;

SQL Server Setup failure

            SQL Server Setups has encountered the following error:

            The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE)). 

I am installing from a CD to a x64 Windows 7 Pro machine. I had management studio installed in my computer so I thought that could be the issue but even after uninstalling it, I still get the same error.

SQL Server 2005 installs just fine, but I just can’t manage to install 2008. I also tried installing it on another machine running windows XP SP3, and it installed just fine.

So I don’t understand what could the problem be in my machine or is it the OS I am using?

Thanks.

• Status: Open
• Question Views: 6817
• Answer Count: 2
• Vote Up 20 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by stephy_john

Go To Solution

Best Answer

Best Answer

Answered By stephy_john 0 points N/A #129024

SQL Server 2008 Standard is having a setup failure

Dear Lynne,

This issue/problem relates to your x64 windows 7 pro and this version of SQL Server 2008 which you are trying to install, is not compatible with your operating system. SQL server 2008 supports all 32 bit operating systems so it is running fine on XP SP3.

Solution 1: Install 32 bit operating system on your machine instead of 64 bit and install SQL server 2008 on it.

Solution 2: Purchase/download SQL Server 2008 Enterprise Edition. This edition will support your 64 bit operating system.

You can see all comparisons of key capabilities between SQL Server 2008 Enterprise, Standard, Workgroup, Web and Express edition here: 

Take Care,
Stephy.

About stephy_john

Questions
0

Answers
34

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 07/06/2011
• Question Category: MS SQL Server

Answered By Queen Noman 0 points N/A #195711

SQL Server 2008 Standard is having a setup failure

HI.

That problem occurs when previous installation or parts of it are still on system. To resolve this you have to remove any of unresolved files. After you have removed them you can perform SQL Server installation process. If that error still repeats, then open CMD on your server and type the following command

C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis.exe -i

After that command run your SQL Server 2008 setup.

Queen Norman

About Queen Noman

Questions
0

Answers
100

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 11/19/2013
• Question Category: MS SQL Server