SQL Server Performance

Connect to 2oo8 using Management Studio 2005

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Zirco, Jan 3, 2008.

  1. Zirco New Member

    Hi,
    I'd like to connect to SQL Server 2008 CTP Nov 07 using Management Studio 2005 (SP5 + Cumulative Update 4). I got an error message "This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)".
    Using Query Analyzer (SQL Server 2000 tools) works OK. How come Management Studio 2005 cannot connect and how to fix this?
    Thanks very much in advance for any help.

    Zirco, Jan 3, 2008
    #2

  2. MohammedU New Member

    MohammedU, Jan 3, 2008
    #3

  3. Zirco New Member

    Thanks, let's see if Cumulative Update 5 fixes the issue.
    Zirco, Jan 3, 2008
    #4

  4. Zirco New Member

    Confirmed, After installing SQL Server 2005 SP2 Cumulative Update #5. I can now use Management Studio 2005 to connect to SQL Server 2008.
    Thanks for your help.

    Zirco, Jan 7, 2008
    #5

  5. dineshasanka Moderator

    Are you using SQL Server 2005 and SQL Server 2008 in same server. Even though latest version of SQL Server 2008 you can have both versions, there are few issues with SSIS packages.
    dineshasanka, Jan 7, 2008
    #6

  6. yavvie New Member

    use this:
    Cumulative update package 6 for SQL Server 2005 Service Pack 2
    support.microsoft.com/kb/946608
    you need to get your local SQL server to version SQL Server 9.0.3228 or higher, then it works.
    I myself used this file: SQLServer2005-KB946608-x86-ENU.exe, but i think its that upgrade :))
    yavvie, Mar 16, 2009
    #7

  7. shabnyc Member

    Hi
    I had this issue recently (3 years after Zirco post) and I installed SP4 on client machine. I am Now able to connect to 2008 from SSMS 2005.
    Thanks MohammedU, Thank you all
    shabnyc, Feb 18, 2011
    #8

  8. satya Moderator

    Service pack should be applied to client tools in order to have bug fixed.
    satya, Jan 4, 2008
    #9

Share This Page