Windows: Generate CSR key with IIS7

This article used to guide you on how to generate CSR(Certificate Signing Request) key from IIS7.

1. Select Start ->¬†Administrative Tools -> Internet Information Services (IIS) Manager or run from Windows Run with command “inetmgr”.
2. In the IIS Manager, choose your server name.
3. In your Middle panel, select Server Certificate.
4. Select on the “Create Certificate Request option”¬†in the right panel.
5. In the Wizard, enter your information like image above.
6. Next, remain the service provider and change the bit length to at least 2048. You are advise to select 2048 and above for better security.
7. Save your certificate.

Enable ActiveSync for Google Apps

ActiveSync is important for today mobile device as it allow your mobile device to get up-to-date messages.

By default, Google Apps do not enable the ActiveSync feature alhtough it is supported by Google Apps.

To enable Google Apps ActiveSync from your account,

1. Log into the Google Apps account.
2. Click on the Mobile Options.

3. Click on “Enable Google Sync” and Save it.
4. You have done it.

To Setup your Mobile device,
1. Use your full Google Apps email address as your user name (e.g. “[email protected]”) rather than just your username (e.g “user”)
2. Use “m.google.com” as the Exchange ActiveSync server name.
3. Enable SSL.

Schedule backup for MSSQL to remote computer

If you familiar with MSSQL maintenance plan and ever configured backup through this tool and you should know that to backup the MSSQL database to remote computer, you have to configure Log On setting from services.

Okay, today we assume that we couldn’t allow to change the setting from Log On setting and wish to set the schedule backup, we could use maintenance tool and batch command to schedule it.

Firstly, create a maintenance plan from MSSQL, then select “Back Up Database Task”. From Database(s) option, select your database name, you may specify the directory that wish to backup. From this article we make it to C:\mssql\backup\.

Next, create a batch file named mssql_backup.bat and insert command as below.

xcopy C:\mssql\backup "\\remote_server\c$\backup" /e /i /h /y

Where remote_server is your remote server name and you would like to place it to C:\backup.

Lastly, create Windows Task Scheduler and configure the mssql_backup.bat to run daily or weekly as your wish.