Preparing to use the SQL Server database

Before you define the database interface and connect to a Microsoft SQL Server database in DataWindow Designer, follow these steps to prepare the database for use:

  1. Install and configure the required database server, network, and client software.

  2. Install the SQL Native Client database interface.

  3. Verify that you can connect to the Microsoft SQL Server server and database outside DataWindow Designer.

Step 1: Install and configure the database server

You must install and configure the database server, network, and client software for SQL Server.

StepsTo install and configure the database server, network, and client software:

  1. Make sure the Microsoft SQL Server database software is installed and running on the server specified in your database profile.

    You must obtain the database server software and required licenses from Microsoft Corporation. For installation instructions, see your Microsoft SQL Server documentation.

    NoteUpgrading from an earlier version of SQL Server For instructions on upgrading to a later version of SQL Server or installing it alongside an earlier version, see your Microsoft SQL Server documentation.

  2. If you are accessing a remote SQL Server database, make sure the required network software (for example, TCP/IP) is installed and running on your computer and is properly configured so that you can connect to the SQL Server database server at your site.

    For installation and configuration instructions, see your network or database administrator.

  3. Install the required Microsoft SQL Native Client software on each client computer on which DataWindow Designer is installed.

    You must obtain the SQL Native Client software from Microsoft. Make sure the version of the client software you install supports all of the following:

    For installation instructions, see your Microsoft SQL Server 2005 documentation.

  4. Make sure the SQL Native Client client software is properly configured so that you can connect to the SQL Server database server at your site.

    For configuration instructions, see your Microsoft SQL Server 2005 documentation.

  5. Make sure the directory containing the SQL Native Client software is in your system path.

  6. Make sure only one copy of the Sqlncli.dll file is installed on your computer.

Step 2: Install the database interface

In the DataWindow Designer Setup program, select the Custom install and select the SQL Native Client database interface.

Step 3: Verify the connection

Make sure you can connect to the SQL Server server and database you want to access from outside DataWindow Designer.

To verify the connection, use any Windows-based utility that connects to the database. When connecting, be sure to specify the same parameters you plan to use in your DataWindow Designer database profile to access the database.