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

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

SQL Server 2008 R2 Setup fails to install properly

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

Hello, I am not able to install 2008 R2 on my laptop. I have 2005 and 2008 installed previously. It says in one of the attached screenshots that the OLAP service cannot be started. I have attached the errors in screenshots and also my summary log, please advise thank you.

Edit: I am able to manually startup the SQL 2008 R2 service, and can login as "sa" without a password... but strangely I did select mix mode authentication and did supply a password during the installation wizard too..


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

  Exit code (Decimal):           -733426222
  Exit facility code:         &nbs

View Complete Post

More Related Resource Links

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

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.........:(

Silent install of SQL Server 2005 fails when SQL Server 2008 is installed


We currently install SQL Server 2005 Express silently during our installation, using the following switches


We also attach a 2005-created database immediately after using the following command line (^ is a path concat operator in Installshield):

sqlcmd.exe -S .\\SQLEXPRESS -E -i \"" + svConfigPath ^ "SetupUapDB.sql\" -vmdfpath=\"" + svConfigPath ^ "UapCfg.mdf\" -vldfpath=\"" + svConfigPath ^ "UapCfg_log.ldf\" -o \"" + svConfigPath ^ "SqlCreateDB.txt\" -e

Note that we do not specify an instance name.  We ran into a situation where someone had installed SQL Server 2008 on a box using a default instance name and our install then failed.  I am considering 2 possible fixes, and have questions for both.

Fix #1: Specify an instance name.  Ideally this would install SQL Server 2005 Express side by side with SQL Server 2008, create a unique instance name and we'd be good to go right?  If yes, what is the accepted convention for specifying instance names?

Fix #2: Not sure if this is possible.  Can we detect if SQL Server 2008 is on the box, and if yes, apply our 2005 database to it instead?  In this case (tell me

Error During Install Sql Server 2008 "Sql Server Setup requires .Net Framework 3.5"


I Want install SQL Server 2008 Server on Windows Server 2008 64 bit, but when i start exe file the error generate " Sql Server Setup requires .Net Framework 3.5"

.Net Framework 3.5 SP1 already installed.

Kindly help me my work is stuck for this error.

SQL Server 2008 r2 - Setup support files - Install error / reading from file


I'm installing SQL server 2008 r2 on a Win2003 R2 x86 system.

After i start the setup, the "setup support files" box begins installing, after a while i get this error:

"Error reading from file f:\1033_ENU_LP\x86\setup\sqlsupport_msi\PFiles\SqlServr\100\Setup\ewbfphdh\x86\Patch\rs2000.msp verify that the file exists and that you can access it."

I've tried another DVD, i've tried a mounted share on another machine...no go....i've tried an ISO file mounted on this server... same error.

Is there any way i can install this "setup support files" from another location? (download)

Is there a switch soo it won't install reporting services? (...i think this file rs2000.msp is from reporting services)





Install fails wth SQL Server 2008 Enterprise on Windows Server 2008 R2


I have a new server onto which I have installed Windows Server 2008 R2 Enterprise. I have not been successful at installing SQL Server 2008 Enterprise on it. After many attempts, I continue to get the following error message:

        Microsoft .NET Framework 3.5 installation has failed.
        SQL Server 2008 setup requires .NET Framework 3.5 to be installed.

Some notes:

  • I got my copies of Windows Server 2008 R2 and SQL Server 2008 Enterprise through my MSDN subscription.
  • Upon first installing WinServer2008 R2, I notice that the .NET Framework 3.5.1 is not installed and is not available as a feature to add through the Programs and Features control panel.
  • Upon first installing WinServer2008 R2, Server Manag

SQL Server 2008 R2 Italian setup fails


I'm trying to install the italian version of sql server 2008 r2 on Windows 7 professional (language IT). I've tried different option:

1. from Microsoft Web platform site (failed)

2. using it_sql_server_2008_r2_express_x86.exe downloaded from the MSDN site (failed) from a command prompt with Administrative privileges

3. using it_sql_server_2008_r2_express_with_advanced_services_x86.exe downloaded from MSDN site (failed) from a command prompt with Administrative privileges

4. using the unpackaged content of the it_sql_server_2008_r2_express_with_advanced_services_x86.exe and running setup /ENU="False" (failed) from a command prompt with Administrative privileges

The setup program does not start and a message box is displayed saying:

"SQL Server setup media does not support the language of the OS or does not have ENU localized files. Use the matching language-specific SQL Server media or change the OS locale through Control Panel." The package is for the italian language, the OS language is Italian, the Language settings in Control panel are all for Italian.

It seems there is something wrong with the installation package. I've installe

MS SQL 2008 SBS install fails on Server 2008 R2 Standard edition


According to edition requirement (http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx), I thought I met the requirements but this link tells me not only I need both the standard edition AND in a domain??  I have Windows 2008 Standard R2 edition.


This is a standalone server and there's no domain.  I can promote it to be a domain controller but don't want that.  Is it the "R2" part that its failing.  I can downgrade to the non-R2 with SP2.  (Windows Server 2008 with sp2).

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 start after install on Server 2008 R2 SP1 64-bit


New install of Server 2008 R2 64-bit upgraded to SP1.

I have SQL Server 2005, no matter how I install it, it fails to start the main SQL Service giving me the error:

"The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.""

It then rolls back just that portion of the install and completes the install. I thought the following article might be the ticket, but no matter which SQL Server 2005 SP I try this with or which method they describe (reducing processor count, etc), I get the same error: http://support.microsoft.com/kb/954835/en-us

Is it SP1 on Server 2008 R2 that is the problem? I have found various articles online speaking of pretty much the same issue, but these are posted before SP1 and people seem to be able to get things working.

Any thoughts?

How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

Cannot install SQL Server 2008 R2

I download the SQL Server 2008 R2  and cannot complete set up because Windows Power shell failed the details stated that it has not been installed. Setup cannot not be completed.  How do I install Windows Power shell? I choose 64 bit setup because I have a  Vista Home Premium   Service Pack 2 64 -bit Operating System. Should I try to use 32-bit installuation set up?

SQL Server 2008 R2 Install on Vista

Hi folks, I am trying to install the 32 bit trial version of sql server 2008 R2 on my PC, which has windows vista premium. I launch the setup, I choose the install sql server 2008 R2 option, it goes through the first step, then i choose evaluation version and accept the terms, then get the window saying installing rules etc for the setup, hit the next button, nothing happens, I get the main setup window with all the options. The setup is not going through fully neither i get any error,,, what is the issue here, I have been trying to do this for the last couple of days. I have .net 3.5 framework SP1. Thank you RamdasRamdas

Connection to SQL server 2008 fails randomly

I'm sure a lot of you have seen this error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server" Normally I would assume that this would mean that there's a problem connecting to the SQL server, but currently I'm having a hard time figuring out what the problem is and how to fix it The problem only occours randomly, but mostly it is when I from the same computer calls the server several times for example like this: For i as integer = 0 to 500 OpenConnectionToSqlServer(Bla bla) ReadData() CloseConnection() next I always makes sure to close the connection again. The more often I connect to SQL server in a row, the higher is the percentage of errors I have created my code so that if the above error happens, the program will wait for a second, then try again (after 3rd try it will stop trying)   I have several times been monitoring the SQL server at the same time, but I can't seem to see anything from there :(

SQL Server 2008 Install failure - Reporting Services Rule Failures

I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n
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