0

We recently installed SQL server 2000 Std. edition on my new windows server 2003 R2 server which is the additional domain in our existing windows 2003 server domain. Now i am unable to connect this new server from any SQL client by name of that server. if we enter the IP address of that SQL server then client are able to connect database of this server.

any help will be appreciated.

Regards,

Sandesh.

sandeshgawade87
  • 1

2 Answers2

1

Are you having any name resolution issues? What happens if you ping the computer name?

mrdenny
  • 27,212
0

Run the SQL Client Network Utility on a client's workstation and add an alias.

Change the net-library to use TCP-IP, and enter the name of the server and the server's IP address.

Dan
  • 783