SQL Server 2012 Management studio issue with 2008 databases

Question

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.

Answer 1

Try applying CU1 for SQL 2012

if that won't fix the problem then report this issue at

http://connect.microsoft.com/sqlserver

Answer 2

i dont see this issue in the list of fixed issues with the CU1, did you encounter this issue also that was fixed by CU1?

---

vishal

Answer 3

I applied the CU1 but no luck.. i guess i will post it on connect site

---

vishal

Answer 4

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.

Answer 5

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

Answer 6

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. 

Answer 7

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?

Answer 8

On 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.

Answer 9

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.