Post reply

ssms 2008 has stopped working all of Sudden

  • May 4, 2011 at 4:40 am

    #237652

    Hello ,

    my SSMS 2008, has suddenly stopped working. It was working perfactly until yesterday.

    I have tried :

    1. Repair

    2. Uninstalled -> Restarted PC -> and reinstalled full SQL server 2008.

    But no luck. Does anyone encountered this issue ?

    Let me elaborate what is happening , Cancle, Minimise , Maximise buttons remains inactive. even Key board buttons ( ALT-F) should open up menu. But it is not reponding even. But when i am movign mouse wheel.

    Attached window is opening up.

    Any help would be appriciated.

    Thanks a lot,
    Hary

  • May 4, 2011 at 4:58 am

    #1319638

    Hi,

    Did you make any changes in the server. Did you check the event viewer for any errors.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • May 4, 2011 at 6:28 am

    #1319690

    Thanks for the reply Chandra,

    As i have told you i can not check anything on the SSMS. i could not check server. But i learnt from my collegues that server is working fine.

    I have checked error log.But it is not much of help.

    Thanks a lot,
    Hary

  • May 4, 2011 at 6:47 am

    #1319697

    I have a similar issue here (SQL 2005, standard SP3 32 bit on windows 2003).

    Next time it happens open up task manager. Add the columns (view menu) so that you see the sames columns as in attachement.

    I personally sort by Mem usage desc.

    What happens is that sqlWb will start working its *** off (no idea on what). As you see in my screenshot, the process uses 60 mb at idle and goes up to 1 GB when working. For me it jumps by ± 5 MB / sec. So the route from 60 MB to 1000 MB takes some time.

    I never had it fixed (domain admin doesn't have time) but here's the supposed fix (most popular solution online AFAIK).

    http://www.dbforums.com/microsoft-sql-server/1616343-sqlwb-exe.html

  • May 6, 2011 at 2:15 am

    #1320837

    Hello All ,

    Thanks for your input.

    Actions i have taken.

    1. Re-installed complete sql server 2008. -- Issue didn't resolved.

    ( I carried out restart of pc , between uninstall and re-install.)

    But suddenly , SSMS started working . I am not sure why it behaved so. but issue resolved.

    Thanks a lot,
    Hary

  • May 6, 2011 at 5:09 am

    #1320910

    hbpank (5/6/2011)

    Hello All ,

    Thanks for your input.

    Actions i have taken.

    1. Re-installed complete sql server 2008. -- Issue didn't resolved.

    ( I carried out restart of pc , between uninstall and re-install.)

    But suddenly , SSMS started working . I am not sure why it behaved so. but issue resolved.

    Did you check the task manager for sqlwb? If not, reinstalling won't change a thing (assuming it was your problem).

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply