Wednesday, December 16, 2009

Alteration in Terminal Server's listening port

It is a well-known fact that TCP port 3389 is used by Terminal Server and Windows 2000 Terminal Services for client connections. Alteration in this port is not recommended by Microsoft. But you can change this port. You have to perform this task carefully, otherwise you will face serious problems.

You have to give more concentration while modifying the registry. If you want to change the default port, then you have to follow these steps:

You start with the task of running Regedt32 and go to this key, HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp. Then you have to find the port number subkey and notice the value of 00000D3D, hex is for 3389. After this, you have to change the port number in Hex and save the new value.

If you want to change the port for a particular connection on the Terminal Server, then follow these steps:

You have to run Regedt32 and go to this key, HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Terminal Server\WinStations\connection. After this, you have to find the port number subkey and notice the value of 00000D3D, here hex is for 3389. Then you have to change the port number in Hex and save this new value.

After performing this, you have to make alteration in the Port on the Client Side. Follow these steps to perform this:

You have to open Client Connection Manager. Then on the File menu, click on New Connection and then create the new connection. After executing the wizard, you will view a new connection listed there. Then you have to ensure that new connection is highlighted. After this, on the File menu, click Export. Then you have to edit the .cns file using Notepad. You have to make modifications in the server port, Server Port=3389 to Server Port= new port number, that you had specified on Terminal Server. Now import the file back into Client Connection Manager. Then you will be demanded to overwrite the current one. If it has the same name, then overwrite it. In this way, you will receive a client that has the correct port settings to match your Terminal Server settings.

Monday, December 7, 2009

Microsoft SQL Backup

You are aware of the problems like disk failure, system crashes and many more. Due to these problems your important data will get lost. In this situation, you will be the loser. So, to avoid these problems you have to take a backup of your data. Microsoft has developed the Microsoft SQL Server, a widely used database management system. Handy Backup gives a fast and efficient way to backup Microsoft SQL Server database. Nowadays, many businesses whether small or large are using the databases stored on SQL servers. So, it is important to backup the SQL database.

Accuracy and reliability of Microsoft SQL (MSSQL) backup - Handy Backup uses Microsoft API but other backup tools use the ODBC protocol to backup MSSQL database. Handy Backup permits you to backup MSSQL database with all views, indexes, stored procedures and other data. You do not have to interrupt your SQL server services while performing MSSQL backup with Handy Backup. You can take backup of MS SQL Server 2005, MS SQL Server 2000, MS SQL Server 2008 with Handy Backup. Handy Backup can automatically recognize all SQL server databases available on your computer and also display them. It has many options which facilitate you in compressing your MSSQL backup with an integrated ZIP-compressor with 10 levels. You can also schedule the backup for a time period that you desire. You can save MS SQL backup on any storage media. These storage devices can be DVD, external drives and many more. So, it can be deducted that Handy Backup is a perfect tool for MSSQL backup because it allows you to always feel safe about your data.