Mittwoch, 13. Februar 2013 16:08
After a few minutes of working with SSMS 10.50.1600.1 on the console of a cluster node, against a clustered instance, it freezes and returns the error message below.
I ruled out a couple of organic mistakes I might have made, and read, on line, that the likelist solution was to repair ,NET 3.51. And it worked, for a while: the the problem returned.
A reboot will reactivate the SSMS; but it eventually hangs.
A problem caused this program to stop interacting with Windows.
Problem Event Name: AppHangB1
Application Name: Ssms.exe
Application Version: 2009.100.1600.1
Application Timestamp: 4bb679e7
Hang Signature: 83f4
Hang Type: 256
OS Version: 6.0.6002.2.2.0.274.10
Locale ID: 1033
Additional Hang Signature 1: a9bd91c6f403a03867b55b9258208bb3
Additional Hang Signature 2: 655f
Additional Hang Signature 3: 1758037c539a8e30944d70e3c8fa8085
Additional Hang Signature 4: 83f4
Additional Hang Signature 5: a9bd91c6f403a03867b55b9258208bb3
Additional Hang Signature 6: 655f
Additional Hang Signature 7: 1758037c539a8e30944d70e3c8fa8085
Read our privacy statement:
Mittwoch, 13. Februar 2013 16:26Moderator
Now that you repaired .NET Framework. Would you consider to uninstall and reinstall the tools only?
Hope this helps
- Als Antwort markiert Allen Li - MSFTModerator Mittwoch, 20. Februar 2013 08:42
Donnerstag, 14. Februar 2013 03:50ModeratorHave you checked the event log ?
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.
Freitag, 15. Februar 2013 11:06
This could be the issue when there are more than 32 logical processors. Try to start SSMS through command prompt with affinity 1 and it should work fine
start /affinity 0x00000001 C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe
Applying the kb mentioned below should fix the issue:
Hope this helps
- Als Antwort markiert West Coast Blues Freitag, 1. März 2013 18:30
Freitag, 1. März 2013 18:34
Yes! I used KB2276255. This was a great response, Don. I did it the day before you made your response, otherwise, I'm sure I could have used it.
And, Alberto, I did try to deinstall the tools, but the check box to do so was gray, perhaps because the tools, not being clustered, were needed by all the other instances.