Re: Adding a node to a one-node functional cluster

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Geoff,

almost everything works fine. The only problem I had was the path of the
sqlserver service excecutable, i.e., the path of the file sqlserver.exe. In
the second node I received the "access is denied" error when I tried to
start the service. That was because the path was configured as
"\\SQL02\c$\program~1\....." in the service, and the user who was configured
to start the service cannot access that path. I changed the user to a more
powerful user and it works great, but I don't like that solution. I think I
can change the path in the registry, and use a less power user... what to
you think about that?

Patrick.

"Patrick Mac Kay" <pmackay_at_hotmail.com> escribió en el mensaje
news:OOg2eeyWFHA.616@xxxxxxxxxxxxxxxxxxxxxxx
> thanks again. I'll try it today.....
>
> Patrick.
>
> "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> escribió en el mensaje
> news:eNLG5ZxWFHA.2288@xxxxxxxxxxxxxxxxxxxxxxx
> > The only risk of data corruption is before the LUNs are tagged as
cluster
> > disks. Until then, both nodes will try and mount them, typically with
bad
> > results. Once the cluster service writes an intentionally mangled
> signature
> > on the disks, the OS thinks they are foreign partitions and won't try
and
> > mount them directly. You will need to do whatever your SAN
> vendor/software
> > requires so the new node can see the LUNs as well as the old node. You
> will
> > likely have to reboot the new node so it can see the LUNs as disks.
Then
> > you can add the node with the cluster wizard (here is where Windows 2003
> > makes it a lot easier) and finally add the SQL instance per BOL. Don't
> > forget to apply any service packs and hotfixes to the new node.
> >
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> >
> > "Patrick Mac Kay" <pmackay_at_hotmail.com> wrote in message
> > news:uoBewVxWFHA.3324@xxxxxxxxxxxxxxxxxxxxxxx
> > > Geoff,
> > >
> > > thanks. It seems very simple, but I have some doubts. Is there any
> risk
> > > with the databases or the shared directories in the SAN?. I read some
> > > information about the clusters and the posibility of corrupt data if
> both
> > > are online at the same time.... is that true?
> > >
> > > Thanks again.
> > >
> > > Patrick.
> > >
> > > "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> escribió en el mensaje
> > > news:ew7kcrwWFHA.2796@xxxxxxxxxxxxxxxxxxxxxxx
> > >> BOL covers exactly this topic under "Maintaining a Failover Cluster"
> > >>
> > >> Index search "Failover Clustering". Choose maintaining. the first
> topic
> > > on
> > >> teh page is "Adding a Node to an existing Virtual Server".
> > >>
> > >> Geoff N. Hiten
> > >> Microsoft SQL Server MVP
> > >>
> > >> "Patrick Mac Kay" <pmackay_at_hotmail.com> wrote in message
> > >> news:OOYALjwWFHA.3828@xxxxxxxxxxxxxxxxxxxxxxx
> > >> > Hi everybody,
> > >> >
> > >> > due to a busy server (the 2nd node), I couldn't install the two
> > >> > nodes
> > >> > in
> > >> > one step, and I was forced to install a cluster with one node, and
> > >> > bring
> > >> > it
> > >> > online with the production database. Now everything works fine (in
> one
> > >> > node
> > >> > of course) and I'd like to install the second node. I've just
> installed
> > >> > windows 2003 sp1 in the 2nd node server, but i'm not sure the
correct
> > >> > steps
> > >> > to add a second node with the first one in production.
> > >> >
> > >> > If you have any information, I'll really apreciate it.
> > >> >
> > >> > Thanks
> > >> >
> > >> > Patrick.
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: Unreadable disk
    ... I found out that when the hidden cluster service called Clusdisk is ... I can see all my LUNs again. ... So I guess the disks signatures are not good anymore. ...
    (microsoft.public.windows.server.clustering)
  • Re: Adding a node to a one-node functional cluster
    ... Until then, both nodes will try and mount them, typically with bad ... Once the cluster service writes an intentionally mangled ... > on the disks, the OS thinks they are foreign partitions and won't try and ... > requires so the new node can see the LUNs as well as the old node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: How do I migrate data on drives that are cluster resouces
    ... We have to move the data to new physical luns. ... Do I need to completely shut down the cluster services? ... LUN and points the server to the new LUN, again, no outage. ... drives or grow the virtual disks. ...
    (microsoft.public.windows.server.clustering)
  • Re: Adding a node to a one-node functional cluster
    ... The only risk of data corruption is before the LUNs are tagged as cluster ... Until then, both nodes will try and mount them, typically with bad ... on the disks, the OS thinks they are foreign partitions and won't try and ...
    (microsoft.public.sqlserver.clustering)
  • Daily Report #4165
    ... The resultant cleaned cluster CMDs will ... well-understood host galaxy environment. ... The Nature of the Halos and Thick Disks of Spiral Galaxies ... ACS, NICMOS, and WFPC2 in parallel. ...
    (sci.astro.hubble)