Re: IP Address change causes SQL Server to lose connection

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Maurice Boers (maurice_at_timbersoft.com)
Date: 03/16/04 

Date: Mon, 15 Mar 2004 21:39:33 -0800

How about updating the connection strings in the code running on the
websites to reflect the address change?
If this is defined in multiple prgs, I suggest using an alias, IE Instead of
specifing an IP, insert your alias (lets say "sequel"), then map the alias
in the HOSTS. file located at c:\windows\system32\drivers\etc\hosts. (no
extension) Then when your IP changes, just update the hosts file to
reflect the new ip and all your prgs will use the new ip.

You can test what I'm saying by adding the alias to the hosts file, then
open a dos window (click run then type "command"), then type ping <alias>
(ping sequel) - and you will see it respond with the ip you put in the hosts
file.
you'll need to do this on each machine hosting a web site. (an easier way
would be to add a dns entry instead of using the hosts file)

Mo

"Anil Gupte" <anil-news@maxnetwork.com> wrote in message
news:u8$s7JxCEHA.1128@TK2MSFTNGP11.phx.gbl...
> All my websites lose their access to the SQL server when we change the
> primary IP of the machine hosting the SQL Server (MS SQL 7). We are going
> to lose that IP because of an ISP change, so I need a solution quickly.
> Please advise.
>
> I have been able to get it to work by putting the old IP back on as a
> seconday address, but eventually that fix will not work either.
>
> Thanx for your help.
> --
> Anil Gupte
> agupte@nospam.maxnetwork.com
>
>

Relevant Pages

  • Re: IP Address change causes SQL Server to lose connection
    ... to the hosts file on the machine which has the DSN (i.e. the SQL Clients). ... > If this is defined in multiple prgs, I suggest using an alias, IE Instead ...
    (microsoft.public.sqlserver.server)
  • Re: where are the newsgroups???
    ... All other websites are fine. ... >If you have any other thoughts on what is happening to the DNS, ... Spyware Info: ... Block possibly dangerous websites with a Hosts file. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Browser Back Button
    ... AdAware, CWShredder, and Spybot S&D have install routines - run them. ... Spyware Warrior: ... Block Internet Explorer ActiveX scripting from dangerous websites (Restricted ... Block possibly dangerous websites with a Hosts file. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Cannot access some websites after virus cleaning
    ... -was using DNSAccelerator so my host file was full of websites (and perhaps ... -deactivated my dnsaccelerator and deleted everything in the hosts file ... I can access some websites like Lenovo, FreeCall, Free, my router, my bank, ... The problem is also similar with IE7 and I cannot access Windows Update. ...
    (microsoft.public.windowsxp.general)
  • Re: IE6 incorrectly displays web pages w/ style sheets
    ... Blocking Spyware, Adware, Parasites, Hijackers, Trojans, with a HOSTS file ... Please post replies to this Newsgroup, ... >>> This is for all websites that utilize style sheets. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)