Our Server environment: Windows 2008R2 hosts, each containing 3 instances of SQL 2005, each instance contains 300 to 500 databases.
Our DBA client environment: Windows 8 notebooks with SQL Server 2012 Developer Edition.
Issue: The DBA team launches SQL 2012 SSMS to access instances in non-trusted domains through the use of a shortcut containing the RUNAS /NETONLY /USER SSMS.exe syntax. Prior to upgrading to windows 8, our client OS was Windows 7 and the 2012 SSMS worked without issue.
When we connect to any of these instances from the SSMS with the object explorer details open, the SSMS will hang for up to 20 to 30 minutes. (Not Responding). If we launch the SSMS without the OED open and connect to an instance, it will open normally, BUT when we expand the databases directory the same "hang" occurs.
This issue can be reproduced on multiple computers.
TL;DR: After upgrading to windows 8, the SSMS databases list hangs for up to 30 minutes where the same configuration on windows 7 worked seamlessly.
Thanks for any assist that you can provide.
Please upgrade to SQL 2012 SP1 http://www.microsoft.com/en-us/download/details.aspx?id=35575
Let us know if you still see this issue
Sethu Srinivasan [MSFT]
Unfortunately upgrading to SP1 and restarting the notebook had no effect on the behavior.
it still displays the symptoms in my original post. hangs when trying to display object explorer details.
I continue to welcome any and all ideas, and i think that i will also post this to Microsoft Connect as well.