Tuesday, April 17, 2012 11:42 PM
I have recently upgraded my local server to SQL server 2012 from SQL Server 2008
since then I have noticed an issue constantly, whenever i connect to my sql server 2008 database on a hosted server, i can connect normally,
I can run all my queries normally but whenever i try to expand the databases list in the object explorer, my sql server 2012 management studio kind of dies for few minutes and then it returns back but do not show any databases in my databases list.
when i use my machine having sql server 2008 and connect to the same hosted sql database, everything just runs normal, i can expand the databases in the object explorer and perform all the operations there.
any feedback is highly appreciated.
- Moved by Microsoft JDBC Driver Product Team Friday, April 20, 2012 5:47 PM SSMS related (From:SQL Server Data Access)
Wednesday, April 18, 2012 12:26 AM
Try applying CU1 for SQL 2012
if that won't fix the problem then report this issue at
Wednesday, April 18, 2012 1:21 AMi dont see this issue in the list of fixed issues with the CU1, did you encounter this issue also that was fixed by CU1?
Thursday, April 19, 2012 12:02 AM
I applied the CU1 but no luck.. i guess i will post it on connect site
Tuesday, May 01, 2012 6:37 PM
do you've configured linked servers on your SQL 2008 server ?
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Monday, June 04, 2012 9:47 PM
no, i dont have it setup as linked server, i am just trying to use management console that got installed with sql server 2012 to connect to sql server 2008 R2
Vishal Narayan Saxena http://twitter.com/vishalsaxena
Wednesday, September 12, 2012 12:59 PM
I have the EXACT same issue.
I installed SQL Server 2012 on my local laptop, and now when I use 2012's SSMS to connect to my hosted 2008 database, I can connect to the database if I specify it in the Connection options, but I cannot list the Databases on the server. It just hangs. So, I can't list tables or anything.
I'm also getting a DCOM error 10009 in the Event Log. I have turned on all the protocols for both SQL Server 2012 and my Visual Studio installed version of SQL Server 2008 Express, but no luck. I'm trying to connect to an Arvixe hosted DB and I hear they use SQL 2008 Express.
- Edited by BigAlPliskin Wednesday, September 12, 2012 1:28 PM more info
Wednesday, September 19, 2012 6:51 PM
I've got the same problem here, including the DCOM error 10009 in the Event Log. We were able to work around it by opening up port 135 on the firewall, but that's not reasonable for servers outside of our local network.
Did you create an issue on Connect? If so, can you post a link?
Wednesday, September 19, 2012 8:32 PMOn further investigation, we've discovered this can be fixed by deleting the profile data for this application. See my answer at http://stackoverflow.com/questions/10970989/sql-server-management-studio-2012-hangs for full details.
Wednesday, November 28, 2012 5:39 PM
This is a workaround. I am having the same issue trying to connect to a server on arvixe.com. The server has many databases. In my connection settings, I bumped up the connection timeout from 15 secs to 255 seconds. I also have a default database set, but that does not help.
Anyway, it still takes a long time for the Databases node to expand, but at least it finally does in the end. I usually connect to the server, click expand on Databases and go get coffee. When I get back, I have a full listing.
I know this is not technically a "fix", but it's working for me, after trying everything else.
- Proposed As Answer by Ed Price - MSFTMicrosoft Employee, Owner Sunday, December 30, 2012 9:10 AM