May 20, 2004 at 9:37 am
The Server I am using for development has two names:
The DNS name is ixy341w1 on our European WAN or ixy341w1.abceur1 on our global WAN. Up to now I have been using ixy341w1.abceur1 in the connection string.
However SQL Server is using eu94346 as the Server name. This I understand is the net bios name on our LAN and will not be visible on our WAN.
Having created a new instance called usertesting, I can use eu94346\usertesting in the connection string on our LAN but understand that I can not use this on the WAN.
I guess that the DNS name ixy341w1 connects to the default SQL Server eu94346 but how do I connect to the instance eu94346\usertesting using the DNS name ixy341w1?
May 21, 2004 at 4:45 am
It suddenly occurred to me that I might resolve the problem by changing the machine name to the DNS name. Sure enough it solved the problem. I can now connect to the instance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply