Configuring a Microsoft SQL Server database

The DB Config utility is used to configure an installation of WS_FTP Server for use with a Microsoft SQL Server database. This utility is located at:

• 32-bit: C:\Program Files\Ipswitch\WS_FTP Server\Utilities\dbconfig.exe
• 64-bit: C:\Program Files (x86)\Ipswitch\WS_FTP Server\Utilities\dbconfig.exe

Note: You must be a local system administrator to use this utility.

It allows you to do three things:

• Migrate a WS_FTP Server installation with a PostgreSQL database to installation with a MS SQL Server 2008/2012 database. Click Migrate on the PostgreSQL Configuration dialog to begin the database migration.
• Configure an existing MS SQL Server 2008/2012 database for use with WS_FTP Server.
• Migrate from one MS SQL Server installation to another.

Note: Before using this utility, you must enable remote connections to the Microsoft SQL database server. For instructions on how to enable remote connections to a Microsoft SQL Server database server, see http://support.microsoft.com/kb/914277.

To perform a migration or to modify the present configuration, enter these fields:

• Server name. Enter the server name that identifies your MS SQL Server installation.
• Port. Enter the port on which the MS SQL Server database server is listening for connections.
• Authentication. WS_FTP Server presently supports SQL Server Authentication only.
• User name. The name for the SQL Server user who will seek authentication.
• Password. The password for the SQL Server user who will seek authentication.
• Network protocol. WS_FTP Server presently supports TCP/IP network protocol only.

Note:If you change these fields to point to a different SQL Server database, you will get a second dialog asking you to enter the new host name, administrator, and password.

After clicking OK, the Migrating from PostgreSQL to MS SQL Server dialog opens. This dialog displays entries from the install log file, indicating migration progress. If the log indicates that all operations were successful, the MS SQL Server migration is complete. The migration application will restart the WS_FTP Server, SSH Server, web server, and Ipswitch Notification services.

If you initiate a SQL Server migration and the server you point to already includes a WS_FTP server database, a Database Exists dialog opens. You will then have the option to Update the connection string only, which will preserve the existing SQL Server database's contents and simply update the connection string, or Overwrite the existing database and update the connection string, which will erase all data in the present SQL Server WS_FTP server database in addition to updating the connection string.

If the database server you are connecting to does not already contain a database for WS_FTP Server, the Create Host dialog opens. This dialog is used to create the WS_FTP Server database. The WS_FTP Server database requires at least one host, which the information you provide is used to create.