.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SQL Server Express R2 Database Engine fails to install on XP Home (SP3)

Posted By:      Posted Date: October 17, 2010    Points: 0   Category :Sql Server

I have had multiple failed attempts at installing SQL Server 2008 R2 Express on an elderly but reliable machine running XP Home with SP3. 
The support files and management tools loaded OK when I de-selected the database engine.  I was installing as a user with administrator rights. 
I wanted to start the DB as a service following boot without a user logged on.

The failure appeared as a message a 'Library not registered' at stage Slp_Config_SQLEngine_ADHlpr_Cpu32.  I cancelled at this point (although in other attempts I let it run on with similar, unsuccessful results).

Other posts covering failed installation do not appear to cover the same problem.  If they do, I am afraid it is my limited understanding!

The summary log file is below and what I think are the relevant lines from the detail are given after. 

Can anyone help identify the cause and suggest what I need to do to rectify it?

Many thanks.

Summary Log File
Overall summary:
  Final result:                  User cancelled
  Exit code (Decimal):    

View Complete Post

More Related Resource Links

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

SQL server express 2008 R2 , Could not find the Database Engine startup handle.


when i set the SQL Server database engine to NT AUTHORITY\NETWORK SERVICE the install works correctly but when i set it to NT AUTHORITY\SYSTEM i get a "Could not find the Database Engine startup handle." error , The Database engine services is not installed


The Summary Log File


Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2061893609
  Exit facility code:            1306
  Exit error code:               23
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:               

Preventing SQL Server 2008 Express install fails


I'm working on an installer, that installs SQL Server 2008 Express SP1 (soon I will upgrade to SP2) silently, so that my customers can install it without making choises. It all works fine, except of course when the SQL Server installer fails for some reason.

I start the installer with the following parameters:

/QUIETSIMPLE /ACTION=Install /Configurationfile={tmp}\sql2008setup.ini

The ini file simply looks like this:


I do not wish to keep coding my installer reactively, meaning I want to take care of install issues before they happen on the customer side. Therefore I would like to ask here, and find all possible error scenarios, and code my way around them.

I have read the Installing SQL Server 2008 article, but I still have some questions.

This is what I have come up with for my installer so far:

   1. Only install on OS equal or higher

SQL Server 2008 Express Management Studio fails to install because it thinks visual studio is instal


I tried to install SQL Server 2008 R1 Express with Tools on Windows Server 2008 R2. It installed, but the management studio failed to install because it said I already had Visual Studio installed and it needed Visual Studio service pack 1 before Management Studio could install.

Visual Studio is nowhere to be found in Programs and Features, and when I try to install Visual Studio SP1, it won't install, saying:

A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio 2008 (ENU) product family, and is not compatible with any Express editions.

Though I can't find any Express version of SP1 to try, and there is no SP1 in windows update.


Sql server 2005 fails to install on vista home basic

I am trying to install outlook 2007 with business contact manager, but the business contact manager fails to install because sql server 2005 fails to install. Message is setup failed to install the required component of microsoft sql server cna any one help

sql server 2008 r2 install does not create database engine, also mmc creates error "Failed to create


I am loading sql server 2008 r2 developer edition into Windows Vista Home Basic. Product loads correctly with no error messages; except will not create database engine. And will not create integration services. When I try to open MMC, I will get error "MMC could not initialize the snap-in. Product may not have been installed correctly."

I understand this is a known issue for SQL Server 2008 RD installing on Windows Vista? What is the workaround or fix? Hot fixes available for this issue from support.microsoft.com do not install on my Windows Vista Home Basic machine.


SQL Server Reporting Services not able to install on Windows Vista Home Premium


Recently I had a weird problem while trying to install SQL Server Reporting Service in my local PC. I am using Windows Vista Home Premium and I wanted to configure SSRS in my PC. During the installation, the setup wizard listed all the services that we want to install and I found that only Reporting Server checkbox option was disabled and I wondered why??? I thought it may be becuase of some installation problem and tried again and its useless... I googled lot of sites for 3 days and finally found that due to some IIS issues, it is not possible to install Reporting Server in Vista Home Premium version. Reporting Server needs some specific IIS features to be installed in the machine.

But unfortunately those features are not available for Home Premium users which in term restricts users not to install reporting server in our PCs... Also, Microsoft has accepted it as an issue and its not possible to get it install in Home Premium...just wanted to share and might be useful for someone like me.

Reference: http://support.microsoft.com/kb/920201/en-us

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

SQL Server 2008 R2 fails after Windows XP Pro SP3 install

We recently encountered an issue with SQL Server 2008 R2 failing to run after the upgrade from Windows XP Pro SP2 to SP3. This was tested and reproduced (with varying results) on more than one computer. Steps to reproduce this. On a Windows XP Pro machine with Service Pack 2 installed, install SQL Server 2008 R2. Next upgrade Windows to Service Pack 3. Now upon opening SSMS or trying to start the SQL server service you receive the following message: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem". In some instances reinstalling/repairing SQL Server 2008 R2 does fix the issue.  In other cases the installer crashes and you need to use msizap to clean it up before you can reinstall.  In other cases you do not receive any errors at all. After testing in multiple virtual machines it looks like the cleaner the Windows install the more likely you are to run into this issue.  On machines with most or all windows updates (prior to SP3) installed you do not necessarily even get the failure.  On machines with just Windows XP Pro SP2 installed with no additional updates you get the failure every time. Obviously the SQL Server 2008 R2 prerequisites are installed in all cases in order to be able to install SQL server to begin with. Any help with this would be appre

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

Which SQL Server 2005 Express Edition Service Pack to Install?

I have Windows 2008 Small Business Server Standard Edition.  When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number.  I'm wondering which I should install, or if both, what order to install them in?  The first one is labeled: Microsoft SQL Server 2005 Express Edition Service Pack 3 The second one is labeled: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine.  The new upgrade for this software requires SP3 which is why I need to know which service pack to install.  Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition.  I know sometimes registry settings need to be changed for SQL service packs to be installed properly. Thank you for your help.  

Cannot Install SQL Server 2005 Express due to MSXML 6 sp2

Got an XP Sp3 box - uninstalled SQL server 2008 Express r2.  Now I'm trying to install SQL server 2005 and am getting the ol' MSXML 6 SP2 error which is keeping SQL Server 2005 from installing.  Last time this happend there was the handy Installer Clean Up Utility but now you go to http://support.microsoft.com/kb/290301 and it's gone.  So what is the solution now?  Everything I've googled says to use the installer cleaner but it doesn't exist now so what now?

Can SSAS 2005 run with Sql Server 2008 database engine?

Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

SQL Server 2008 Express impossible to install.

As part of ARCserve backup r15, SQL Server 2008 Express is to be installed on a windows 2003 sp2 server (french language). All the prerequistes are present (power shell, .NET 3.5, Windows Installer 4.5...). The install fails with an -2147024893 error. I have not found anything conclusive about this error on the net. To get down on the issue I tried to install sql 2008 Express SP1 manually first. It fails with no error, returning to the main installation screen after installing the support files. The SQLSetup.log shows no apparent error but stop abruptly with the following : "Attempting to launch process d:\23ab1738a0f035434457b033\x86\setup100.exe"... as if this attempt was "suspended in the air". I have already tried to uninstall/install .NET 3.5 SP1, PowerShell, Windows Installer 4.5. No previous version of SQL had never been existed on this server. I even run "caspol.exe /machine -reset". I have tried the installation with SQL 2008 Express in english... I made registry cleanups... It's been one week of investigation and for the first time in my career I'm "dry". Is my case desperate ? Thanks   ******************* I enclosed the summary.txt when it's ARCServe r15 which is installing. I notice that "requested action" is "RemoveNode". I suppose it's related to any cluster. But we have not any cluster on the

SQL server 2005 SP2 KB921896 fails to install

Machine Specs: Windows XP SP3 Over 104GB HDD space available   When running the SP2 update I get "ngen.exe - Application Error" "The application failed to initialize properly (oxc0000005) Click ok.... Hit Ok it pops up a second time, hit Ok a small unexpected error message box pops up with no error code   I have tried a complete reinstall of SQL server 2005, I've tried stopping and restarting SQL services.   Reviewing the HotFix log... It fails when it attempts to pause the ngen queue 09/02/2010 09:00:29.984 Registry: Read registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "EnableErrorReporting", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "EnableErrorReporting", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "EnableErrorReporting", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.640 Locked file: Checking for locked files 09/02/2010 09:00:30.906 Locked file: C:\WINDOWS\system32\sqlncli.dll (MSSQLSERVER
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend