Archive for the ‘Tips & Tricks’ category

Easy Ways to Open Calculator in Windows 10

July 19th, 2018 by Admin

How can I create a keyboard shortcut to open the Calculator? Calculator is the built-in app included in all versions of Windows, which lets you quickly calculate the numeric value of expressions. There are many easy ways to open Calculator in Windows 10 — use the Start menu, Cortana, Command Prompt, keyboard shortcut, or pin Calculator to the taskbar.

Method 1: Open Calculator via Run or Command Prompt

Press the Windows key + R together to open the Run box, type calc and hit Enter. The Calculator app will run immediately.

You can also open Calculator by executing the calc command in a Command Prompt window.

Method 2: Open Calculator via Start Menu

Click the Start button. Scroll down to the “C” section in the All Apps list, and you can then access the Calculator program.

In Windows 7 or earlier versions, you can find the Calculator program under the the Accessories folder on the Start menu.

Method 3: Open Calculator via Cortana Search

Click the Cortana Search box in the taskbar, type calc and you can open Calculator from the search result.

If Calculator is one of the most frequently used apps, you can right-click on it and pin it to the Start Screen or the taskbar.

Method 4: Create a Desktop Shortcut to Open Calculator

  1. Right-click any empty space on your desktop and then select New -> Shortcut.

  2. Paste the following into the location box an click Next.

    %WinDir%\System32\calc.exe

  3. Give a name for the Calculator shortcut, and click Finish.

  4. From now on, you can use the newly-created desktop shortcut to open Calculator.

Method 5: Create a Keyboard Shortcut to Open Calculator

Before getting started, make sure you have created a desktop shortcut for Calculator using the Method 4 above.

  1. Right-click the Calculator shortcut on your desktop, and then select Properties.

  2. A Properties window will open. Under the Shortcut tab, click the textbox next to Shortcut key and then tap ‘C‘ on your keyboard. The new shortcut will appear as Ctrl + Alt + C. Click Apply and then OK.

  3. Now, you can press the Ctrl + Alt + C keyboard combination to quickly open Calculator in Windows 10.

4 Ways to Make Your Program Always Run as Administrator

July 18th, 2018 by Admin

Could I force a program to always run as an administrator? Is it possible to automatically open a batch file as admin when you double-click on it? Many old programs need to be run as administrator in order to function properly on Windows 10 / 8 / 7. In this tutorial we’ll show you 4 methods to make your program always run as administrator by default.

Method 1: Always Run as Administrator from Program Shortcut

  1. Right-click on the shortcut of your program, and then select Properties from the context menu.
  2. In the Properties window, select the Shortcut tab, and click on the Advanced button.

  3. Check the box next to Run as administrator and click OK.

  4. Every time you double-click the shortcut it will always run your program as administrator by default.

Method 2: Always Run as Administrator in Compatibility Mode

  1. Right-click on your application or its shortcut, and then select Properties in the context menu.
  2. Under the Compatibility tab, check the “Run this program as an administrator” box and click OK.

  3. From now on, double-click on your application or shortcut and it should automatically run as administrator.

Method 3: Always Run as Administrator Using Registry Hack

  1. Open the Registry Editor and browse to the following key:
    HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers

    Right-click blank area in the right pane, and then select New -> String Value.

  2. Rename the String value to the full path of the program you want to always run as administrator, and then double-click it to modify.

  3. Type ~ RUNASADMIN in the “Value data” field and click OK.

  4. Close Registry Editor. The program will now open in administrator mode when you double-click it.

Method 4: Create a Batch to Always Run Program as Administrator

  1. Open Notepad (or your favorite text editor), copy and paste the following batch script:
    @echo off :: BatchGotAdmin :------------------------------------- REM --> Check for permissions >nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system" REM --> If error flag set, we do not have admin. if '%errorlevel%' NEQ '0' ( echo Requesting administrative privileges... goto UACPrompt ) else ( goto gotAdmin ) :UACPrompt echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs" set params = %*:"="" echo UAC.ShellExecute "C:\Program Files (x86)\Top Password\ISO2Disc.exe", "", "", "runas", 1 >> "%temp%\getadmin.vbs" "%temp%\getadmin.vbs" del "%temp%\getadmin.vbs" exit /B :gotAdmin pushd "%CD%" CD /D "%~dp0" :--------------------------------------

    The above script will make the ISO2Disc utility to always run as administrator. You need to replace the full path of ISO2Disc with your desired application.

  2. Next, save the file by clicking File -> Save. Give it any name you like, but replace the default .txt file extension with the .bat extension.

  3. Now, double-click the batch file and it will then launch your program as administrator.

Disable Internet Explorer Enhanced Security Configuration in Windows Server 2016 / 2012

July 17th, 2018 by Admin

Internet Explorer Enhanced Security Configuration (IE ESC) is enabled by default, which can secure Windows Server against browser-based attacks. However, when you visit a website you trust, you’ll get security warning all the time that asks you to add every new URL to the IE trusted sites zone.

This feature can drive me insane. In this tutorial we’ll show you how to disable Internet Explorer Enhanced Security Configuration (IE ESC) in Windows Server 2016 / 2012.

How to Disable Internet Explorer Enhanced Security Configuration?

  1. Click the Start Button and launch Server Manager.

  2. In the Server Manager dashboard, click on Local Server on the left side. In the right pane, click the On link next to IE Enhanced Security Configuration.

  3. Select Off for both Administrators and Users, and click OK.

  4. Restart your Internet Explorer and you can now visit all websites without being prompted to add them to IE trusted sites zone.

How to Change Product Key for SQL Server 2017 / 2016 / 2014 Installation

July 16th, 2018 by Admin

Do you want to change SQL Server license key on production server? How to upgrade your SQL Server evaluation edition to the Standard or Enterprise edition? In this tutorial we’ll walk you through the steps to change product key for any existing SQL Server 2017 / 2016 / 2014 installation, without having to reinstall.

How to Change Product Key for SQL Server Instance?

  1. Click the Start button, and then navigate to the “SQL Server [version]” folder. Expand it and you can launch the SQL Server Installation Center.

    Another way of opening SQL Server Installation Center is to run setup.exe from SQL Server installation media.

  2. Under the Maintenance tab, click on Edition Upgrade as shown below.

  3. Enter the new product key and click Next.

  4. Accept the license term and click Next to proceed.

  5. Select the existing SQL Server instance for which you are going to change product key.

  6. After checking all rules for edition upgrade, review the summary information and click Upgrade to begin the upgrading process.

  7. The upgrade process will be done in a minute or two.

    Now you’ve successfully changed the product key for the SQL Server instance running on your machine.

3 Ways to Check Which Version or Edition of SQL Server is Running

July 15th, 2018 by Admin

In this tutorial we’ll show you 3 ways to check if a SQL Server instance is licensed and determine which version or edition of SQL Server is installed on your computer.

Method 1: Check SQL Server Version Using T-SQL

  1. Open a Command Prompt. Connect to your SQL Server instance by executing this command:
    SQLCMD -S server_name\instance_name

    Where server_name is your server name and instance_name is the SQL instance name. If you’re trying to connect to the default instance, just type SQLCMD.

  2. Next, run the following T-SQL query:
    select @@version
    go

    This will display the version and license type of your connected SQL Server instance. If you have multiple instances, use the same method to check each instance.

Method 2: Check SQL Server Version Using SQL Server Installation Center

  1. Click the Start button, then expand the SQL Server folder and launch SQL Server Installation Center.

  2. Select Tools in the left-hand navigation area of SQL Server Installation Center. On the right side, choose Installed SQL Server features discovery report.

  3. It will create a report of the installed SQL Server instances, and you can open it with your Web browser. With this report you can determine your SQL Server version and edition, service pack level and license type.

Method 3: Check SQL Server Version Using SQL Server Management Studio

  1. Open up SQL Server Management Studio and connect to your SQL Server database. Right-click the server in Object Explorer, and then click Properties.

  2. On the General page, look for the Product field, which will display the version of SQL Server that is running on your machine.

That’s it!

Find Lost Product Key from SQL Server 2017 / 2016 / 2014 Instance

July 14th, 2018 by Admin

Lost SQL Server 2016 product key from an installed instance? When you need to reinstall SQL Server or move the license to a new machine, you can use KeyFinder Plus to decrypt and locate SQL Server product key stored in the Windows registry. This tutorial will walk you through the steps to find SQL Server 2017 / 2016 / 2014 product key from an existing instance.

How to Find SQL Server Product Key from an Installed Instance?

  1. To begin with, download and install KeyFinder Plus on the server running a SQL Server instance.
  2. The program comes with a neat and pretty simple interface. Just click on the Start Recovery button and you’ll see a list of options for recovering product keys from local machine, unbotable system or network PC.

  3. Once you have chosen the first option, it will quickly find out product keys for all editions of SQL Server, Windows, Office and other softwares installed on your local computer.

    If you want to write down or print out the product keys so you can access them later, click on the Save To File button.

  4. We’d recommend saving to the desktop for easy access.

    Afterwards, you can open that file with your preferred text editor and print it out.

Finding lost SQL Server product key is as simple as that!

Forgot Linux Bash Password in Windows 10? How Can I Reset?

July 12th, 2018 by Admin

How can I reset the Bash password of Ubuntu Linux shell in Windows 10? When you install Ubuntu Bash shell on your Windows 10 PC, Windows will prompt you to create a UNIX user account. If you’ve forgotten the password, this tutorial can help you reset it easily.

How to Reset Linux Bash Shell Password in Windows 10?

  1. To get started, open a regular Command Prompt (or PowerShell). Just type cmd in Cortana search box on the taskbar, and you can then click “Command Prompt” from the result.

  2. Next, run the following command to set “root” as the default user for Linux Bash shell.
    ubuntu config --default-user root

    If you’re running Windows 10 Creators update or earlier, you can change the default Bash user to “root” by running this command:
    lxrun /setdefaultuser root

  3. The next time you open the Linux Bash shell, it will log you as root without asking a password. You can use the passwd command to set up a new password for any UNIX user account.
    passwd user_name

  4. The last step is to reset your default user back to your normal Linux account. Type this in the Command Prompt:
    ubuntu config --default-user user_name

    or execute this command:
    lxrun.exe /setdefaultuser user_name

    That’s it!

Server 2016: Your current security settings do not allow this file to be downloaded

July 10th, 2018 by Admin

When you try to download any program from trusted sources, Internet Explorer might still give you a security alert saying “Your current security settings do not allow this file to be downloaded“, even if you’re logged into Windows Server 2016 as administrator.

The problem is caused by Microsoft tightening up security since Windows Server 2008, and file downloads are disabled by default. In this tutorial we’ll show you how to fix the “Your current security settings do not allow this file to be downloaded” error in Windows Server 2016.

How to Fix “Your current security settings do not allow this file to be downloaded”?

  1. To get started, you need to access the Internet Options. After Internet Explorer is launched, click the gear icon on the top right corner, and then select “Internet options” in the drop-down menu.

  2. Go to Security tab. Select the Internet zone and click the Custom level button.

  3. In the Security Settings window, scroll down to the Downloads section and enable File download. Click OK.

  4. Click Yes to confirm you want to make the change for the Internet Zone.

  5. Restart Internet Explorer and you should be able to download programs without getting the above security alert any longer. That’s all there is to it.

2 Ways to Enable Remote Assistance in Windows 10 / 8 / 7

July 5th, 2018 by Admin

How do I enable Remote Assistance from the command line? Windows Remote Assistance allows someone else to temporarily take control of your PC over the Internet in order to fix a problem for you. This tutorial will show you how to enable Remote Assistance and allow it through firewall in Windows 10 / 8 / 7.

Method 1: Enable Remote Assistance in System Properties

  1. Right-click on the “This PC” ( or “My Computer”) icon on your desktop and then click Properties.

  2. On the left side of the System window, click Remote settings.

  3. In the “System Properties” window, go to the Remote tab and make sure the “Allow Remote Assistance connections to this computer” check box is checked. Next, click Advanced.

  4. If you clear the “Allow this computer to be controlled remotely” checkbox, the helpers can see your screen, but not take control of your PC.

  5. Click OK to save your changes.

Method 2: Enable Remote Assistance Using Registry Editor or Command Line

  1. Open the Registry Editor and browse to the following registry key:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Remote Assistance
  2. In order to enable Remote Assistance, double-click the DWORD entry fAllowToGetHelp in the right pane, and set its value data to 1. If you want to disable Remote Assistance, just change it to 0.
  3. Next, double-click the DWORD entry fAllowFullControl and set its value to 1 if you want to allow the person offering the assistance to take full control of this PC.

  4. When you’re done, close Registry Editor.

If you want to make the same registry changes with Command Prompt, just run the following commands to enable Windows Remote Assistance:

reg add "HKLM\System\CurrentControlSet\Control\Remote Assistance" /v fAllowToGetHelp /t REG_DWORD /d 1 /f
reg add "HKLM\System\CurrentControlSet\Control\Remote Assistance" /v fAllowFullControl /t REG_DWORD /d 1 /f

Allow Remote Assistance Through Firewall

What port should I open to allow Windows Remote Assistance? Enabling Remote Assistance using the above methods will not configure Windows Firewall with the appropriate ports to allow remote connections. In order to allow Remote Assistance through Windows Firewall, type the following into an elevated Command Prompt:

netsh advfirewall firewall set rule group="remote assistance" new enable=Yes

That’s it!