Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

management studio Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 1:30 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 3:06 PM
Points: 319, Visits: 757
Hi Friends,

We installed sql server 2012 on a windows 2012 server last week. We are unable to connect to the 2012 database from SQL 2008/2005 Management studio's. Is there a way to make the 2005/2008 SSMS connect to 2012 db's or is it not forward compatible? Thanks a lot again
Post #1472322
Posted Wednesday, July 10, 2013 1:33 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 13,110, Visits: 11,940
Nope won't work going forward. You can go the other way (connect to an older instance from a newer one). This is much like backups, they are not forward compatible.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1472323
Posted Friday, July 12, 2013 9:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:31 AM
Points: 194, Visits: 717
As far as I've seen you can connect from a Management Studio 2008 to a SQL 2012 instance.
The object explorer might throw some errors when expanding the different trees but connecting and executing queries should be possible.
Post #1473112
Posted Friday, July 12, 2013 10:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 13,110, Visits: 11,940
WolfgangE (7/12/2013)
As far as I've seen you can connect from a Management Studio 2008 to a SQL 2012 instance.
The object explorer might throw some errors when expanding the different trees but connecting and executing queries should be possible.


Wow that would the first time that an older version of SSMS can connect to a newer version. Interesting.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1473128
Posted Sunday, July 14, 2013 3:23 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:28 PM
Points: 786, Visits: 691
Sean Lange (7/12/2013)
[quote]Wow that would the first time that an older version of SSMS can connect to a newer version. Interesting.


No, SSMS 2005 SP3 can connect to SQL 2008 as well. And good ol' Query Analyzer can connect to all versions.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1473396
Posted Sunday, July 14, 2013 3:24 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:28 PM
Points: 786, Visits: 691
newbieuser (7/10/2013)
We installed sql server 2012 on a windows 2012 server last week. We are unable to connect to the 2012 database from SQL 2008/2005 Management studio's. Is there a way to make the 2005/2008 SSMS connect to 2012 db's or is it not forward compatible?


As Wolfgang says, this is perfectly possible. Most likely this is a connectivity problem. What error message do you get?


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1473397
Posted Sunday, July 14, 2013 3:25 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 11:39 AM
Points: 3,358, Visits: 7,262
Sean Lange (7/12/2013)
WolfgangE (7/12/2013)
As far as I've seen you can connect from a Management Studio 2008 to a SQL 2012 instance.
The object explorer might throw some errors when expanding the different trees but connecting and executing queries should be possible.


Wow that would the first time that an older version of SSMS can connect to a newer version. Interesting.


Does it has something to do with the compatibility level set?



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1473398
Posted Monday, July 15, 2013 7:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 13,110, Visits: 11,940
Erland Sommarskog (7/14/2013)
Sean Lange (7/12/2013)
[quote]Wow that would the first time that an older version of SSMS can connect to a newer version. Interesting.


No, SSMS 2005 SP3 can connect to SQL 2008 as well. And good ol' Query Analyzer can connect to all versions.


Thanks for the clarification Erland. Makes sense really, it is still just a connection.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1473639
Posted Monday, July 15, 2013 7:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 3:06 PM
Points: 319, Visits: 757
I'm still not able to connect from SSMS 2008 to 2012 database. Not sure where/what to check?

Please help..thanks a lot
Post #1473649
Posted Monday, July 15, 2013 7:59 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:43 AM
Points: 709, Visits: 1,411
What error gets thrown back when you try?

Joie Andrew
"Since 1982"
Post #1473661
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse