Archive for the ‘Others’ category

2 Ways to Configure Windows Firewall to Allow SQL Server Access

May 2nd, 2016 by Admin

By default, Windows Firewall doesn’t allow inbound / outbound requests for SQL Server. If you try to connect to a SQL Server instance from network, you might get the error saying “The server was not found or was not accessible”. In this tutorial we’ll show you 2 ways to configure Windows Firewall to allow SQL Server access.

Method 1: Allow SQL Server Access Through Control Panel

  1. Open Control Panel in Large icons or Small icons view, click on Windows Firewall.

    windows-firewall

  2. Click the link “Allow a program or feature through Windows Firewall” on the left of window.

    allow-app-through-firewall

  3. You will now see a list with all the apps which are allowed to communicate through the Windows Firewall. To change the rules, you need to click the Change Settings button. The list of rules will no longer be gray and you will be able to edit it.

    change-firewall-settings

  4. Click the “Allow another program…” button.

    add-another-program

  5. From the “Add a Program” window, click the Browse button.

    browse-program

  6. Navigate to the installation path for your SQL Server instance and select sqlservr.exe, and click Open. In my example, the location is C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe.

    sqlserv

  7. You’ll back to the “Add a Program” window and see SQL Server is added to the list. Click the Add button.

    add-sql-server

  8. SQL Server now appears in the list of Allowed programs and features. You can check any of the location types: private or public. When done, press OK.

    allowed-program

Method 2: Allow SQL Server Access Through Command Prompt

  1. Open an elevated Command Prompt.
  2. You can run the Netsh advfirewall command to open all ports for SQL Server connections. Assuming the path of your SQL Server service is C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe, copy / and paste the following commands in the Command Prompt, press Enter after each.

    netsh advfirewall firewall add rule name="SQL Server TCP" protocol=tcp dir=in action=allow program="C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" enable=yes profile=any localip=any localport=any remoteip=any remoteport=any

    netsh advfirewall firewall add rule name="SQL Server UDP" protocol=udp dir=in action=allow program="C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" enable=yes profile=any localip=any localport=any remoteip=any remoteport=any

    advfirewall

  3. When it’s done, you’ve successfully opened up all ports to allow SQL Server access through Windows Firewall.

How To Shrink & Expand Partition in Windows 10 / 8 / 7

April 25th, 2016 by Admin

Keep getting low disk space on C:\ drive even if you’ve deleted all files you can delete? There is no spare partition for another operating system? In this tutorial we’ll show you how to use the built-in Disk Management to shrink & expand partition in Windows 10, 8 and 7.

Part 1: Open Disk Management

To access Windows build-in Disk Management tool, just press the Windows key + R to open the Run box. Type diskmgmt.msc and hit Enter. This will open the Windows Disk Management utility. From there you can resize (shrink or expand) your hard drive partition without data loss.

disk-management

Part 2: Shrink Partition

Need to create a new partition but you don’t have unallocated space? Just shrink an existing partition to free up space from which you can create a new partition. Here’s how to shrink a partition:

  1. Right-click the partition you want to shrink (C: in our example) and select Shrink Volume.

    shrink-volume

  2. Windows will take a moment to query the volume for available shrink space. Enter the amount of space you want to shrink. For example if want to free up 15GB space, enter 15000 Mb (1000 MB = 1 GB) in the text box. Next click Shrink.

    space-to-shrink

  3. When the process is complete, you will see a new unallocated partition right next to your shrinked partition.

Part 3: Expand Partition

Run out of space on one of your Windows partitions? You can also expand disk partitions, as long as there is free (unpartitioned) space available only after the partition you’re trying to expand. Here’s how to expand a partition:

  1. Right-click the partition you want to expand (C: in our example) and select Extend Volume. Note that the Extend Volume option might be greyed out when there is no unallocated space right after your selected partition.

    extend-volume

  2. Now when the Extend Volume Wizard opens, click Next.

    extend-volume-wizard

  3. It will select the maximum number of unallocated space itself. But you can set any amount yourself too, keep in mind that it is calculated in MB not GB. After you are done here, click Next.

    select-disk-to-extend

  4. You’ll see a brief summary of the changes. Click Finish to apply them. Now you’ll see your partition is larger and the unallocated partition has been merged.

    complete-extend-wizard

How to Disable Caps Lock Key in Windows and Mac

April 14th, 2016 by Admin

“Whenever I type, my baby finger hits the Caps Lock key and all my typing ends up in caps. I want to disable it completely and just use the Shift key for capitals. How do I disable the Caps Loks key in Windows 10? Please help!”

Without the Caps Lock key, you can still type the letter you want to capitalize by holding down the Shift key. Pressing the Shift key once is much more efficient than pressing the Caps Lock key twice. If you don’t need to use the Caps Lock key, you can disable it permanently. In this tutorial we’ll show you how to disable Caps Lock key in Windows 10/8/7/Vista/XP and Mac OS X.

Part 1: Disable Caps Lock in Windows 10/8/7/Vista/XP

There is no built-in settings available in Windows that allow you to disable Caps Lock key, so we have to use a registry hack to map the Caps Lock key to doing nothing. Follow these steps:

  1. Press the Windows key + R to open the Run box. Type notepad and press Enter.
  2. Copy the lines below and then paste them into the NotePad:
    Windows Registry Editor Version 5.00
    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout]
    "Scancode Map"=hex:00,00,00,00,00,00,00,00,02,00,00,00,00,00,3a,00,00,00,00,00

    notepad

  3. Click the File menu and select Save as. Select “All Files” from the “Save as type” drop-down box. Type the file name as Disable_Caps_Lock.reg. Click Save.

    save-as

  4. Double-click the .reg file, or right-click on it and select “Open with” -> “Registry Editor“. If prompted by UAC, click on Yes.

    open-with-registry-editor

  5. Registry Editor will confirm if you want to import the registry settings in your .reg file, click Yes.

    import-into-registry

    Now log out (and back in) or reboot to make this registry trick to take effect.

If you want to enable the Caps Lock key again, open the Registry Editor and navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout, then delete the Scancode Map entry entirely.

enable-caps-lock

Part 2: Disable Caps Lock in Mac OS X

It’s pretty easy to actually turn the Caps Lock key off if you’re using a Mac. Here’s how:

  1. Click the Apple icon in the top-left corner of your desktop, then select System Preferences from the drop-down menu.

    system-preferences

  2. Click on the Keyboard icon to launch the preferences pane.

    keyboard-utility

  3. Click the Modifier Keys button in the bottom-right corner.

    modifier-keys

  4. A new window will slide down with a setting for the Caps Lock key at the top. click on the drop-down menu next to the Caps Lock Key title, and choose No Action.

    disable-mac-caps-lock

  5. Click OK. Now, whenever you hit the Caps Lock key by mistake, nothing will happen.

2 Ways to Recover iTunes Backup Password on Mac OS X

April 7th, 2016 by Admin

“Hi! I’ve forgotten the password for the local iTunes backup on Mac OS X. How do I reset or recover my iTunes password? Please help!”

Forgotten iTunes backup password is a common problem, because the password is rarely used until we need to restore iPhone or iPad from iTunes backup. What should you do if you’ve lost the password for your iTunes backup? In this tutorial we’ll show you two simple ways to recover iTunes backup password on Mac OS X.

Method 1: Recover iTunes Backup Password with Keychain Access on Mac

The Keychain Access application is Mac OS X’s built-in password manager. It stores a wide variety of passwords for email account, website, servers, itunes backup, etc. When you change or reset the password for iTunes backup, the password will also be stored in Keychain if you’ve checked the “Remember this password in my keychain” option.

If your iTunes backup password is stored in Keychain, you can recover it easily by following these steps:

  1. On your Mac, go to /Applications/Utilities/ and open Keychain Access app.
  2. Under the Keychains section on the left-hand side of the app, select login. You should now see a list of websites and applications that use Keychain Access to store login information. Scroll down through this list until you get to the login item named “iPhone Backup“.

  3. Double-click the “iPhone Backup” login item. This will open a new window with more details about your iTunes backup account. From this screen, check the “Show password” checkbox.

  4. You will be prompted to enter your Mac OS X user password to authenticate. Once entered, click the Allow button to continue.

  5. Once that’s done, you’ll return to the previous window showing all the details including the password in plain text. Make a note of it and ensure it’s kept somewhere secure so you can remember it the next time.

Method 2: Recover iTunes Backup Password with iTunesKey

What to do if your forgotten iTunes backup is not stored in Keychain access? Is there any hope? Luckily there is a handy iTunes password recovery tool – iTunesKey, which allows you to recover / decrypt iTunes backup password. But this program needs to run from within Windows. So if your iTunes backup is created and saved in Mac OS X, simply transfer the Manifest.plist file to a Windows-based PC and you can then use iTunesKey to recover your password. Here’s how:

  1. To get started, we need to find the iTunes backup location in Mac OS X. Simply hit Command + Shift + G on keyboard to open the Go To Folder screen. Type the following path and click Go.

    ~/Library/Application Support/MobileSync/Backup/

  2. A Finder window will open and you can see a folder named with the UDID (unique device identifier) of your iPhone. Open that folder and copy the Manifest.plist file to your external USB thumb drive.

  3. Attach the USB thumb drive to a Windows-based computer and run the iTunesKey application. When iTunesKey launches, click on the button to select the Manifest.plist file.

  4. Select one of the recovery methods: Brute-force attack, Mask attack and Dictionary attack, and click Next. Follow the instructions to perform the password cracking. After your iTunes backup is recovered, write it down so you’ll never forgot it.

Reset Lost Admin Password on Dell PowerEdge with RAID

April 6th, 2016 by Admin

Forgot Windows Server admin password for your Dell PowerEdge server? Most of password recovery Live CDs lack the RAID drivers so your hard drive won’t show up after booting. In this tutorial we’ll walk you through the steps of resetting lost admin password on Dell PowerEdge with PCUnlocker Enterprise.

What You’ll Need:

  • A USB thumb drive (or a blank CD)
  • The ISO image of PCUnlocker Enterprise – You can try the trial version before purchasing the full version
  • Dell RAID drivers – Click here to download the RAID drivers for Dell PowerEdge, or check out this article on how to download / extract Dell drivers directly from Dell official website
  • A working PC for making the Live CD/USB

Reset Lost Admin Password on Dell PowerEdge with RAID Controller

  1. Before getting started, use a working PC to download and install ISO2Disc, a free utility that specifically designed to create bootable CD / USB drive from ISO image.
  2. Launch ISO2Disc and click on Browse button. Select the ISO image of PCUnlocker Enterprise in your PC. Select “Burn to USB Flash Drive” and click on Start Burn.

    After the burning is complete, copy the RAID driver files you’ve downloaded and paste them in the root directory of your USB drive.

  3. Once you have your bootable USB drive, plug it in to a USB port on your Dell PowerEdge server. Power on the server and quickly and repeatedly press the F2 key to enter the BIOS Setup.
  4. In the BIOS menu, scroll down to the option for “USB Flash Drive Emulation Type“. Use the space bar to change this to “Hard disk“.
  5. Then go to the Boot Sequence option and press Enter. The USB device will now appear as a hard drive in your boot options. Use the space bar to enable or disable boot options and the + or – keys to change their order in the boot sequence.

    dell-poweredge-boot-order

  6. After making these changes in your BIOS settings, press ESC and choose “Save and Exit“. Your server will reboot from your USB drive.
  7. Wait for the PCUnlocker program to launch. The program might prompt you to select the SAM file because it can’t recognize your hard drive. So you have to load the RAID driver on the fly. Click on the Options button at the bottom of the screen, and then select “Load IDE/SCSI/SATA/RAID Driver“.

  8. When the file open dialog appears, choose the RAID driver setup .inf file stored on your USB drive. Click Open.

    dell-poweredge-raid

  9. Once the driver is loaded successfully, you’ll see a list of user accounts stored in the Windows SAM file. Choose the administrator account and click on Reset Password button to remove the password.

  10. Reboot your server and unplug the USB thumb drive, you can then log back in to your Windows Server admin account without password. Done!

How to Fix “The signature of this program is corrupt or invalid”

April 3rd, 2016 by Admin

When you download a software with Microsoft Edge or Internet Explorer, you might receive the error message saying “The signature of this program is corrupt or invalid“.

edge-warn-signature-corrupt

ie-warn-signature-corrupt

Recently we’ve also heard of our customers having this issue when downloading the Lock My Folders program in Windows 10, so we spend lots of time trying to reproduce this issue. We finally got to the bottom of the issue (we believe).

The signature was never corrupt or even invalid. Microsoft released a cumulative security update KB3140745 for Windows 10 that deprecated support for SHA1 code signing certificate. Any programs signed with SHA1 certificate after January 1st, 2016 will be flagged as an invalid signature. In this tutorial we’ll explain how to check if your downloaded program is signed with SHA1 or not, then discuss the methods to get around the download issue.

How do I know if a program is signed with SHA1?

  1. Right-click on your program and select Properties.
  2. Click on the Digital Signatures tab.
  3. Select the signature and click on the Details button.
  4. Click the View Certificate button.
  5. Click the Details tab.
  6. Look at the Signature hash algorithm.

    sha1-certificate

Methods to fix “The signature of this program is corrupt or invalid”

If you are the software developer, just contact the CA to re-issue or replace your SHA1 certificate with a new stronger SHA2 certificate, then sign your program with SHA2 certificate and the issue will be resolved.

If you download software from a reliable website and get the “The signature of this program is corrupt or invalid” error message, here are 3 ways to work around this problem:

  • When you see the a pop-up message that says the signature is corrupt or invalid, click on View downloads button.

    edge-warn-signature-corrupt

    Next right-click on the file in downloads and choose Run anyway.

    edge-run-anyway

    If Windows 10 Smart Screen displays a warning that the app cannot be recognized, click More Info and click Run Anyway to install.

  • Uninstall the Windows update that causes this issue. I can reproduce the problem by installing KB3140745 on Windows 10. I then uninstall this single update and it fixed the problem. If you’ve turned on automatic updating, you can block that specific update in Windows 10 so it won’t be installed any longer.
  • Only the browsers from Microsoft block SHA1 code signing certificate now. Chrome and Firefox still accepts SHA1 certificate. So you can get around this problem by downloading with Chrome or Firefox browsers.

Fix “You’ve been signed in with a temporary profile” Error in Windows 10 / 8 / 7

March 24th, 2016 by Admin

After you log on to a Windows user account, you may face the temporary profile issue and some of your desktop icons & files are disappeared. A notification pops up in the right bottom corner of the taskbar, saying:

“You’ve been signed in with a temporary profile. You can’t access your files, and files created in this profile will be deleted when you sign out. To fix this, sign out and try signing in later. Please see the event log for more details or contact your system administrator.”

temporary-profile

In Windows 7, the error message looks like:

“You have been logged on with a temporary profile. You cannot access your files and files created in this profile will be deleted when you log off. To fix this, log off and try logging on later. Please see the event log for details or contact your system administrator.”

So I did a quick Google search and it seems that this is a common issue. This problem usually occurs if the user profile was accidentally moved or deleted from the system. Any changes that you make to the current desktop are lost after you log off the system. In this tutorial we’ll explain the step-by-step procedure to fix temporary profile issue in Windows 10, 8 and 7.

How to Fix “You’ve been signed in with a temporary profile” Error?

Before getting started, you need to find the SID (Security Identifier) of your user account that is experiencing the temporary profile problem. To do this, just press the Windows + R keys to open the Run box. Type cmd and press Enter.

cmd

When the Command Prompt launches, type the following command, replacing Tom with the name of your affected account. Press Enter and you’ll see the SID that will be used in steps below.
wmic useraccount where name='Tom' get sid

wmic

After finding the SID, close the Command Prompt. Now we begin to fix the registry settings. Press the Windows + R keys to open the Run box. Type regedit and press Enter.

regedit

When the Registry Editor opens, navigate to the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

Expand the ProfileList subkey, you will see the SID keys for all the users on the machine. As we’ve found the SID of your affected account above, just click that SID key (without .bak), you’ll see the “ProfileImagePath” entry in the right pane that points to a temporary profile.

temp-profile-key

Double-click the ProfileImagePath entry to edit the values data. Type the correct profile path and click OK. If you don’t know the correct profile location, open Windows Explorer and browse to C:\Users. In my example, I want to set the account to use the profile folder named Tom, so I point ProfileImagePath to C:\Users\Tom. If your profile folder was already corrupted or deleted, just delete the SID key.

profile-folder

Next, right-click on your old SID key that is maked as .bak, and then click on Delete.
original-profile-key

That’s it. Log off or restart your computer. Windows will sign in to your account with a local profile instead of a temporary profile, and you will no longer receive the temporary profile error.