Post reply

Connecting to SQL Server 2008 via earlier versions of SSMS client

  • November 6, 2008 at 4:20 pm

    #200951

    It seems that you cannot conntect to SQL Server 2k8 to browse db objects or run query thry earlier version of SSMS like SQL 2005 or 2000. I was however able to connect to SQL Server 2K8 db engine thru SQL Server 2005 version 9.0.3282 but not the earlier version. Is there is any restriction on wht version you need to have in order to connect o SQL Server 2K8 db engine thru earlier version of SSMS.

    Thanks

  • November 6, 2008 at 4:37 pm

    #895268

    There shouldn't be restrictions, but there could be some things that don't work. My Query Analyzer connects, but because it makes some calls that aren't supported, the Object Browser doesn't work.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • November 6, 2008 at 4:40 pm

    #895272

    Any idea where can I find complete information or whitepaper on this.

    I need to instruct my users here as not everybody has SQL 2k8 yet.

    thanks

  • November 6, 2008 at 4:43 pm

    #895274

    I know my SSMS 2005 SP2 (9.0.3042) can't connect to SQL Server 2008 database

    It's good to know your 9.0.3282 (CU9) can

    SQL Server 2005 Build List[/url]

    SQLServerNewbie MCITP: Database Administrator SQL Server 2005

  • November 11, 2008 at 6:37 am

    #896906

    I installed SQL 2005 SP3 and it worked from 2005 to 2008 Management console

Viewing 5 posts - 1 through 4 (of 4 total)

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