SQL 2000

  • hi, i am new to sql can anyone help on how to remotely connect to my newly sql machine to a different machine.. thanks in advance.

  • From Enterprise Manager, right click on SQL Server Group and choose New SQL Server Registration and follow the wizard. This will allow you to navigate the other SQL Server instance from your server.

    If you want to use the other server to perform queries, set up a linked server on your production box to the other server.

    When connecting, if you can't resolve the server name, use the IP address.

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

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