Can I use a Hostname on registering the server with TCPIP?

[Hoa Binh]

Hi everyone,

my SQL is running TCPIP and everytime I register the server from a client, I have to enter in the IP address. Can I use a hostname to map an IP address to a server name and then enter the server name to register the server?

Thanks..Binh

[patrick fediere]

Several ways to associate the server name and the IP address.
The basic one is the LMHOSTS & Hosts Files (look at the LMHOSTS.sam is a sample)
One step over you could use WINS
and finally DNS
If you do an association like 111.222.11.22 HEWLETT
To check if your definition works do a "PING HEWLETT" must reach the server.
Bye
On 1/7/99 1:27:04 PM, Hoa Binh wrote:
> Hi everyone,

my SQL is running TCPIP and everytime I register the server
> from a client, I have to enter in the IP address. Can I use a hostname to
> map an IP address to a server name and then enter the server name to
> register the server?

Thanks..Binh

[Ali Malekshahi]

You can setup any name associated with a TCP/IP Address by enering the Server Name (It can be any name), Choosing TCP/IP Socket as DLL Name, entering TCP/IP Address in connection string and add the new entry in Advanced tab of Client Configuration Utility.

Before you register in SQL Server, You have to find the computer in Find Computer and entering TCP/IP Address or Host Name and logging into it.

Ali Malekshahi

On 1/7/99 1:27:04 PM, Hoa Binh wrote:
> Hi everyone,

my SQL is running TCPIP and everytime I register the server
> from a client, I have to enter in the IP address. Can I use a hostname to
> map an IP address to a server name and then enter the server name to
> register the server?

Thanks..Binh