Friday, 10 June 2016

Visual Studio

Visual Studio required for BI is SQL Server data tool

Issue with SQL Server installation

Currently, I would suggest you following these steps to fix the issue:
  1. Remove all SQL Server components from 'Programs and Features'
  2. Backup the registry
  3. Delete the following keys in regedit:
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
  4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server
  5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
  6. Rename all the SQL Server folders in the computer
  7. Reboot the machine
  8. Install SQL Server 2008 R2 again