SQL Server Setup Or Installation Failure Errors

Issue

SQL Server 2008 R2 setup failed with “Error 1406. Could not write value to key \SOFTWARE. System error. Verify that you have sufficient access to that key, or contact your support personnel”

Solution

Follow the steps below to resolve the issue.

  1. Run setup as Administrator
  2. Make sure Administrator has full control on the registry key reported in the error.
  3. This issue can happen, if there are any kind of virus/adware/malware/Add-ons on the system. Scan the system and fix any such issues.

Issue

Error 997. Overlapped I/O operation is in progress during SQL Server installation

Solution

Follow the steps below to resolve the issue,

  1. Check the account with which you logged on to the server, make sure it is not a account with temporary profile.
  2. Run the Setup locally on the server and make sure you run the setup, by right-clicking on the Setup file and choose Run-As-Administrator.
  3. Disable any Anti-virus and reboot the server.
  4. Check for any problems with the disk drive where you are installing SQL Server files.

Issue

Invalid license data. Reinstall is required Error while trying to connect to SQL Server Management Studio (SSMS)

Solution

Follow the steps below to resolve the issue,

  1. Try to repair the SQL Server shared components(If you cannot launch the setup from control panel, use the Setup.exe from setup media.
  2. After repair, if the SSMS still fails with the same error, then uninstall Visual Studio 2010 or 2012 and then attempt the repair of the shared components again.