Comment whatever you like, but comment moderation is turned on. It might take some time for your comment to be published.

Wednesday, April 26, 2017

Can't Connect To Remote SQL Server

I have two SQL versions (SQL 2012 and SQL 2016) installed and running concurrently on a single server. After installing SQL 2016, had issue connecting to the newly created instant. Error "

 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support strong text requested protocol) (Microsoft SQL Server, Error: -1)

Can't find much on the Net for the precise solution to this specific issue. Eventually after almost half a day googling, the problem was the network protocol (TCP/IP) was disabled by default. After enabling TCP/IP, the connection works like charm!

Wednesday, December 21, 2016

Hibernate Option In Windows Power button Lost After Windows Update

Strangely, after applying Windows Update, the HIBERNATE option again is missing from the Windows power option button, leaving "SLEEP","SHUTDOWN" and "RESTART" available.

To make the HIBERNATE option available, run CMD in Admin mode. Issue following command:

powercfg /hibernate on
powercfg -h on

Friday, November 25, 2016

Hibernate Option In Windows Power button

Strangely, in Windows 10, the Hibernate option is not available by default.
To pull the Hibernate option out, go to "Power Options". Click on "Choose what the power buttons do".



Click on "Change settings that are currently unavailable."


Scroll down & check on "Hibernate" option. 


Tuesday, November 22, 2016

Internet Explore Closed In A Flash When Opening attachment (PDF)

Cracking head trying to resolve this issue of Internet Explorer closed in a flash when trying to launch or open an attachment (PDF document to be precise), instead of prompting to save or launch the attachment.

To resolve the issue:

Internet Explorer - Tools - Internet Options - Security - Custom Level. Scroll all the way down to section 'Downloads' - 'File Download', select 'Enable'


Monday, September 26, 2016

Windows Hello Fingerprint sign-in Not Available in Domain

Windows Hello or fingerprint sign-in options is not available when sign-on to domain. 
To re-enable this feature, launch the Local Group Policy Editor

Navigate to COMPUTER CONFIGURATION -- ADMINISTRATIVE TEMPLATES -- SYSTEM -- LOGON -- change "Turn on convenience PIN sign-in" state to ENABLED

Navigate to COMPUTER CONFIGURATION -- ADMINISTRATIVE TEMPLATES -- WINDOWS COMPONENTS -- BIOMETRICS -- change the following state to ENABLED :
"Allow the use of biometrics"
"Allow users to logon using biometrics"
"Allow domain users to log on using biometrics"

Restart Windows. 

Works on Windows 10 Version 1706 (OS Build 14393.187)

Monday, September 12, 2016

RSAT & Language Pack for Windows 10 Anniversary Update

RSAT for Windows 10 is available for download at https://www.microsoft.com/en-us/download/details.aspx?id=45520 ( or search for RSAT for Windows 10).

Unfortunately, even though RSAT successfully installed (it only takes few seconds), Remote Server Administration Tool is just not available for use on Windows 10 Anniversary Update. Thanks to the post from Sysadmin Tips, the problem is due to Language Pack. The link to download Windows 10  Anniversary Update Language Pack is available on this post, thank to Winaero.  Steps to install Language Pack, follow Sysadmin Tips post.

Saturday, October 4, 2014

Samsung Bluetooth Headset Factory Reset

Had this little fella Samsung Bluetooth Headset mic not working for sometime and was about to dump it off, then I decided to reset it to factory settings. Miraculously it works.

Factory reset steps:

1. Turn off the device.
2. Hold down both volume keys and hold talk button for 5 seconds
3. Turn on the device
4. If pairing is needed, press talk button for 3 seconds. Start pairing process.

Wednesday, September 24, 2014

A system restart is pending, you must restart the computer before installing IBM i Access

Message box keep appearing stating " A system restart is pending, you must restart the computer before installing IBM i Access ... "

Workaround for this :

1. Backup Windows Registry Key

2. Navigate to  HKEY_LOCAL_MACHINE - SYSTEM - CURRENTCONTROLSET - CONTROL - SESSION MANAGER

3. Delete "PendingFileRenameOperations"



Comment whatever you like, but comment moderation is turned on. It might take some time for your comment to be published.