Archive for July, 2018

How to Factory Reset Windows 10 from Settings App

July 20th, 2018 by Admin

If your Windows 10 computer starts to run slow or crash frequently, an easy solution is to simply reset your PC to factory default that will quite often solve the issue. This tutorial will walk you through all the steps necessary to perform a factory reset of Windows 10 from the Settings app.

How to Factory Reset Windows 10 from Settings App

Press Windows + I to launch the Settings app, then click Update & Security.

In the left pane, select the Recovery tab. In the right pane, click Get started under the “Reset this PC” heading.

You’ll see a blue dialog box that gives you two choices:

  • Keep my files – This option will remove all apps and settings but keep your personal files intact.
  • Remove everything – This option will format / erase your hard drive so you’ll lose all files and apps.

Keep My Files

If you’ve chosen the “Keep my files” option, it will not only remove all your apps installed from Windows Store, but also uninstall the programs shown on the screen. Click Next to confirm.

The final step is to click on Reset. Your PC will then reboot automatically and begin the factory reset process.

Remove Everything

If you’ve chosen the “Remove everything” option, the next screen will let you choose to remove everything from the drive where Windows is installed, or all drives connected to your PC.

After choosing the drive, you will be asked to “Just remove my files” or “Remove files and clean the drive“. The second option will securely erase your drives and make your files unrecoverable, and it’s a good option if you plan to sell or give away your PC. If you keep the computer, choose the first option for speed.

This is your last chance before your computer is wiped. Click on Reset and Windows will then restart and begin the factory reset process immediately.

That’s it!

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.

  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

    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.