.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

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

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

View Complete Post

More Related Resource Links

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

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

Probem after installing SQL server 2008 R2 express edition

Hi, I tried to install SQL server 2008 R2 express edition, but there were many error, So I can't now create sdf files in VS , here is the repporte that was created : 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):           -2068119551   Exit facility code:            1211   Exit error code:               1   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:                    2010-09-03 11:36:31   End time:                      2010-09-03 19:37:53   Requested actio

Error 0x84BB0001 while installing SQL Server Express 2008 SP1

Hello,   One of our internal customers is getting an error 0x84BB0001 while installing SQL Server 2008 Express SP1.  His operating system is Windows XP SP3 and he should have all of SQL's prerequisites. I've seen a few postings of this error, but no explanations/resolutions.   Thanks.

Unable to install SQL Server 2005 Express: The error is (-2146885628) Cannot find object or propert

I am installing 2 instances of SQL Server 2005 Express for 2 different accounting packages on Windows XP SP3.  I have the first installed, after much use of the forums.  The version of setup.exe was 2005.90.2047.0. I am not able to install the second, for Microsoft Office Accounting 2009, setup.exe version 2005.90.3042.0.  The error I am getting in Summary.txt is: Error String    : 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." The error is  (-2146885628) Cannot find object or property. Error Number    : 29503 The errorlog file for MSSQL.2 has a lengthier description: 2009-09-05 23:00:32.13 Server      Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)     Feb  9 2007 22:47:07     Copyright (c) 1988-2005 Microsoft Corporation     Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 2009-09-05 23:00:32.31 Server      (c) 2005 Microsoft Corporation. 2009-09-05 23:00:32.31 Server      All rights reserved. 2009-09-05 23:00:32.32 Server      Server process ID is 5516. 2009-09-05 23:00:32.32 Server      Authentication mode is MIXED. 2009-09-05 23:00:32.35 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'. 2009-09-05 23:00:32.38 Server      Regi

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

Unable to install SQL Server 2008

HI, I am uable to install SQL SERVER 2008 in my machine. The setup checks in the pre requisites and it fails for a server reboot. It prompts me to reboot the machine. I have already rebooted my machine thrice but still its prompting me for a reboot. Can anyone guide me through this?     Regadrds, Shannid

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

Error Installing SQL Server 2008 Express: '' is not a valid login or you do not have permission


I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission.

I have tried installing both SQL Server 2008 Express with Tools and SQL Server 2008 with Advanced Services, and they both fail the same way. I am trying to do a new stand-alone installation.

I'm running Windows XP Home Edition SP3.

Looking into the error, some forums say I have to install it from THE Administrator account, and not an account with administrator permissions; it also cannot be in Safe Mode, because then the Windows Installer won't work. Unfortunately, I haven't been able to login to the Administrator account. I can go to the home login screen, do ctrl+alt+del twice, and attempt to login to the Administrator account, but I receive this error: Unable to Log You on because of an Account Restriction.

Other forums say that in the Server Configuration section, all you have to do is provide the username and a strong password from an administrative account on the computer, and it doesn't have to be THE Administrator. Well, I did that, but for some reason it doesn't recognize my username and passw

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?

Unable to Install SQL Server 2005 Express Edition on Windows 7



 i am trying to install SQL Server 2005 Express Edition on Windows 7. it requires to install Windows installer also. While installing Windows Installer it gives me error that " Do not have enough storage Space in Disk", however i have 150 GB free space in HD.

Please help.. Thanks in advance

Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


Installing SQL Server Express 2008 SP2

Is it wiser to uninstall SQL Server 2008 Express SP1 before installing SQL Server 2008 Express SP2, or to create a second instance along side Sp1?

Unable to Install SQL Server 2008 R2 64 Bit on clean install of Server 2008 R2 64 Bit Error CLR20r3



I'm trying to install SQL Server 2008 R2 64  on a clean install of Server 2008 R2 64 Bit. Shortly after double clicking on the setup I get a Windows error message saying the installer has stopped working with the details below.

Suggestions welcomed.



Stopped working

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: setup100.exe

Problem Signature 02: 10.50.1600.1

Problem Signature 03: 4bb6742c

Problem Signature 04: Microsoft.SqlServer.Chainer.Setup

Problem Signature 05:

Problem Signature 06: 4bb6742c

Problem Signature 07: 4

Problem Signature 08: 5

Problem Signature 09: System.BadImageFormatException

OS Version: 6.1.7600.

Locale ID: 3081

Read our privacy statement online:


Unable to install SQL Server 2008 SP2 Via PCU Source



I have extracted SP2 to D:\SQL2K8\PCU but I'm unable to install SQL 2k8 SP2 via PCU SOurce and getting the following error "The required attribute 'Path' is missing." D:\SQL2k8\setup.exe /PCUSource=d:\SQL2K8\PCU

2010-10-28 08:36:03 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-10-28 08:36:03 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\100\Bootstrap
2010-10-28 08:36:03 Slp: Sco: Attempting to get registry value BootstrapDir
2010-10-28 08:36:03 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'
2010-10-28 08:36:03 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'
2010-10-28 08:36:03 Slp: Error: Action "InitializeMsiExtension" threw an exception during execution.
2010-10-28 08:36:03 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The required attribute 'Path' is missing. ---> Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException: The required attribute 'Path' is missing. ---> System.Xml.Schema.XmlSchemaValidationException: The required attribute 'Path' is missing.
2010-10-28 08:36:03 Slp:    at System.Xml.Schema.XmlSchemaValidator.SendValidationEvent(XmlSchemaValidationException e, XmlSeverityType severit

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