Register SQL Server remotely without alias?

  • I woluld like to solve my problem:

    clients are on different network from SQL server. Clients connect to DB server by router (windows server 2003).

    Clients ping DB server,

    clients open telnet connection to db server.

    Problem:

    I try to register SQL server on Clients, but It fails: database does not exist or not perinssion (something like that).

    So I open network utility I set up an alias with the ip address of server and ports and I registered the server.(I had to set port, otherwise registering fails).

     

    Do you know how to registered SQL server on client without using alias????

    thank

  • Adding the name & ip to the windows hosts file?

    windows\system32\drivers\etc\hosts

  • Very good!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    It looks working!!!!!!!!!

     

    thank

  • I add:

    configuring DNS to solve server name

     

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

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