none
Adding Management Studio to Sql Server Express SP1 on Windows 7 Pro

    Question

  • Sql Server 2008 Express prior to SP1 does not install on Windows 7 Pro.  So I install Sql Server Express SP 1. 

    However there is no Sql Server Express SP 1 version that includes Management Studio Express.  So I try to add SQLEXPRADV_x64_ENU which predates SP1 and I get a warning.

    How do I install Management Studio safely because I have had more than one disaster in installing things out of order with Microsoft before.  Thanks for the help.

    Thursday, April 08, 2010 3:40 AM

Answers

  • Have you tried installing the SP1 express engine, then installing the management studio tools.

     


    http://www.virtualrealm.com.au - XNA Game Programming News and Resources from Downunder.
    • Marked as answer by Jackobee Sunday, April 18, 2010 6:19 AM
    Thursday, April 08, 2010 6:55 AM
  • Hi,

    On the one hand I am thankful that Microsoft supports forums like this and others.  On the other hand, SSME is crucial for most MS based DB apps - yet it is so hard to properly install both SQL Server Express SP1 and SSME on Windows 7. Wow, I hope someone on the SQL Server Team looks at this.  I found the following thread that was helpful: http://msdn.microsoft.com/en-us/library/ms365247.aspx.  For those who think I am getting too wound up on this problem scan the referenced thread.

    I pasted one post (below) from the thread that was particualarly helpful.  Note that I failed in earlier attempts because I did not do the step under Important Note included below - where I needed to select new install instead of update a previous install.

     

    How I finally successfully installed SSE 2008 SP1 and the Management Studio GUI

    Thanks to all the above posters, I have completed the task at hand. Here are step by step instructions for how I did it.

    Make sure the computer has plenty of free hard drive space
    Install .NET 3.5
    Install Windows Installer 4.5
    Install Windows PowerShell, available here:
    http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx
    Install SQL Server 2008 Express. I used the executable en_sql_server_2008_express_sp1_x86.exe, downloaded from
    http://www.microsoft.com/downLoads/details.aspx?familyid=01AF61E6-2F63-4291-BCAD-FD500F6027FF&displaylang=en.
    Note: Be aware that the installer interface is extremely complex and can be confusing. Just take your time with it.
    Note: I got a cryptic error during the installation, and to fix it I had to uncompress the C:\Program Files\Microsoft SQL Server directory.

    Install SQL Management Studio. I used the executable SQLManagementStudio_x86_ENU.exe, downloaded from
    http://www.microsoft.com/downloads/details.aspx?FamilyID=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en
    Important note: When the installer asks if this is a new install or an update of a previous install, specify a new install, even though this is not really true.
    When the installer presents the list of available features, select "Management Tools - Basic" and complete the installation

    Now I have a viable SSE 2008 SP1 install on a VM that I can replicate anytime I need to, so with any luck I never have to do this again.

    • Marked as answer by Jackobee Saturday, April 17, 2010 6:01 AM
    Saturday, April 17, 2010 6:01 AM

All replies

  • Have you tried installing the SP1 express engine, then installing the management studio tools.

     


    http://www.virtualrealm.com.au - XNA Game Programming News and Resources from Downunder.
    • Marked as answer by Jackobee Sunday, April 18, 2010 6:19 AM
    Thursday, April 08, 2010 6:55 AM
  • I have installed Sql Server Express SP1 for x64 on my 64-bit Windows 7 Pro.  I did not install Sql Server Express 2008 without SP1 and then add SP1.  My system (64-bit Windows 7 Pro) would not allow me to install the older pre-SP1 Sql Server Express - so there was no path for installing a Sql Server Express package that includes Management Studio Express.  I have had to install the only Sql Server Express SP 1 package I could find from zero.  This package does not include Management Studio Express.

    Now I am trying to add Management Studio Express and I get a severe warning.  Is there a path for installing Management Studio Express on a machine that already has Sql Server Express 2008 SP1 installed?  Has someone done it?

    Given the number of 64-bit Window 7 Pro machines sold, I cannot be the only one having this problem.  So I assume I am missing something.

    Thursday, April 08, 2010 2:23 PM
  • Did Glenn's link to the management studio tools (http://www.microsoft.com/downloads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en) not work for you?  What error are you getting?  If it's just the warning about compatibility you can safely ignore it.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, April 08, 2010 4:10 PM
  • I tried what Glenn suggested by running the Management Studio Install.  I went to the standard Sql Server Install wizard.  From there I made a selection to add features to the instance installed previously with Sql Server Express SP1.  After a few pages the wizard opened a page asking me to make a selection to install.  The page had no selectable items and the Wizards validation mockingly informed me that I needed to make a selection.

    Different Attempt:

    If I install Sql Server Express with Tools and then add SP1, I got an error that "Registry Values are not valid under this context" while unsuccessfully attempting to install SP1.  Ignoring the "invalid registry values" and "SQL Server 2008 Installation completed with failure", I rebooted and attempted to enter Sql Server Express Management Studio but was unable to login under Windows Authentication and no password.  I have used Management Studio before on other machines.

    If anyone is able to install Sql Server 2008 Express Management Studio on Windows 7 Profession please post.

    Thursday, April 08, 2010 10:07 PM
  • Hi,

    Thank you for posting here!

    >>If I install Sql Server Express with Tools and then add SP1, I got an error that "Registry Values are not valid under this context" while unsuccessfully attempting to install SP1

    This problem may happen if an instance with SQLEXPRESS instance name already existed in your server and you also user SQLEXPRESS as instance name when installing new instance of SQL Server Express Edition. So as to install SQL Server 2008 Express, Management Studio and Service Pack 1, I would suggest uninstalling all installed instances and try to install again. Below steps for your references:

    1.        Uninstall all instances of SQL Server 2008 Express (with Advanced Services/with Tools). For more information about how to uninstall SQL Server 2008 Express, please see SQL Express is not installed properly. Steps to be taken before reinstall again.

    2.        Install SQL Server 2008 Express with Tools (including Management Studio), if you want to apply SQL Server 2008 Express Edition Service Pack 1, you can install it later.

    If you need more help, please feel free to let me know.

    Thanks,
    Chunsong


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Monday, April 12, 2010 2:17 AM
    Moderator
  • Hi,

    On the one hand I am thankful that Microsoft supports forums like this and others.  On the other hand, SSME is crucial for most MS based DB apps - yet it is so hard to properly install both SQL Server Express SP1 and SSME on Windows 7. Wow, I hope someone on the SQL Server Team looks at this.  I found the following thread that was helpful: http://msdn.microsoft.com/en-us/library/ms365247.aspx.  For those who think I am getting too wound up on this problem scan the referenced thread.

    I pasted one post (below) from the thread that was particualarly helpful.  Note that I failed in earlier attempts because I did not do the step under Important Note included below - where I needed to select new install instead of update a previous install.

     

    How I finally successfully installed SSE 2008 SP1 and the Management Studio GUI

    Thanks to all the above posters, I have completed the task at hand. Here are step by step instructions for how I did it.

    Make sure the computer has plenty of free hard drive space
    Install .NET 3.5
    Install Windows Installer 4.5
    Install Windows PowerShell, available here:
    http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx
    Install SQL Server 2008 Express. I used the executable en_sql_server_2008_express_sp1_x86.exe, downloaded from
    http://www.microsoft.com/downLoads/details.aspx?familyid=01AF61E6-2F63-4291-BCAD-FD500F6027FF&displaylang=en.
    Note: Be aware that the installer interface is extremely complex and can be confusing. Just take your time with it.
    Note: I got a cryptic error during the installation, and to fix it I had to uncompress the C:\Program Files\Microsoft SQL Server directory.

    Install SQL Management Studio. I used the executable SQLManagementStudio_x86_ENU.exe, downloaded from
    http://www.microsoft.com/downloads/details.aspx?FamilyID=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en
    Important note: When the installer asks if this is a new install or an update of a previous install, specify a new install, even though this is not really true.
    When the installer presents the list of available features, select "Management Tools - Basic" and complete the installation

    Now I have a viable SSE 2008 SP1 install on a VM that I can replicate anytime I need to, so with any luck I never have to do this again.

    • Marked as answer by Jackobee Saturday, April 17, 2010 6:01 AM
    Saturday, April 17, 2010 6:01 AM