Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition

Hi,

I have downloaded Sql Express edition for Yukon. After that I installed the UI - Management Studio (SQLServer2005_SSMSEE). I checked and I was able to open and work using the Management studio.

Afterwards I installed some "SQL Server 2005 Express Edition Documentation and Samples" from the following link ...
http://www.microsoft.com/downloads/details.aspx FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en#filelist

Now after installing this, I am not able to access the Management Studio. I tried to uninstall and resinstall it , but it was of no help. Now when I click on the link of "Management Studio", it just do nothing.

How could I open the "Management Studio" like before and start working with it Please help me.


Regards,

Rajat Tandon.


Answer this question

Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition

  • Jerryman

    Thanks. I will check by installing the WS2003 with builtin SP1 (ofcourse if I get one :-)) I have one error left while trying to login into management studio using windows authentication. (Please refer the full error message in my previous post)

    Thanks again for keeping this thread active.



  • ChrisGoodyear

    Rebooted the computer, Same situation.
    Following is the list of all of the installed applications which might be using dotnet framework 2.0.

    Enterprise Library for .net Framework 2.0 (November 2005 CTP)
    Microsoft SQL Server 2005
    Microsoft SQL Server Native Client
    Microsoft Setup Support Files
    Microsoft Visual C# 2005 Express Edition
    Microsoft Sql Server Vss Writer

    Out of these I have worked a bit with Visual C# 2005 Express Edition
    and that seems to work fine. I dont' see any error in the Event Viewer. I was thinking of removing those help samples of sql server 2005 alongwith Adventureworks. Strange but do you think that it can help in some way in order to start the Management Studio

  • CULE_Developer

    Hi Rajat,

    I just walked through the same procedure but wasn't able to reproduce the problem you are experiencing.
     
    You should be able to repair the installation by opening the control panel, launching Add\Remove Programs, then clicking the Change button for Microsoft SQL Server Management Studio Express CTP. When the setup application starts up, click the Next button, then select the Repair option. That should get you back to a working state.

    jeff.

  • mnborja

    I see you are installing it on WS2003 with SP1 on top

    try reading my thread as I think I found an issue to this type of problem as well as other problems.

    Again - you may not need to go through the entire process which is in my thread but I believe that is one method of resolving the errors, there maybe other methods which I do not know of

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=134853&SiteID=1

    WS2003 with SP1 on top seems to break a few things in the OS itself unfortunatly... but having a WS2003 with SP1 on the CD complete seems to resolve these issues.

  • cockeyedbob

    I too had this issue and was only able to resolve it by uninstall of BOL. Interestingly I had ssmsee open at the time of install and it continued to run fine until I closed and tried to reopen. Repairs and reboots not withstanding the app refused to open its window if BOL was installed.
  • nevelshute

    Hi,

    I have same problem with Management studio.
    When i try to run it - nothing happened.
    But after uninstalling SqlServer2K5_BO it started to work OK.

    Any solution to install and get them to work them together

    The system is WXP SP2.

  • Damian B

    I did the some of the things like

    1. Uninstalled all of the sql server help files and sample files
    2. Uninstalled AdventureWorks DB
    3. Repairing various installs like Framework 2.0, Sql Server 2005 (Express edition) etc
    4. Uninstall and reinstall the "Management Studio"

    Wow, Finally I saw my Management Studion back BUT this time with a different problem.

    I am trying to connect using Windows Authentication. It was connecting earlier using the <servername>\SQLEXPRESS as Server name but now giving error as soon as I try to connect. The error is ...

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to <servername>\SQLEXPRESS.

    ------------------------------
    ADDITIONAL INFORMATION:

    The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)

    ------------------------------

    The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)

    ------------------------------

    The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)

    ------------------------------

    This operation is only supported on Windows 2000 SP3 or later operating systems. (mscorlib)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    I think that you people have better idea about this one. Waiting for reply.


  • tweduk

    If you haven't already done so, a reboot might be in order. I see that you've already tried uninstalling/reinstalling and that didn't fix it. Do you have any other applications that use the new .NET Framework And if so, do those work fine

    Are there any error messages in your Application Event log

  • TadAnderson

    Hi Geeks,

    I have to port my existing database on sql server 2005 and need to test on Sql Express with Management Studio. As I mentioned I am not able to login into the management studio using windows authentication.

    At least give me some steps in order to troubleshoot this situation.

    Regards,
    Rajat Tandon.

  • TScott

    To add into the previous post, the OS is - Windows Server 2003 SP1.
  • ??

    Hi,

    I see a lot of persons having the same issue. Anyway thanks Lakshmi for helping and pointing to a happening link. I will check with it.

    Thanks.

  • techoo

    Thanks Jeff.
    I have tried the repair option also but still I am unable to open Management Studio (ssmsee.exe). Can I try some other option here


  • oremo

    After several rounds of installations and uninstallations, I came to know that "Microsoft Sql Server 2005 Books Online" installation is stopping the Management Studio to be visible on the screen. Really Strange.

    But the problem to login into the management studio using windows authentication is still there. Please help. This is more important.

    Is there any way to use the "Books online" and "Management Studio" at the same time


  • captain paul

    hi

    hope this forum link will help..!
    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=127698&SiteID=1&PageID=0

    Solution:
    Deleting the following key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell

    regards
    Lakshmi Narayanan.R

  • Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition