Only SQL Server 2008 R2 Service Pack 2 (SP2) is certified to run on Windows Server 2012 R2. Since the base install doesn’t come with the service update, I’ll have to go through the installation process with the occasional bumps and later on apply the service pack.
Can I run SQL 2008 and SQL 2012 on the same server?
As long as each SQL Server instance is installed as a unique named instance, there should be no conflict between them. … A SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 Standard or Enterprise Edition instance may be used to run multiple databases, including a mix of third-party and/or Blackbaud databases.
Can Windows Server 2008 R2 be upgraded to 2012?
To perform the upgrade
Make sure the BuildLabEx value says you’re running Windows Server 2008 R2. Locate the Windows Server 2012 R2 Setup media, and then select setup.exe. Select Yes to start the setup process. … Select the Windows Server 2012 R2 edition you want to install, and then select Next.