Check if every group is active on this node. If
not do so before continuing the installation of SQL.
- Log into
the computer as a domain administrator or equivalent
- Prepare
the SQL Server 2005 Enterprise Edition source. Prefer to copy them
locally. Both discs need to be stored.
- Ensure
that the following services are installed and running on all nodes
that will be in the cluster:
- Cryptographic Services
- Task Scheduler
- Reboot
all servers in the cluster (first node first, then second node and
so on. Always wait until previous one is fully booted).
- Log into
the computer as a domain administrator or equivalent. The user
should be able to add user accounts into domain groups.
Do not logon to any other node in the
cluster!!!!
- Go to
the disk location where the software is residing.
Double click 'Splash.hta'
- Click
Server components
- Accept
the license agreement and click next
- Click
'Install'. This step will install prerequisites:
- MS SQL Native Client
- MS SQL Server 2005 Setup Support Files
- Once
finished, click 'Next'
- Click
Next
- System
configuration check: Normally we should have 29 Total / 29 Success
but in our case we're not installing reporting thus IIS is not
installed. This will result in 29 Total / 27 Success / 2
Warning.
Click yes
- Enter
the registration data (Normally already filled in).
Click Next
- Select
the components to install. In our case we select:
- SQL Server Database Services
- Create a SQL Server failover cluster
- Notification Services
- Integration Services
- Workstation components, Books Online and development tools
Click Next
- Select
'Default instance' or 'Named instance'. Depending the document of
the solution architect.
If Named instance, provide this name.
Click Next
- Provide
the virtual server name and press Next
- Provide
the IP Address and press 'Add'.
Be careful with the subnet mask.
When done, press Next
- Select
the concerned Cluster group. Verify the location of the 'Data File'
and correct if necessary.
Press Next
- On
Cluster Node Configuration, press Next
The node on which you 're working should be mentioned under
'Required Node', will all others are mentioned under 'Selected
Node'.
- Remote
Account Information: Provide the password of the user under which
you're installing the software. This will be used during setup
only.
- Service
Accounts: Add the accounts and the passwords for each of the
services that were selected.
- Select 'Customize for each service account'
- Provide for each Service mentioned the necessary
credentials.
Except for SQL Browser. Here we'll select "Network Service".
When finished, press Next.
At this stage the installation wizard will verify the correctness
of the information entered. If not correct, you'll be warned and
returned to this screen.
- Domain
Groups for Cluster Services: Provide each Service Name the
corresponding Domain\GroupName. For selecting through browsing
press on the icon at the end of each line.
When finished, press Next.
-
Authentication Mode:
Select 'Windows Authentication Mode'
Click Next
-
Collation Settings:
Select 'SQL collations (used for compatibility with previous
versions of SQL Server).
Select 'Dictionary Order, case-insensitive, for use with 1252
character set'.
Normally is this a default value. But
it can change when the system has be installed with different
regional settings.
Click Next
- Report
Server Installation Options:
Click Next
- Error
and Usage Report Settings:
Leave all options unselected.
Click Next
- Ready to
Install:
Click Install
- Setup
Progress:
Now the installation of the SQL software starts. You can verify the
results on the installation. Be warned that this installation may
take up to 20 minutes.
When successfully finished, press Next
-
Completing Microsoft SQL Server 2005 Setup:
Press Finish.
check that the version installed is (Microsoft
SQL 2005 - 9.00.1399.06'
Test cluster fail-over and check that SQL
restarts successful on each node.
1. Hardware
