Re: SQL 2000 Setup failing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Bingo. The SQL installer can't deal with offline groups very well. Try the
same thing with SQL 2005 and the installer crashes before ever asking any
cluster-related questions.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



<news@xxxxxxxxxxxxxxxxxx> wrote in message
news:1139502234.875907.305350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Cheers.

Drives are all fine. However, I think I may be getting somewhere: it's
to do with the fact that there are two other groups, one is a cluster
group (obviously) and the other is an Exchange group. All are on the
active node, but the Exchange group is completely offline.

Here's how I can reproduce the problem:
- I ensure that all three groups are on the active node (node a)
- The Exchange group is offline.
- I reboot both nodes (order doesn't matter: if node b takes over after
the reboots, I just move the groups back to node a)
- Try the setup again on node a - the problem reoccurs.

Now to "fix" it:
- Bring online any of the disk resources in the Exchange group (even
though I'm not using them).
- [optional]: take the resource back offline again.
- Setup now works.

Yes, it really does work - in my environment at least. In fact, setup
continues to work independently of whether any of the disk resources on
the Exchange group are online or not once I've done the fix. Until the
next reboot, that is, and then I'm back to square 1 again.

Weird, eh?



.

Relevant Pages

  • Re: Change 2005 failover cluster IP
    ... Principal SQL Infrastructure Consultant ... sql group to either node everything moves really fast except the cluster name ... I have verified the network adapter ... > scheduled when I do this so being offline is not a problem. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSDE OSQL Shutdown
    ... dann den Server herunterfährst könnte genau in dem Moment die Aktion ... Aus Gründen der Datenkonsistenz sollten Datenbanken niemals Offline ... weil alle Backups dazwischen unbrauchbar waren;-) ... Datenbank Verzeichnis des SQL Servers dafür vom Dateibackup aus. ...
    (microsoft.public.de.sqlserver)
  • Re: 64-bit SQL2005 SP2 Fails on cluster install
    ... you need take off your active node (where SQL Server Instance installed ... Package Platform: x64 ... Product Installation Status ...
    (microsoft.public.sqlserver.clustering)
  • Re: Removing a SQL cluster node
    ... To clarify, when adding a node to an existing virtual server, the SQL ... Instance will come OffLine for about 5-10 minutes while the binaries are ... >issues in the past and was removed at build 977 when the new hotfix ... >> Thanks to Geoff and William for pointing me to the right procedures. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Saving into a Database
    ... > Is it possible to store XLS and DOC files into a MSaccess Database, or SQL ... > data to the Laptops so that we could view and run CR offline. ...
    (microsoft.public.dotnet.languages.vb)