.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 Express impossible to install.

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

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  

Install return code for product 'SQL Server Express 2008 R2' is Failure

I have winXP sp3. When i tried to install SQL Sever 2008 R2 through Web patform installer I got this error: DownloadManager Information: 0 : Loading product xml from 'https://go.microsoft.com/fwlink/?LinkId=193533' DownloadManager Information: 0 : Product manager downloading: https://go.microsoft.com/fwlink/?LinkId=193533 DownloadManager Information: 0 : Remote file has not changed, using local cached file:C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Web Platform Installer\-231145492.xml.temp DownloadManager Information: 0 : Loading product xml from 'https://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml' DownloadManager Information: 0 : Product manager downloading: https://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml DownloadManager Information: 0 : Remote file has not changed, using local cached file:C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Web Platform Installer\-1221301405.xml.temp DownloadManager Information: 0 : Filtering by majorOS: 5, minorOS: 1, majorSP: 3, minorSP: 0, productType: 1, architecture: x86 DownloadManager Information: 0 : Filtering by majorOS: 5, minorOS: 1, majorSP: 3, minorSP: 0, productType: 1, architecture: x86 DownloadManager Information: 0 : Adding product SQL Server Express 2008 R2 (SQLExpress) to cart DownloadManager Information: 0 : Product 'SQLE

Can't install SQL Server 2008 R2 Express Edition x64 from Command Line


I can't get R2 Express (x64) installed from the command line... x86 using this same command line works fine, just x64 is broken.

Using this:


Everytime it fails with:

2010-09-19 15:30:48 SQLEngine: : Checking Engine checkpoint 'ConfigureServiceBroker'
2010-09-19 15:30:48 Slp: --SafeSqlCommand: ALTER DATABASE tempdb SET NEW_BROKER ALTER DATABASE msdb SET NEW_BROKER
2010-09-19 15:30:48 Slp: Sco: SqlException: Message:The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Onlin

Cannot install SQL Server 2008 Management Studio Express


I can't get the SQL Server Management Studio to install.  I'm running Windows 7 (32-bit), and have successfully installed the Sql Server 2008 R2 developer edition (from dreamspark.com).  Some of the SQL Server (SQLEXPRESS) advanced Properties are as follows:

File Version: 2007.100.4000.0


64-bit OS: No

Service Pack Level: 2

Version 10.2.4000.0

I downloaded the x86 SSMS 2008 express from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b

When I execute the download, I get a compatibility issues message stating I must apply SQL Server 2008 SP1 or later before I run SS2008 on my version of windows.  When I run the program, it extracts all the files and then launches the SQL Server Installation Center.

I select the "Installation" option for a new SS stand-alone or add features, which then launches the Setup Support Rules (Passed: 7, Failed: 0, W:0 S:0).  I click OK, advancing to the Setup Support Files stage.  Clicking on install completes (P:10 F:0 W:1 (firewall) S:0), and then clicking on Next brings me to the Installation Type screen. I select the Add Features radio button & click Next, which then brings me to the Feature Selection screen.

It is here where I get stuck because I can't select any

How do you install SQL Server management studio express 2008?


Why do you make it so, so complicated?

I just want to install the piece of software that manages Azure databases. I've being downloading all kinds of files all day, getting incomprehensible error messages, and still am getting no where!

I'vw worked out that it's not this file: SQLManagementStudio_x86_ENU.exe

or this one: SQLEXPRWT_x86_ENU.exe

So please, which file is it, and where can I download it?

SQL Server 2008 R2 Express Install Crash


When installing with a command line (that doesn't include any pathing so that it should install to the default location) we are routinely seeing failures of the installer where the log files are pointing to the DVD drive of the machine (normally Windows 7 but we've seen some Vista installs do this) as the destination installation point.

This is causing a ton of support issues because we have to manually install SQL Server to get our app to run.

I have all of the log files and trc files of the installer and  the command line if someone can look at it.

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 2008 Express install probelms


I am having a huge problem installing MS SQL Server 2008 Express Edition.

It seams I have a old SQl Server 2005 installation that was removed but not successfully. It have read many many pages of how to fix this but I have hit a dead end.

Things to note: 

a) I have NO SQl Server 2005 disks so I can not go back and re-install or access the installed msi

b) When I try and uninstall the componenets of SQL Server 2005 via Add/Remove Programs, they all Fail.


I have read MS article of:


How to uninstall an instance of SQL Server 2005 manually

and this dead ends me into an error trying to uninstalling the SQl Server Components:


MSI (c) (58:E0) [11:21:25:546]: SOURCEMGMT: Trying source C:\Documents and Settings\Michael\My Documents\SQL Server\Servers\Setup\SqlRun_RS.msi.
MSI (c) (58:E0) [11:21:25:578]: SOURCEMGMT: Source is invalid due to invalid package code (product code doesn't match).
MSI (c) (58:E0) [11:21:25:578]: Note: 1: 1706 2: -MSI (s) (6C:04) [11:26:13:390]: Running as a service.


Now I checked further and found the "supposive only solution" of: 


I installed SQL Server 2008 Express 64-bit, but I can't install SQL Server 2008 Management Studio E

I installed SQL Server 2008 Express 64-bit Runtime succesfully on my Windows Server 2008 Enterprise SP2 64-bit. However when I start the setup to install SQL Server 2008 Management Studio Express (SSMSE) 64-bit Edition, I get the following error message:

SQLManagementStudio_x64_ENU.exe is not a valid Win32 application. OK.

Conclusion: I can't install this Management Tool for SQL Express server. I don't understand the error message. All is 64-bit. Does the message mean that I have to install the 32-bit version? Why? That doesn't make sense, as everything is running in 64-bit.

Any resolution to this issue?

Error with SQL Server 2008 R2 Express Install on Windows 7


Does anyone have any ideas on how to proceed? Installing will not complete.  I receive the following error when I try to install SQL Server 2008 R2 Express-

Any help is greatly appreciated!

************** Exception Text **************
System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\rhaas\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
File name: 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'
at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)
at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)

Sql Server 2008 Express Will Not Install on My XP SP3 machine


I have tried installing Sql Sever 2008 express multiple times manually and through other software that require it as a prerequisite.  It just fails to install and tells me to check the Install log.  The install log is below:


The following properties have been set:

Property: [AdminUser] = true {boolean}

Property: [InstallMode] = HomeSite {string}

Property: [ProcessorArchitecture] = Intel {string}

Property: [VersionNT] = 5.1.3 {version}

Running checks for package 'Windows Installer 3.1', phase BuildList

The following properties have been set for package 'Windows Installer 3.1':

Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe'

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true

Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'

'Windows Installer 3.1' RunCheck result: No Install Needed

Running checks for package 'Windows Installer 4.5', phase BuildList

Looking up path for special folder 'WindowsFolder'

Running check with folder 'C:\WINDOWS\System32' and file 'msi.dll'

Attempting to find file 'C:\WINDOWS\System32\msi.dll'

File version is '4.5.6001.22299'

Setting val

SQL Server Express 2008 R2 Cant Install


problem is Visual Studio 2008 is not on SP1.  running win 7 64 bit.  i onlyhave vs 2010 installed and cannot find

a way to do VS 2008 SP1.  uninstalled express and tried to install several times.  DB installs management studio does not.  uninstalling VS 2010 is not an option

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

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

guide to uninstall sql express 2008 and install sql express with managment studio

i have installed sql express 2008 and i need to install sql express 2008 with management studio what steps do i have to follow ? I have downloaded the 3 variances of sql1.sql express 2. sql express with management studio . 3.sql express with advanced servicesHow can i completely uninstall sql 2008 express and install it with management studio?Thank you for your timeAlex
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