Post reply

Using SSMS 2005 to connect to 2008 database

  • May 10, 2010 at 5:59 am

    #386892

    Hi,

    One of my users is having an issue connecting from SSMS 2005 to a SQL 2008 Instance - im a bit confused as i can connect fine via 2005 SSMS.

    He gets a message with the error:

    'This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 200 and SQL Server 2005 servers."

    Im pretty sure it will be to do with add-ons, he probably has an earlier version of the client tools - how can i find this out for sure..

    any help appreciated.

    Ta

    My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access[/url]

  • May 10, 2010 at 6:55 am

    #1164943

    Help..About on both SSMS instances will give you versions.

  • May 10, 2010 at 7:22 am

    #1164963

    Thanks.. i must be going blind. thought i checked Help tab and couldnt find the 'About' section.

    His version is base 2005 - 9.00.1399 so i think the client tools need to be upgraded 🙂

    My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access[/url]

  • May 10, 2010 at 7:37 am

    #1164975

    You need to apply a service pack. I can't recall which one, but applying SP3 is safe enough.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 10, 2010 at 7:39 am

    #1164977

    Yea - this is what i have suggested - SP3 - will take the user to 9.00.4035 which is good enough and tested client version for using sql 2008 instances.

    My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access[/url]

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

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