On both nodes
- need .NET 3.5 SP1 use the Role Management Tool
- Add Role - Application Server
Run the setup.exe - SQL Server Installation Center
- Click Installation on left > New SQL Server Failover installation
- Setup suport Rules - click OK
- Prod Key - click next
- EULA - accept - next
- Click Install
- Setup support Rules - will tell you more about what else you might want to install for this to work.
- - MSDTC - not always needed for cluster. install if you want.
- - MSCS - cluster validation report failure - http://support.microsoft.com/kb/953748 - if you havent validated your cluster, you get an error when trying to install - go to Failover Cluster manager and click Validate this cluster.
- prod key - click next
- EULA - accept - next
- Feature Selection - Database Services, Analysis Services, Reporting Services - next
-
Instance Config
- SQLServer Network Name - obxSQL0801
- Named Instance - SQL1
- next
Disk Space Reqs - you will need at least 4 or 5 gbs of local disk space if you're going to install the services I listed above. I had to go back and shut down my vms and cut a D drive (thin-vhd) of 20GB on each of my nodes. then you can install all your SQL bits on the new D drive instead of on the OS drive.
- instance root directory - d:\
- next
Cluster Resource Group
- SQL Server cluster resource group name - SQL Server (SQL1)
- next
Cluster Disk Selection
- select both of your cluster disks for data and logs
- next
Cluster Network Configuration
- uncheck DHCP and put in an available non-DHCP address
- next
Cluster Security Policy
- select Use service SIDs (recommended)
- next
Server Config
- create a service account in AD obxClusterService
- use obxbill\obxClusterService
- next
Database Eng Config
- select mixed mode
- specify your sa password
- click add current user
- click Data Directories tab, make sure you're using the correct drive for the type of db file - i.e. R:\Data and L:\Logs and R:\Backup, etc, etc
- next
Analysys Services Config
- click Add current user
- click Data Directories tab, i.e. R:\OLAP\Data, L:\OLAP\Log, R:\OLAP\Temp and R:\OLAP\Backup
- next
Reporting Services Config
- install but do not configure
- next
Error Reporting
- next
Cluster Installation Rules
- all passed - hit next
Ready to Install
- click install, go have a drink and a smoke now.
- maybe call your mom to let them know you passed the CISSP Exam...
- think about what to have for dinner
- go water some houseplants
- decide that a potbelly samich sounds easy enough
Complete
- close
now go to the obxNode04 and start the SQL install just like you did here
- setup.exe - Installation > Add node
Setup Support Rules
- all passed - ok
Prod Key - next
EULA - accept - next
Setup support files - install
Setup Support Rules
- all passed - next
Cluster node config
- select your SQL1 instance
- next
Service Accounts
- enter the password for the service acct you created earlier
- next
Error Reporting
- next
Add Node Rules
- passed
- next
Ready to Add node
- click install
Add Node Progress
- if you havent gone to go get dinner by now. It's probably a good time. :)
- next
Complete
- success! - close
okie dokie - test your failover cluster by moving the SQL1 application, etc, etc and now go eat sandwich and watch Jeopardy or somethin.