Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: Management studio will not start

    Wondering if anyone can help me.

    We are testing for DR and our Server guys recovered our SQL Server 2005 Standard Edition instance from a full backup.

    All of the SQL Server services start but the Management Studio will not start.

    I am getting the following:

    Problem event name: APPCRASH
    Application Name: Sqlwb.exe
    Application Version: 2005.90.4226.0
    Faulting module: mscorwrks.dll

    I tried running SQLRun_Tools.msi from the install media to re-install client tools only with no luck

    Does anyone have any other ideas?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Have you checked your computer Services to see what account it is running under?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    Sorry. not sure if I'm understanding you. my sql server services are running under a domain service account - I am trying to launch management studio (sqlwb.exe) I don't see sqlwb.exe in the services tab put I do see it in the processes tab when I try and launch it (before it crashes) I've tried launching management studio by right-clicking and using the 'run as administrator' option.. but it still crashes.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    My bad. I thought you meant SQL Server itself, not Management Studio.
    Management Studio is an independent program.
    Try uninstalling it and reinstalling it from disk.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Dec 2007
    Posts
    288
    Thanks : ) uninstalling and reinstalling also results in the same APPCRASH. We just doing DR testing. Server Guys recover the server then we recover Databases.. but I can't get MGT Studio to fly..

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If reinstalling did not work, then the problem is likely not in Management Studio. It has something to do with a difference in your environment post-disaster recovery.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Dec 2007
    Posts
    288
    I'm tired of beating this horse : ) I will have my Server guys change HOW they are doing the backup and start again.. too frustrating for a friday afternoon! Thank you for your help

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    My rule of thumb is: Never make any changes on Friday unless you don't mind coming in to work on Saturday.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •