RE: SQL and DNS

This issue is fixed in MDAC 2.8; and there were QFE fixes for MDAC 27RTM, and
MDAC 27Sp1.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


"jkohut" wrote:

> I am trying to use a DNS alias name of SQL server to connect to SQL Server.
> KB Article 818510 indicates there were some problems with MDAC 2.7 SP1 and
> 2.6 that may prevent DNS names from working reliably.
> Does anyone know for sure if this has been fixed in MDAC 2.8 or above?
>
> We want to use the DNS name of the Server so that if the SQL database
> location needs to change later (another server) we can simply change DNS
> alias.
>
> Any help would be greatly appreciated. Thanks.
.

Relevant Pages

  • RE: Event Viewer
    ... I recommend that you refer to article KB242768 to remove the DNS orphaned ... registry entry and refer to KB290991 to remove SQL server registry entry. ...
    (microsoft.public.win2000.active_directory)
  • Re: Installing/Moving SQL Server 2000 on to SBS 2003 Standard Edition
    ... Users can still use public DNS to locate resources. ... but that instance does require its own SQL CALs ... and cannot benefit from the SBS "all apps in one" CAL. ... >> you could probably sell your unfettered SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant log into Domain
    ... What is listed for the DNS IPs?? ... Is it the IP address of the LAN adapter for the SBS server?? ... Several issues are appearing in a new installation of SBS2003. ... I've upgraded MSDE to SQL server following the instructions on the ...
    (microsoft.public.windows.server.sbs)
  • Re: Same instance name in cluster ?
    ... By using DNS round robin users can access 2 SQL servers instead of only one. ... SQL Server MVP ... For dns alias it's not possible to create an entry with a \ ... contact them from a single dns name so I can have high performance and high ...
    (microsoft.public.sqlserver.clustering)
  • Re: Recipient policy error with event ID 8231
    ... this was caused by DNS not resolving netbios names. ... set up the DNS settings on the Exchange box to append our local domain ... MCP (SQL Server), CCA ... We have an Exchange 2003 server which I recently upgraded to SP2. ...
    (microsoft.public.exchange.admin)
Loading