Archive for the ‘Windows’ Category

Stop BackupExec failing on corrupt files

I expect there will be a flag for this in future versions, but for now regedit is needed: HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\Backup Exec\Engine\Backup [For versions 9x and 10x] HKEY_LOCAL_MACHINE\SOFTWARE\SYMANTEC\Backup Exec for Windows\Backup Exec\Engine\Backup [For versions  11x and 12x] On the menu bar, select Edit | Add Value In the Value name field, type in “Fail Jobs On Corrupt […]

IIS File Upload Limit

By default IIS sets the upload filesize limit to a measly 200KB.  To edit this you need to enable direct metabase editing in IIS, then edit c:\windows\system32\inetsrv\Metabase.xml .  You need to modify the MaxRequestEntityAllowed which is in bytes.  Restart IIS.

Disable Data Execution Prevention (DEP) in Windows 2003

In Windows, right click on My Computer -> Properties -> Advanced -> Startup and recovery -> Setting -> Edit and change /NoExecute=…  to  /NoExecute=AlwaysOff You will need to reboot for changes to take effect.

Plesk for Windows MySQL Access

Plesk uses two Mysql servers. One for clients databases (port 3306) and second server for Plesk databases (8306). You can connect to Plesk DB using the following command: %plesk_dir%\mysql\bin\mysql.exe -uadmin -pPlesk_admin_passwd -P8306 “C:\Program Files\Parallels\Plesk\Databases\MySQL\bin\mysql.exe” -uadmin -pPlesk-admin_passwd -P8306 Plesk-admin_passwd = “C:\Program Files\Parallels\Plesk\admin\bin\plesksrvclient.exe” -get However if you want to connect to Clients’ Mysql Server you should use […]

Convert SSL from pem to pfx

Convert an SSL certificate from Apache pem to IIS pfx format. Copy the private key and certificate parts, from the PEM to their own files. Then: openssl pkcs12 -export -out ssl.pfx -in ssl.crt -inkey ssl.key This gave me a .pfx file i could import into IIS. If it’s an EV SSL, you can add the […]

MSSQL Express Scheduled Backups

The Express edition of SQL server lacks automated scheduled backup functionality.  The following script will back up your databases.  It retains them for 7 days but can be easily edited: Create a directory called c:\SQLBackup and go into it Create a backup.sql file: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for […]

Identifying Rogue Processes in IIS

Bring up a command prompt and execute: iisapp.vbs This gives you a mapping of process id to application pool.  Next bring up the task manager and identify the process that you are interested in.  If process ids are not currently shown, go to the view menu, select Choose Columns and tick PID. You should now […]

RDP keep console session

To get the console session by remote desktop on a server remotely to guarantee you get the same session every time: mstsc /v: 192.168.0.111:3390 /console Some RDP managers also have a console flag built in.

Exchange mailstore full

Why does every Exchange admin have to find out the hard way that there is a limit to the database size (16GB for 2000, 75GB for 2003 I think). The chances are that it isn’t actually full of data, just very very fragmented.  I’ve reduced a 75GB file to around 20GB.  To defrag it: Dismount […]

Convert SSL from pfx to pem

Convert an SSL certificate from IIS pfx to Apache pem format: # Export the private key file from the pfx file openssl pkcs12 -in filename.pfx -nocerts -out key.pem # Export the certificate file from the pfx file openssl pkcs12 -in filename.pfx -clcerts -nokeys -out cert.pem # This removes the passphrase from the private key so […]