Install SQL 2008 R2 Standard on a Windows 2012 Server 2-Node Cluster

I have a 2-node Windows Server 2012 Cluster setup. How do i properly install SQL Server 2008 R2 to the cluster?
LVL 1
First LastAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How do you want to install a clustered SQL Server instance without a shared disk? It's a requisite.
For Database Mirroring you don't need a cluster install.
0
 
Melih SARICAOwnerCommented:
Why not SQL 2014 on Windows 2012 Cluster?
0
 
First LastAuthor Commented:
Melih - that would be too simple. My vendor said their software won't be supported on anything higher than SQL 2008 R2. They support up to Windows Server 2012 R2.
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
Melih SARICAOwnerCommented:
Ok.

What functionalities u ll need on SQL Server side ?

Database engine only or other serviceses also  ( like analysis, reporting, SSIS etc?)
0
 
First LastAuthor Commented:
Database engine plus reporting.  No SSIS or Analysis. It says MS Reporter Builder 3.0 Integration.
0
 
Melih SARICAOwnerCommented:
IF report builder 3.0 is needed that means that reporting services ll be ok for extra.

What is needed ?

1. Create a Windows Cluster. For performance issues. dont forget to create cluster disk resources seperated
  1 for Data, 1 for log and 1 for backup at least.. if u ll have a highly transactional database maybe u want to seperate file groups in different locations also. ( Dont use Cluster Shared Volumes, avaiable for SQL 2014 only)
2. In the first Cluster host. Install SQL server CD and install SQL server as Cluster.
3. When Its finished. Install SQL server as cluster node on second cluster host. and join to the SQL Cluster.


check this link from TechNet for more details
technet SQL cluster installation
0
 
First LastAuthor Commented:
Are you aware of any special instructions for setting up SQL 20082 in a Windows Server 2012 Cluster?

The only item i found is below:
http://support.microsoft.com/en-us/kb/2681562
0
 
First LastAuthor Commented:
I ask about special instructions, because i get the pop-up below on install.


Untitled.jpg
0
 
Melih SARICAOwnerCommented:
check this link below.

https://social.technet.microsoft.com/Forums/windowsserver/en-US/9cb1308d-edd0-44e5-a10e-dfb9f10a1ef3/sql-server-2008-r2-failed-on-windows-server-2012

and Thinks can be different sometimes.. can u send log details about installation errors

I always try step by step installation guides from TechNet and dont get stupid error messages :)

If u ave one those ms error messages then we ll need the details of that message
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do you already have a Windows Cluster installed and configured?
Don't forget that SQL Server 2008R2 was released previous than Windows Server 2012 so that warning window can be because of that. Anyway you shouldn't worry at that point. First run the SQL Server setup further since one of the first steps of the installation is to check for pre requisites and will inform you which ones aren't available.
0
 
First LastAuthor Commented:
I have the Windows Cluster built. However, this Windows Cluster won't have Shared Storage. I'm going to be using SQL 2008 R2 Database mirroring.

When i go to install SQL 2008 R2, i'm getting an error relating to MSDTC and MSCS.

I'm installing SQL 2008 R2 64-bit


Untitled.jpg
0
 
Melih SARICAOwnerCommented:
U must Disk to ur Windows cluster as I mentioned above.

First Windows Cluster.
then cluster Disks.
then SQL Installation
0
 
First LastAuthor Commented:
SQL 2008 R2 with SP3 utilizing database mirroring on a Windows Server 2012 R2 Cluster w/o shared storage is difficult at best. I've decided to no go with clustering or mirroring.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.