Re: SQL Server Cluster move

You are hitting this
http://support.microsoft.com/default.aspx?scid=kb;en-us;319578

You should have done this.
http://support.microsoft.com/default.aspx?scid=kb;en-us;244980

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog

"CJ Butcher" <cjbutcher@xxxxxxxx> wrote in message
news:OWrkMfRQFHA.128@xxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
>
> I built a SQL Cluster in a dev area next to my cube. Had two web
> servers pointing at it and everything was working perfectly. I picked
> up all 4 of my machines and moved them to my colo. This ment I had to
> change all the IP addresses associated with the machines, this all
> seemed to go very smoothly. I got the cluster backup with all it's new
> IP's and all my web servers came up too. I could connect to my database
> from both of my cluster machines, however I could NOT connect from
> anywhere else. Not from my web servers and not from my desck top
> machine.
>
> Environment running on:
> Windows 2003 with all the latest SP's.
> SQL Server 2000 with SP3
> Dual Processors
> 4 Gig ram
> 1/2 Terrabyte of disk.
>
> Any thoughts?
>
> Thanks,
>
> CJ
>
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: sql clustering vs load balancing
    ... and the are load balanced using a microsoft load balance cluster. ... machines also host our web sites. ... sigle ip address for my database servers. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2003 Network Load Balancing Problem
    ... Sadly my servers websites were configured with specific IPs and host ... I find it very strange why the NLB driver can receive on a virtual IP ... he set his IIS website to use ALL UNASSIGNED addresses rather than ... specifically pointing it at the single virtual cluster address. ...
    (microsoft.public.windows.server.clustering)
  • Re: upgrading sql2k cluster to sql2005
    ... that databases get locked off in the current cluster and then properly ... I maintain many SQL servers as ... Who is going to track down all of the applications that need to have ...
    (microsoft.public.sqlserver.clustering)
  • Re: Load Balanced TS Servers and Unicast Flooding
    ... Remove each on of your tse servers from the cluster, ... Start adding them back to the NLB Cluster. ... > NICs. ...
    (microsoft.public.windows.terminal_services)
  • Re: High Availability FreeBSD www cluster
    ... I would like to set up the servers so if one server falls over the other will take over the services automatically, load balanceing would be good as well. ... High Availability means that your cluster should work even some system components fail. ... For building HA cluster you should have at last two machines, first will run in master mode, second in slavemode. ... Another way is to use software systems such us DRBD, NFS, chironfs, rsync etc. ...
    (freebsd-questions)