Re: SQL and DNS
anonymous_at_discussions.microsoft.com
Date: 02/24/04
- Next message: Guru: "Re: Run Batch Files with SQL Server Agent"
- Previous message: Tom Moreau: "Re: Question: Triggers"
- In reply to: John Jakus: "Re: SQL and DNS"
- Next in thread: John Jakus: "Re: SQL and DNS"
- Reply: John Jakus: "Re: SQL and DNS"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 10:19:28 -0800
sql server primary runs on tcpip, and you can configure it
to listen to multiple protocols at the same time. Client
specifies what protocol to use when initiating connection.
you should use client network utility to configure tcpip
as the first network protocol to be used to establish
connection to sql server. if you still have problems then
define an alias.
>-----Original Message-----
>Is there a way that you know of that I can do this
globally for my sites
>using a registry entry or something? Is there a parameter
that would
>tell NetBIOS to resolve to DNS instead?
>
>Thanks again,
>
>John Jakus
>
>Jim Young wrote:
>> Your welcome. The problem is not with SQL Server but
with applications that
>> need to be able to resolve a netbios name to an IP
address. In a pure DNS
>> environment and without a WINS server on your network
you will need to
>> create aliases on the client machines.
>>
>> Jim
>>
>> "John Jakus" <John.Jakus.DieSpammerDie@Valence.com>
wrote in message
>> news:ubs13lq%23DHA.2484@TK2MSFTNGP12.phx.gbl...
>>
>>>Jim,
>>>
>>>Thank you so much for that answer. I configured an
Alias with the server
>>>name as TCP/IP and it worked. Now can you explain why I
had to do that?
>>>Why doesn't SQL just resolve this using DNS? Is there a
place in the
>>>registry that I can just tell machines to use TCP
instead of other
>>>protocols for resolution to SQL?
>>>
>>>Thank You Again,
>>>
>>>John Jakus
>>>
>>>Jim Young wrote:
>>>
>>>>You will probably need to use the Client Network
Utility to create
>>
>> aliases
>>
>>>>to the IP address of your server.
>>>>
>>>>Jim
>>>>
>>>>"John Jakus" <John.Jakus.DieSpammerDie@Valence.com>
wrote in message
>>>>news:%23VkSc5o%23DHA.3820@TK2MSFTNGP09.phx.gbl...
>>>>
>>>>
>>>>>I have just setup a new SQL environment. The Server
is a Win2K SP4 with
>>>>>SQL Server 2000 and SP3a. Our site does not have an
MS domain, AD or
>>>>>WINS server. We do have DHCP and DNS running for IP
managment and name
>>>>>resolution. I have setup a DNS name for the SQL
server. I can resolve
>>>>>the name forward and backward. No problem. I am
having problems
>>>>>resolving to this server with applicatoins.
>>>>>
>>>>>I can setup application connections using IP address
but DNS resolution
>>>>>does not work with all products.
>>>>>
>>>>>SQL Enterprise Managment Server will connect using IP
or full DNS name.
>>>>>If I try to use just host name, it fails to connect
with a access denied
>>>>>or server not found error.
>>>>>
>>>>>Now from a command prompt I can resolve using both
hostname.domain.com
>>>>>and hostname. If I try using both of these from some
SQL applications
>>>>>they fail.
>>>>>
>>>>>Does SQL rely on NetBIOS names?
>>>>>
>>>>>Any information would be appreciated.
>>>>>
>>>>>Thank You,
>>>>>
>>>>>John Jakus
>>>>
>>>>
>>>>
>>
>>
>.
>
- Next message: Guru: "Re: Run Batch Files with SQL Server Agent"
- Previous message: Tom Moreau: "Re: Question: Triggers"
- In reply to: John Jakus: "Re: SQL and DNS"
- Next in thread: John Jakus: "Re: SQL and DNS"
- Reply: John Jakus: "Re: SQL and DNS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
