17. dubna 2012 23:42
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.
- Přesunutý Microsoft JDBC Driver Product Team 20. dubna 2012 17:47 SSMS related (From:SQL Server Data Access)
18. dubna 2012 0:26
Try applying CU1 for SQL 2012
if that won't fix the problem then report this issue at
18. dubna 2012 1:21i dont see this issue in the list of fixed issues with the CU1, did you encounter this issue also that was fixed by CU1?
19. dubna 2012 0:02
I applied the CU1 but no luck.. i guess i will post it on connect site
1. května 2012 18:37
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.
4. června 2012 21:47
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
12. září 2012 12:59
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.
- Upravený BigAlPliskin 12. září 2012 13:28 more info
19. září 2012 18:51
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?
19. září 2012 20:32On 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.
28. listopadu 2012 17:39
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.
- Navržen jako odpověď Ed Price - MSFTMicrosoft Employee, Owner 30. prosince 2012 9:10