Post reply

Can you connect to Sql Server 2008 from Sql Server 2005 Management Studio?

  • March 30, 2009 at 11:56 am

    #384246

    I get an error saying I am unable to connect using my version of SSMS to sql server 2008. Do I have to upgrad my management tools to connect?

  • March 30, 2009 at 1:45 pm

    #968628

    Yes, you need to upgrade to SSMS 2008 to connect to SQL 2008

    SQL 2005 SSMS cannot connect to SQL 2008

    SQLServerNewbie MCITP: Database Administrator SQL Server 2005

  • March 30, 2009 at 2:35 pm

    #968682

    Jerry Hung (3/30/2009)

    Yes, you need to upgrade to SSMS 2008 to connect to SQL 2008

    SQL 2005 SSMS cannot connect to SQL 2008

    Not quite true - you can connect to SQL Server 2008 using the 2005 tools if you have upgrade to SP3. I think the was a CU before SP3 that would allow this - but not sure exactly which one.

    However, I would recommend installing the 2008 tools anyways as side-by-side (don't upgrade existing tools). That way, you can use the 2008 tools to do everything you need to against your 2008 instances and 2005 instances - and open the 2005 tools if you find you need something specific that the 2008 tools don't do (e.g. SSIS or SSRS).

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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