Post reply

Need server-side tools to browse and query SQL 2000 Server.

  • February 16, 2007 at 1:56 pm

    #115700

    I'm familiar with SQL 2005, but I haven't worked with SQL 2000.  I need to query (sitting on the server) on a SQL 2000 server and I don't know what tools I can use to browse the server DB.  Is there anything like the 2005 SQL Server Management Studio?

    Thanks

  • February 16, 2007 at 2:04 pm

    #690328

    Hello,

    In order to work with SQL Server 2000 just like 2005 SQL Server Management Studio, you need to have 2000 Enterprise Manager i.e., for registering the servers etc. If you want to query the SQL 2000 databases, then it is sufficient to have client tools - query analyzer.

    You can also register the SQL 2000 server in 2005 Management Studio and then query through the "New Query" window by connecting to the desired server.

    Hope this helps.

    Thanks

     


    Lucky

  • February 16, 2007 at 2:13 pm

    #690330

    Thanks!

    I have installed 2005 Management Studio, but when i try to connect, it fails with "Cannot connect to <project name> 

        An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005..."

    It seems to be looking for SQL Server 2005.  What do I need to do to "register the SQL 2000 Server in 2005 Managment Studio".

    Thanks so much!

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

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