SQL Server Setup Error. Could Not Find File ‘MediaInfo.xml’

When trying to install SQL Server 2008 R2, you get the following error: SQL Server Setup Failure. SQL Server Setup has encountered the following error: Could not find the file ‘\MediaInfo.xml’.. This is because, when you run SQL Server Installation Center, several files are decompressed ready for installation. MediaInfo.xml is one of these files. When […]
Continue reading…

 

How To Recover The SA Password On SQL Server 2008 R2

If you’ve lost the SA password of your SQL Server 2008 R2 computer, don’t panic; it can be recovered! To recover a lost SA password on SQL Server 2008 R2, do the following: Start SQL Server Configuration Manager Stop the SQL Server services Right click the SQL Server (<<Instance name of SA password to recover>>) […]
Continue reading…

 

SQL Server 2008 R2 Service Pack 1 Or Later Is Required For Upgrade

When upgrading Microsoft SQL 2008 R2 to MSSQL 2012, you may get the following error message: Rule Check Result Rule “SQL Server 2008 R2 Service Pack 1 or later is required for upgrade.” failed. The SQL Server 2008 R2 Features that have been selected to be upgraded to SQL Server 2012 are not at the […]
Continue reading…