.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

Probem after installing SQL server 2008 R2 express edition

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

View Complete Post

More Related Resource Links

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.


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.

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  

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.

How to connect visual web developer 2008 express edition to SQL server 2008 ??

i know its a basic question guys! please help me . i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database ... How do i do it .....I can see some grt genius out there, i am sure some one is kind enough to help me with this question !!! thank you .....................................

Installation of sql server express edition-2008

Dear All, When i am installing sql server express edtion -2008  i choosed default instance to install bt at the window where we choose login account and password for reporting services and database engin it shows error ...........there i have got three account ..... i have tried all these three accounts but when i login through SSMS it doesnt allow and shows error  please suggest me which account i should select and password for that............   Thanks and Regards Shivesh

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

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

SQL Server 2008 r2 developer RTM edition not installing on windows 7 64 bit machine with latest serv


This machine had sql server 2008 installed.  I removed it since the upgrade would not work.   The machine currently doesn't have any sql installs.    The error fails during the Setup Support Files step.    Any help on this would be greatly appreciated.  I've included last part of file since you can only include 60k chars here.

2010-09-24 10:14:14 Slp: C:\sql2008r2\x64\FixSqlRegistryKey_x64.exe exit code: 0
2010-09-24 10:14:14 Slp: Launching external tool: C:\sql2008r2\x64\FixSqlRegistryKey_x86.exe
2010-09-24 10:14:14 Slp: ------------------------------------------------------------
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag2 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect -

Remove SQL Server 2008 R2 Express Edition from Windows 7 professional


Are there any good practices to follow in order to remove/uninstall SQL Server 2008 R2 Express Edition from Windows 7 professional laptop? Thanks for your comments.




SQL Server 2008 Express Edition: What is the difference between R2 and SP2?



  I received last week a notice about the expiration period of SQL Server 2008 R2.  I honestly got surprised considering that I installed the Express Edition.

  This week, I noticed an article announcing the coming out of SQL Server 2008 SP2.  This really caught my attention. 

A few questions:

1- Is R2 a release candidate version of SQL Server 2008 Express?

2- If so, how can I uninstall it from the moment SP2 is available for download.  Must I use the original setup program I used for install?

3- Actually I'm using SQL Server 2008 R2 Express Edition with Advanced Services.  What is the equivalent for the SP2 version.  Where can I find it for download?

Thanks for helping,


SQL 2008 SP1 - Log shipping solution with Logshipping monitor on SQL Server Express Edition SP1 (bad


Hello All !

I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS  as a monitor server:

'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance.  A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'

In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

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

Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.



Can anyone suggest what could be the reason of installation error- access is denied

while installing sql server 2008 sp2 express edition on my window 7 professional machine as a domain administrator.

I tried installing as a local administrator also but it gives the same errror.

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?
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