Restore MSSQL database using batch script


If you are looking for a tool which can restore the MS SQL DB backup from the production environment to the development environment, this script is just the one that you are after. In my example, the script does the following things: 1) Copy of the latest pro db backup to local. 2) Close all connections of … Continue reading Restore MSSQL database using batch script

Advertisements

WinSCP or Putty authenticates against Microsoft ISA/ TMG


Many companies use Microsoft ISA/ TMG as their enterprise proxy solution. This may work for most cases. But in some scenarios, it does not work well. For example, use WinSCP or Putty behind the proxy AND the proxy requires authentication. ISA/ TMG is mircrosoft technology, it uses NTLM based authentication which is not supported by … Continue reading WinSCP or Putty authenticates against Microsoft ISA/ TMG

Troubleshoot ‘Windows Process Activation Service’ failed to start


I was setting up a IIS test environment for testing the mobile redirection this afternoon. That's a test box which may serve for other purpose as well. For some reason, the WAS service (Windows Process Activation Service) just refused to start with the message 'Error 3: The system cannot find the path specified'. I am … Continue reading Troubleshoot ‘Windows Process Activation Service’ failed to start

Extend ISA/TMG Ports to allow SSH


By default ISA/TMG does not allow outbound SSH traffic. And in the log it shows something like this: To make it work, you have to extend the ISA/TMG ports by adding SSH/22 by using isa_tpr.js. Here is my example:c:\Utils>cscript isa_tpr.js /add SSH 22Microsoft (R) Windows Script Host Version 5.8Copyright (C) Microsoft Corporation. All rights reserved.The Web … Continue reading Extend ISA/TMG Ports to allow SSH

Fail to quiesce a virtual machine while taking snapshot


The issue was firstly caught by TSM. The backup job of a virtual machine failed and the log shows 02/22/2014 04:09:37 ANS4015E Error processing 'virtual-machine-name': unexpected TSM error (115) encountered.My understanding is that the first step of TSM backup is to take a snapshot. So I tried to manually take a snapshot of the running virtual … Continue reading Fail to quiesce a virtual machine while taking snapshot

Block password policy in AD LDS


By default, the AD LDS inherits the password policy from the AD domain. In some scenarios, you may want to block it. Here are two ways to do it:1) Use ADSI Edit tool, and navigate to the 'CN=Directory Service, CN=Windows NT, CN=Services, CN=Configuration, CN={guid}' set 'ADAMDisablePasswordPolicies=1' in the Attributes.2) dsmgmt commanddsmgmt "Configurable Settings" Connections "connect … Continue reading Block password policy in AD LDS