none
Trouble installing SQL Server 2008 R2 Management Studio Express

    Question

  • I have having trouble installing SQL Server 2008 R2 Management Studio Express which I just uninstalled SQL Server 2008 R2 Express and I am not sure what it left behind from the uninstall of the standard version that makes installing express version a hassle. I need the express version of SQL Server 2008 R2 express because 2010 Visual Web Developer only accepts the express version and not the standard version. I tried to install SQL Server 2008 R2 Management Studio Express from the link:

    http://www.microsoft.com/download/en/details.aspx?id=22985&hash=0HvnxWfgTcQiZ7FnfV3dus4cCnEfoRSEwkIXpWOY4eu7kWb2Xm6p9E4VVRaPEiuCwEw8IMuTjtlP8THAorzYDA%3d%3d#instructions

    I have Windows 7 64-bit on my machine and downloaded the File Name:

    SQLManagementStudio_x64_ENU.exe

    I have been able to get to the Feature Selection step which has all the included features selected and clicked next and got the error message
    "To continue, select a feature to install. If all features are already installed. You cannot add additional features." This is a screen shot of my programs menu and Setup in the image attached:


    I also have a image of the programs associated with SQL Server


    I have backed up my databases from the directory

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL\Data

    to a separate folder in my documents

    I am not sure where to start with what components I have to uninstall or install, change keys in the registry or where to proceed with Installing SQL Server 2008 R2 Express and SQL Server 2008 R2 Management Studio Express?

    Wednesday, April 11, 2012 3:05 PM

Answers

All replies

  • Hello,

    Please follow the procedure explained on the article step-by-setp.

    http://www.asql.biz/Articoli/SQLX08/Art3_1.aspx


    Choose “New SQL Server Standalone Installation …”

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, April 11, 2012 3:12 PM
    Moderator
  • Ok, I followed similar instructions from the last post using the link.  I tried a previous install that bypasses the Installation rules using the command in command prompt

    SQLManagementStudio_x64_ENU  /ACTION=install /SkipRules=VSShellInstalledRule

    which I downloaded from:   http://www.microsoft.com/download/en/details.aspx?id=22985

    The install works but the setup won't register a new instance which running a discovery report, the Management Tools - Basic that I have tried using an instance of SQLEXPRESS that I believe isn't accepted in 2010 Visual Web Developer Express.

    http://s1257.photobucket.com/albums/ii504/kingjames03220/?action=view&current=sqlserverdiscoveryreportwithoutmanagementstudioinstance.png

    I believe the SQLEXPRESS instance name was used in SQL Server 2005 Express and in the installer you have to create a new instance to add management tools - basic into SQL Server 2008 R2 Express.

    So I uninstalled Management Tools - Basic and tried to reinstall using the SQL Server 2008 R2 Setup, everything goes fine until I reach the Installation Rules step which I checked the status and gives me the error: Rule "Previous releases of Microsoft Visual Studio 2008" Failed.

    http://s1257.photobucket.com/albums/ii504/kingjames03220/?action=view&current=sqlserverinstallationrules2.png

    In the registry, the necessary keys are 1's in the 10.0 and 9.0 folders

    http://s1257.photobucket.com/albums/ii504/kingjames03220/?action=view&current=registryeditor2.png

    http://s1257.photobucket.com/albums/ii504/kingjames03220/?action=view&current=registryeditor.png

    I sucessfully installed Visual Studio 2008 SP1  and the Installation Rules doesn't recognize that. 

    http://s1257.photobucket.com/albums/ii504/kingjames03220/?action=view&current=sqlserversp1.png

    I need to be able to register a new instance name to install SQL Server 2008 R2 RTM Express Tools (Management Studio Express) in the installer.  If you successfully install the new SQL Management Studio in SQL Server 2008 R2 Express, In my previous install, I noticed on my computer in Programs; SQL Server 2005 Express has SQL Server 2005 Management Studio Express and SQL Server Management Studio in SQL Server 2008 R2 Express, the management studio express in SQL Server 2005 Express doesn't work but in SQL Server 2008 R2 Express in SQL Server 2008 R2 Express the SQL Server Management Studio works, is this normal?

    http://s1257.photobucket.com/albums/ii504/kingjames03220/?action=view&current=programs.jpg

    Any suggestions to get through this situation with the installer?

     

     

     

     

     

     

     

     

    Monday, April 16, 2012 8:03 PM
  • SO the issue is in installing SQL 2008 express, or able to connect to it from visual studio ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Monday, April 16, 2012 8:14 PM
    Moderator
  • The issue is getting the SQL Server 2008 R2 Management Tools - Basic (Management Studio Express for Microsoft SQL Server 2008 R2) to install.

    Monday, April 16, 2012 9:25 PM
  •  Management Tools  is shared feature it is not dependent on instance name, you should be able to use the installed one to connect to 2005/2008 R2 instances.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Monday, April 16, 2012 9:41 PM
    Moderator
  • In the installer, I can't get past the Installation Rules Step of the Installer that gives me the error:  Rule "Previous releases of Microsoft Visual Studio 2008" Failed.

    I have installed the Visual Studio 2008 SP1 Upgrade that worked successfully. I re-run'ed that step and get the same error.  From four posts ago it shows my registry and what I have done, which I believe the problem may lie in the registry, which I have uninstalled SQL Server 2008 R2 standard previously.

    Monday, April 16, 2012 10:00 PM
  • What was the result when you run setup with  /SkipRules=VSShellInstalledRule ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Monday, April 16, 2012 11:30 PM
    Moderator
  • It bypasses the Instance Configuration that doesn't allow to include a new instance name.  I just launched the installer through the command prompt and now I get this error before loading the installer

    Tuesday, April 17, 2012 1:00 AM
  • can you share the command line you are using, if you are interested in getting the tools you don't need to specify instance name, management tools is shared feature not instance feature.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, April 17, 2012 1:05 AM
    Moderator
  • The command line I am using is:

    C:\Users\My Name\Downloads> SQLManagementStudio_x64_ENU /ACTION=install /SkipRules=VSShellInstalledRule

    Tuesday, April 17, 2012 1:09 AM
  • Can you do the following

    C:\Users\My Name\Downloads\SQLManagementStudio_x64_ENU.exe /x

    this will uncompress the media say for example c:\SQLSERVERR2SP1

    then from there run

    c:\SQLSERVERR2SP1\setup.exe /ACTION=install /SkipRules=VSShellInstalledRule


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, April 17, 2012 1:13 AM
    Moderator
  • The first command:

    C:\Users\My Name\Downloads\SQLManagementStudio_x64_ENU.exe /x

    The extraction worked, but the second command:

    c:\SQLSERVERR2SP1\setup.exe /ACTION=install /SkipRules=VSShellInstalledRule

    The system cannot find the path specified.  Due to SQLSERVERR2SP1 doesn't exist in my directory, but there is a setup.exe file located on my computer at:

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\setup.exe

    Tuesday, April 17, 2012 1:25 AM
  • Setup.exe should run from the place where you extracted the package, so change the prompt to the location where the package is extracted then run the setup command

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, April 17, 2012 2:06 AM
    Moderator
  • I tried the command cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release

    then at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release> setup

    The installer launched I clicked New SQL Server stand-alone installation or add features to an existing installation in Installation from the left menu and now I get the prompt where it asks for Browse for Folder which doesn't have the directory defined in Options on the left menu so I put in the directory the same one with in the command prompt and I get the message "'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release is not a valid installation folder.  I put in where the setup.exe file is and the installer doesn't recognize the file. I don't know how to direct that to the proper file.

    Tuesday, April 17, 2012 2:42 AM
  • Hello,

    let me be more detailed

    1-Uncompress the media to c:\foo

    2- open command prompt as in elvated mode(run as admin) do cd c:\foo

    when the prompt is at c:\foo type the setup.exe command line


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, April 17, 2012 2:48 AM
    Moderator
  • I don't know what foo is.  I would thing foo would be anything in particular like Program Files I think.  I opened the administrator command prompt in All Programs\accessories then right clicked command prompt and selected run as administrator did a change of directory (cd) cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release and typed the command setup and still got the same results as two posts ago.  What is foo?
    Tuesday, April 17, 2012 3:50 AM
  • foo is the directory where you un compressed the package.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, April 17, 2012 4:05 AM
    Moderator
  • The only two directories where I can Install setup files of Microsoft SQL Server 2008 R2 RTM Express Management Studio is:

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\setup.exe

    and

    C:\Users\My Name\Downloads\SQLManagementStudio_x64_ENU.exe

    There has to be an issue in my registry settings, which Visual Studio 2008 SP1 is installed

    Other that I am completely stumped on this issue.

    Tuesday, April 17, 2012 4:31 AM
  • Alberto,

    I have a similar problem, but I am not even uninstalling an old version of SQL.

    1) I installed MS SQL 2008 R2 Express from "SQLEXPR_x86_ENU.exe" downloaded from MS website.

    2) I realised that I forgot to install the version with Management Studio.

    3) I downloaded and ran "SQLManagementStudio_x86_ENU.exe". But, just like in the image from the original poster above, this EXE doesn't install Management Studio, it only runs through the SQL Server setup, and doesn't even have the Management Studio as an option to add to my existing instance.

    4) Next I dowloaded the installer for SQL Server 2008 with tools "SQLEXPRWT_x86_ENU.exe", intending to run it, select add features to exisitng instance, and add the Management Studio. I tried this, but, I get exactly the same options as above - no option to install Management Studio.

    What can I possibly be doing wrong?

     

    Friday, April 20, 2012 4:03 PM
  • I'm running into the same problem.

    I simply forgot to install the Management Studio on installation.

    Saturday, April 21, 2012 12:29 AM
  • Can you send discovery report for installed SQL server components on you box, you can do this by running

    setup.exe /Action=RunDiscovery

    http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Saturday, April 21, 2012 12:40 AM
    Moderator
  • I completely reinstalled the SQL to no avail; I'm having the same dilemma as Kingcandlepin in the first message. The box is grayed out, and not check or uncheckable.

    2012-04-21 11:56:01.42 Server      Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
        Mar 29 2009 10:27:29
        Copyright (c) 1988-2008 Microsoft Corporation
        Express Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)

    2012-04-21 11:56:01.49 Server      (c) 2005 Microsoft Corporation.
    2012-04-21 11:56:01.49 Server      All rights reserved.
    2012-04-21 11:56:01.49 Server      Server process ID is 3300.
    2012-04-21 11:56:01.49 Server      System Manufacturer: 'Dell Inc.', System Model: 'Inspiron N4010'.
    2012-04-21 11:56:01.49 Server      Authentication mode is WINDOWS-ONLY.
    2012-04-21 11:56:01.49 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
    2012-04-21 11:56:01.56 Server      This instance of SQL Server last reported using a process ID of 6004 at 4/21/2012 11:55:55 AM (local) 4/21/2012 3:55:55 PM (UTC). This is an informational message only; no user action is required.
    2012-04-21 11:56:01.56 Server      Registry startup parameters:
         -d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf
         -e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
         -l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
    2012-04-21 11:56:01.58 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2012-04-21 11:56:01.58 Server      Detected 4 CPUs. This is an informational message; no user action is required.
    2012-04-21 11:56:02.07 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2012-04-21 11:56:02.68 Server      Node configuration: node 0: CPU mask: 0x0000000f Active CPU mask: 0x0000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2012-04-21 11:56:02.90 spid6s      Starting up database 'master'.
    2012-04-21 11:56:03.22 spid6s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2012-04-21 11:56:03.64 spid6s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
    2012-04-21 11:56:03.84 spid6s      SQL Trace ID 1 was started by login "sa".
    2012-04-21 11:56:03.84 spid6s      Starting up database 'mssqlsystemresource'.
    2012-04-21 11:56:03.94 spid6s      The resource database build version is 10.00.2531. This is an informational message only. No user action is required.
    2012-04-21 11:56:04.45 spid10s     Starting up database 'model'.
    2012-04-21 11:56:04.45 spid6s      Server name is 'SHADEZ-PC\SQLEXPRESS'. This is an informational message only. No user action is required.
    2012-04-21 11:56:04.57 spid6s      Informational: No full-text supported languages found.
    2012-04-21 11:56:04.57 spid6s      Starting up database 'msdb'.
    2012-04-21 11:56:05.02 spid10s     Clearing tempdb database.
    2012-04-21 11:56:05.40 Server      A self-generated certificate was successfully loaded for encryption.
    2012-04-21 11:56:05.51 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
    2012-04-21 11:56:05.51 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
    2012-04-21 11:56:05.55 Server      Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
    2012-04-21 11:56:05.59 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
    2012-04-21 11:56:05.59 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2012-04-21 11:56:07.03 spid10s     Starting up database 'tempdb'.
    2012-04-21 11:56:08.13 spid13s     The Service Broker protocol transport is disabled or not configured.
    2012-04-21 11:56:08.13 spid13s     The Database Mirroring protocol transport is disabled or not configured.
    2012-04-21 11:56:08.56 spid13s     Service Broker manager has started.
    2012-04-21 11:56:08.56 spid6s      Recovery is complete. This is an informational message only. No user action is required.

    Saturday, April 21, 2012 4:06 PM
  • Did you try to install new instance or add feature to existing instances ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Saturday, April 21, 2012 7:36 PM
    Moderator
  • I've tried both way. Installing 'new' doesn't give me the option to specifically install Management Studio.
    Sunday, April 22, 2012 5:06 PM
  • Can you share the screen shot for  feature tree when installing new.

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Sunday, April 22, 2012 8:29 PM
    Moderator
  • It was the same as Kingcandlepin's image on the very first message.
    Monday, April 23, 2012 10:19 PM
  • Are you trying to install SQLManagementStudio_x86_ENU or SQLManagementStudio_x64_ENU ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Monday, April 23, 2012 10:26 PM
    Moderator
  • I'm trying to install SQLManagementStudio_x86_ENU.

    Wednesday, April 25, 2012 5:35 PM
  • dont upgrade an existing installation, select new installation

    just kick off installer and keep ALL default options, you'll then see it as an option

    Wednesday, May 02, 2012 10:25 AM
  • hello Rangoo5000

    please read this thread

    SQL Server 2008 R2 intsall blocked because it says detected Visual 2008 that needs sp1

    or

    SQL Server 2008 R2 Management Studio install fails telling me to install Visual Studio 2008 SP1!

    BTW - why not use the search function of the SQL Forum with the following key words sql server 2008 r2 visual studio 2008 sp1

    and you'll find many postings for this issues and hopefully a solution to your issue.


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Wednesday, May 02, 2012 11:20 AM