Re: SQL 2008 Installation


Okay, thanks, I'll give it a try and post the results.
Thank you for your help.

"Geoff N. Hiten" wrote:

Inline.


"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9708AC01-73C3-4563-B2DE-C474A8B333C4@xxxxxxxxxxxxxxxx
Hi Geoff and thank you for your response.

Okay, I read your article, if I understand your thoughts correctly:

- MSDTC should be in each Cluster group for each instance of SQL (does
this
apply to both SQL 2005 and 2008 right?).
Yes. I wrote that post before SQL 2008, but the same thought process and
rules apply.

-MSDTC should use the VS name and IP address that was used in that Cluster
group (I mean, you can associate to the networkname and ipaddress that's
being used to SQL server as long as you don't associate with SQL server
resources, right?)

Exactly. This is to prevent problems during subsequent SQL Updates.


To install SQL 2008, I'm following the KB 955392 to slipstream SP1 and
Update the SQL Server 2008 Setup support files.

You can slipstream or pre-patch. Your choice.
You say that I need to start with integrated installation? What option is
that? "Installation" menu or Advanced menu? Do I need to run in both nodes
or
just one? In SQL 2005 I needed to create a Cluster group with at least one
disk resource in it, is this still true for SQL 2008?


You start off by building the "base" node. After that you add to the
existing SQL cluster. Very similar to how yoo build a cluster in the first
place.


Thank you for your time and patience :)


You are welcome.

"Geoff N. Hiten" wrote:

Advanced is for sysprepped installations that will be duplicated many
times.

You need to start with Integrted installation.

Before you start, you need to download and run SQL 2008 SP1. This will
patch the installation script, which has some cluster-related bugs in the
RTM version. You will still need to apply SP1 after the regular
installation, since the "pre-patch" only fixes the install script.


Here is the official support policy for mixed version clusters:
http://support.microsoft.com/kb/327518

Here are my thoughts on MSDTC and Windows 2008 clustering.
http://weblogs.sqlteam.com/geoffh/archive/2008/07/31/DTC-configuration-for-Windows-2008-SQL-2005-Clusters.aspx

Hope this helps


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:132EA13B-1175-451A-8806-8D51D02C852B@xxxxxxxxxxxxxxxx
Hello Everyone,

I'm trying to setup a 2 node SQL 2008 failover cluster in windows 2008
(2
instances).

After reading some documentation, I'm confused about the right path to
follow.
I read that are 2 installation methods, Integrated and Advanced.

When I start the DVD I select "Installation" and I have the option "New
SQL
Server failover cluster installation".???!!!

If I go to "Advanced" menu, I have "advanced cluster preparation" and
"Advanced cluster completion"??!!

What should I use? Should I run advanced cluster preparation" on both
nodes
an them "Advanced cluster completion" on both nodes as well???!!!

Can anyone point me the right direction to start with?

Another question is related with having SQL 2008 in a cluster where SQL
2005
is already installed, is this supported? What precautions should I have
in
a
scenario like this one?

At last, Windows 2008 supports multiple instances of MSDTC. Assuming
the
SQL
2008 and SQL 2005 in a 2 node failover cluster, what is the right way
to
setup MSDTC? Should I create a separate cluster group for MSDTC for
each
instance of SQL? Or should I integrate a separate MSDTC cluster
reasource
in
each SQL cluster group??

Thank you for your time.






.

Relevant Pages

  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 Installation
    ... The MSDTC is assigned to my cluster name and IPAddress, ... My DTC configuration is using the Network name and ip address of the SQL ... cluster, and I assigned a Disk resource that is also inside the same SQL ... You need to start with Integrted installation. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 Installation
    ... As long as the instance count is less than 2x the node count, ine MSDTC per ... you will get better resource ... But in a cluster with more than one SQL instance makes sence to have one ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 cluster installation error
    ... Which goes back to the other thread titled "Is DTC required in a SQL ... 2000/Windows 2003 Cluster". ... > reinstalled Workstation components on both nodes and is all OK now.. ... >> Error pops up when Workstation components installation is ...
    (microsoft.public.sqlserver.clustering)
Loading