RJ's techPlay

No feature were uninstalled during the setup execution : SQL 2008 R2

PROBLEM: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

No feature were uninstalled during the setup execution. The requested features may not be installed. Please review the summary.txt logs for further details.

RESOLUTION :

Step 1 : regedit

Step 2 : Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\

Step 3 : Locate all of the R2-related GUIDs in the registry key.

Step 4 : Double click on uninstallstring copy all the text and paste in notepad. Do this for all R2 GUIDs.

Step 5 : Replace the Msiexec.exe /I with Msiexec.exe /X.

I have also include GUIDs of SQL SERVER 2008 R2 (LAST TWO LINE IN PICTURE)

Shown in below picture Please note your set of GUIDs may be different than mine.

Step 6 : Save notepad as .bat extension and run.

Step 7 : Run the batch three to four time and reboot the machine and that's it.

Configure Firewall to Allow SQL Server Port

Hi Buddy's

Firewall helps to prevent unauthorized access to computer resources. if firewall is not correctly configured then a attempts to connect to SQL might be blocked.

You can configure port by following steps as mentioned.

A. Open control panel >> Windows Firewall >> Advanced setting >> click on Inbound rules >> New Rule >> select PORT >> select >> TCP >> Enter 1433 >> Allow connection >> select network type >> Name = SQLPort >> Finish.

B. Use following command line in CMD.

netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT

Start Button for Windows 8 Free !

Hi Buddy's

In windows 8 Microsoft has made some changes to be in market. some changes are appreciated but some wasn't like; removal of start button.

I personally love start button and i cant work without, You can get Start in windows 8 by simply installing Classic Shell or IObit start menu.

Hope you will love it..
Don't forget to share and like.