.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

problems installing ssmse for SS 2008 R2 Express

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

I have successfully installed SS 2008 R2 Express.  I'm having trouble installing the management console for SQL Server 2008 R2 Express Edition.  I've done this with previous version of SS with no problems.  The documentation that I've found isn't very helpful.

I downloaded the SQLManagementStudio_x86_ENU.exe file from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b.  I ran this.   The app that ran doesn't look any different than the installer for SS 2008 R2 Express.   I then chose the option under installation for a new install or adding options to an existing installation.  I clicked this thinkg I needed to add the SSMS to my current installation.  I saw no option to install the SSMS though.  It seemed like it was just going to reinstall SS 2008 R2 Express.  I looked at all of the other options but didn't see a way to do this. 

Can someone please tell me what I need to do to install the management console?  I'm extremely dependent on this and need to get it installed to work with SS.  What am I missing?


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.

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  

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.

Problems installing SQL Server 2005 Integration Services for Server 2008 R2

I am trying to install Microsoft Forefont and i have got a tick on every requirement bar 1. I can't install SWL Server 2005 Integration Services Component. I am running windows Server 2008 R2. I have tried numerous steps such as going into to control panel and adding component but the Integration services is not appearing on the options. Is it actually possible to install 2005 integration services on server 2008 and if so how? Thanks

Windows 7, SQL Server 2008 Express & VWD 2008 Express Setup Problems

Hi I have Windows 7 Home Premium, and Visual Web Developer Express 2008 (which came with SP1) installed. SQL Server 2008 Express never worked - Windows 7 won't allow the Management Studio to be installed and VWD was asking for SQL Server 2005.  Looking on the web, I found advice to try the 32 bit version of SQL Server instead.  This would work with VWD, apparently.  I referred to these instructions (http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm) and used the latest links and instructions, but I could not install SQL Server at all - apparently something to do with WOW64... This has been going on for a WHILE and I'm going nuts.  I am reluctant to uninstall VWD and start again, because I had to manually fix a few things, and now it's working...  PLEASE can someone tell me of a working configuration, I have read SO MUCH advice on this, and none works, including those release notes (unless I missed something) :(

Installing 2008 express after VS2010 pro

I have just installed Visual Studio 2010 Professional on my laptop and it installed a basic version of SQL Server 2008 Express with no management tools. I would like to install the Full SQL Server 2008 Express on my laptop, but when I download and run SQLEXPRADV_x86_ENU.exe (advanced version with tools) or even just 2008SQLManagementStudio_x86_ENU.exe (management studio only), it extracts the files, runs a command prompt window for about 2 seconds and then closes and deletes the files it just extracted. I am installing on a laptop with Windows XP Pro SP3. Any help would be greatly appreciated. Thank you!j

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

Windows 7 x64, SQL Express 2008 - Problems attach Northwind database

I've attached Northwind many times before, but seem to be unable to do so in Windows 7. I tried attaching from Visual Studio, using osql, and finally (after many hours) installed SQL Express 2008 / SQL Management Express 2008. All methods failed. The last failure (using SME 2008 Attach Databases) is sometimes:

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\northwnd.mdf". Operating system error 2: "2(failed to retrieve text for this error. Reason: 15105)". (.Net SqlClient Data Provider)

and other times:

Database 'Northwind' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

I have, of course, verified countless times that the files are NOT read-only.

Could any please explain what could be happening here? All suggestions much appreciated.

many thanks,


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?

Installing SQL Server Express 2008 R2 over SQL Server Express 2008


We recently purchased a server that has SQL Server Express 2008 installed. I would like to install SSE 2008 R2. Do I need to uninstall SSE 2008 before installing R2?

There is currently no data in the database(s). I believe it's bascially a fresh install from the factory.

Follow up. I would like to rename the computer. I assume I would want to do this before installing SSE 2008 R2.

Windows Server Standard 2008 SP2
intel Core Duo i5 @ 333 Ghz
64 bit OS

Microsoft SQL Server Management Studio      10.0.2531.0
Microsoft Data Access Components (MDAC)      6.0.6002.18005
Microsoft MSXML      3.0 4.0 6.0
Microsoft Internet Explorer      8.0.6001.18975
Microsoft .NET Framework      2.0.50727.4206
Operating System      6.0.6002

Thank you very much.

Error 1935 When Installing SQL Server 2008 Express on Windows 7 64 bit

I need to install SQL Server 2008 Express on Windows 7 x64 but keep failing. I've searched and tried so many method listed on many forums to no avail. Please kindly help.

These are the error message that I was getting:

Error 1935. An error occurred during the installation of assembly
'Microsoft.VC90.ATL,version="9.0.21022.8",publicKey Token="1fc8b3b9a1e18e3b",processorArchitecture="x86", type="win32". Please refer to Help and Suppoer for more information. HRESULT: 0x8007054F.


An error occurred during the installation of assembly
'Microsoft.VC80.CRT,version="8.0.50727.1801",publicKey Token="1fc8b3b9a1e18e3b",processorArchitecture="amd64", type="win32". Please refer to Help and Suppoer for more information.

Additional information:
- OS: Microsoft Windows 7 Professional Edition 64bit
- I have no other SQL instances present on every install (I always uninstall it first and clean up the residue files on C:\Program files (and the x86 one)\Microsoft SQL Server\)
- I have Visual Studio Express 2010 installed
- I fundamentally require only SQL Server service and SQL Server Management Studio, but I've tried all installer on the Microsoft website just in case one is working.

This are the files that I'

Installing SQL Server Express 2008 as pre-requisite fails


A customer of mine runs Windows XP SP3 and is trying to install my software which has SQL Express 2008 as a pre-requisite but the install fails every time. The error message is:

"An error occured attempting to install SQl Server 2008 Express Edition"

The setup log file contains:

The following properties have been set:

Property: [AdminUser] = true {boolean}

Property: [ProcessorArchitecture] = Intel {string}

Property: [VersionNT] = 5.1.3 {version}

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

question about installing sql server 2008 express with another server...



I am doing a self-study of databases and right now i'm playing with mssql server 2008 express edition.

One of my buddies asked me, if i'm going to install two mssql version. let us say i have mssql server 2005 already installed. If i install 2008, will it affect everything that was done in mssql 2005? also, if i uninstall one of it, will it affect each other? even in a small fraction of the settings?


P.S. sorry, i haven't tried and test it myself because i'm still looking for an older mssql server express edition and the question we have right now is only based on our curiosity. Advance thanks to anyone who can share their knowledge and experience in this matter.

Installing SqlServer 2008 Express as prerequisite


When I installed the Sql Server 2008 Express on Windows 7 as a prerequisite to my application, I got this error

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = AMD64 {string}
Property: [VersionNT] = 6.0.0 {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 '.NET Framework 3.5 SP1', phase BuildList
Reading value 'SP' of registry key 'HKLM\Software\Microsoft\NET Framework Setup\NDP\v3.5'
Read integer value 1
Setting value '1 {int}' for property 'DotNet35SP'
The following properties have been set for package '.NET Framework 3.5 SP1':
Property: [DotNet35SP] = 1 {int}
Running checks for command 'DotNetFX35SP1\dotNetFx35setup.exe'
Result of running operator 'ValueGreaterThanEqualTo' on property 'DotNet35SP' and valu

Installing SQL Server Express 2008: Powershell failed


During the install of SQL Server Express 2008 I get an error "Powershell failed". I tried to find a Powershell download but only found a "Powershell snap in" and that won't install on XP Home SP3. I get a message it should be installed using "Programs and Services" or "Servers". I can't find these on XP Home (perhaps using a dutch windows version doesn't help). I just want to install SQL Express and I dont need Powershell.

I tried the Windows Weblauncher but this doesnt work on XP Home.

I have succesfully installed and used SQL server on XP Home, but after a crash and a new installation of Windows with all updates, including SP3, I can't get it working anymore,

How can I (1) install SQL Server Express 2008 without this Powershell error by skipping the powershell check or (2) how can I install PowerShell first on my XP Home computer to run a succesful installation afterwards.

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