Re: SQL and DNS
From: Jim Young (thorium48_at_hotmail.com)
Date: 02/24/04
- Next message: Avi: "how to configure ms sql server 2k and windows server 2k in order to sql from remote computer (with vb)"
- Previous message: John Jakus: "SQL and DNS"
- In reply to: John Jakus: "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: Mon, 23 Feb 2004 21:13:46 -0800
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: Avi: "how to configure ms sql server 2k and windows server 2k in order to sql from remote computer (with vb)"
- Previous message: John Jakus: "SQL and DNS"
- In reply to: John Jakus: "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
|
