Post reply

I'm able to connect SQL Server 2008 instance from SSMS of SQL 2005!!

  • June 24, 2010 at 3:52 pm

    #222546

    Hi,

    Hi,

    We have SQL Server 2005 instances INS1 & INS2 and I have performed in-place upgrade to from SQL 2005 to 2008 for INS1. Now:

    INS1 --> SQL Sevrer 2008

    INS2-->SQL Server 2005

    According the MS upgrade guide SQL2008UpgradeTechnicalReferenceGuide.docx (see the page number 89),

    SQL Server 2005 tools cannot be used to manage SQL Server 2008 instances. For example, if you try to use Management Studio 2005 against SQL Server 2008, you will see the message similar to that shown in Figure 2-1.

    But for me, there is NO issue connecting SQL 2008 instance from SSMS of SQL 2005. Please see the attachment (Here, after connecting to the SQL 2008 instance, I clicked Help->about button on SSMS of SQL 2005 to show you that it is SQL 2005 SSMS )

    So here I'm NOT clear whether the documentation has wrong information?

    Could you please test this and share your experience?

    Thanks

  • June 24, 2010 at 4:26 pm

    #1184743

    There's a difference between "connecting" and "using" SS2K8 with SSMS 2K5.

    You can connect to the db. You can even use a query window and query SS2K8 tables as long as you're using SS2K5 syntax (e.g. no DATE datatype).

    But you cannot (or at least shouldn't be able to) use the SSMS tools (like a simple "Open Table").

    To summarize it: you can connect a SS2K8 db using SSMS 2K5 but you can't really use any of the SSMS features (other than within a query window).

    At least, that's what I've seen when dealing with SSMS2K5 and SS2K8.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 25, 2010 at 4:22 pm

    #1185292

    Thanks Lutz,

    I got your point and it's true that we can connect to SQL Server 2008 from SSMS of SQL 2005 but we cannot manage it.

    But the MS upgrade reference guide has the error screen shot while just connecting to SQL 2008 instance from SSMS of SQL 2005 and which is wrong and I believe that document need to be updated:-P:-P

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply