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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.