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?
Melih SARICA
Why not SQL 2014 on Windows 2012 Cluster?
ASKER
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.
Ok.
What functionalities u ll need on SQL Server side ?
Database engine only or other serviceses also ( like analysis, reporting, SSIS etc?)
What functionalities u ll need on SQL Server side ?
Database engine only or other serviceses also ( like analysis, reporting, SSIS etc?)
ASKER
Database engine plus reporting. No SSIS or Analysis. It says MS Reporter Builder 3.0 Integration.
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
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
ASKER
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
The only item i found is below:
http://support.microsoft.com/en-us/kb/2681562
ASKER
I ask about special instructions, because i get the pop-up below on install.
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
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
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.
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.