Post reply

Sql Server 2K to 2K5 connection

  • January 31, 2006 at 8:06 am

    #112364

    From Sql Server 2K I can see but can not connect to 2K5. What I need to do? Thanks

  • January 31, 2006 at 9:33 am

    #617959

    You will not be able to connect to 2005 via the 2000 client tools (Enterprise Manager, Query Analyzer, SQL Profiler etc...)  You can use the 2005 tools to connect to 2000 instances, but not the other way round.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • January 31, 2006 at 9:37 am

    #617961

    Yes, I know. But could you, please, be a bit specific- what to use? Thanks

  • January 31, 2006 at 9:49 am

    #617964

    Sorry for my previous message- I didn't get you. You mean that there is no way to connect to Sql Server 2K5 from 2K? Thanks

  • January 31, 2006 at 10:08 am

    #617966

    That depends on what you are trying to accomplish...  You can set up a linked server to 2005 just using the oledb client.  We have encountered some strange behaviour when it comes to distributed transactions.  We're still trying to figure that one out, but everything else works great. 

    I have not tried installing the SQL Native Client on the 2000 box yet.

    You will not be able to use the 2000 client tools to "manage" a 2005 instance though.  You will need to install the 2005 client tools.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • January 31, 2006 at 10:39 am

    #617972

    I do use 2000 Query Analyzer to connect to 2005 server. It is true that you can not use Enterprise Manager. You may want to install 2005 client components.

    If you need to connect for management you may use Terminal Services to get to the server machine and administer locally.

    If you want to connect from the application it mostly works, like creating ODBC Data Source

    Regards,Yelena Varsha

  • January 31, 2006 at 10:52 am

    #617974

    Thanks you, guys

Viewing 7 posts - 1 through 6 (of 6 total)

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