# Add a Microsoft SQL Server database as a target

This task guides you through adding and configuring a Microsoft SQL Server endpoint as the target database connection. This is the database to where you want to replicate data.

To add a Microsoft SQL Server target endpoint:

1. In Tasks view, click Manage Endpoint Connections.

   The Manage Endpoint Connections dialog box opens.

2. Click New Endpoint Connection.

3. Provide the following information:

   * Name: Type sqlserver\_target.

   * Description: Optionally, enter a description or leave blank.

   * Role: Select Target.

   * Server name: Enter the name of the computer where your Microsoft SQL Server database is installed.

     For example, if you connect to a Microsoft SQL Server database on a computer called `bee`, enter bee.

   * Select one of the following:

     * Windows authentication if your Microsoft SQL Server database is configured to accept Windows authentication.
     * Microsoft SQL Server authentication if your Microsoft SQL Server database is not configured to accept Windows authentication. In this case, you also need to provide a valid user name and password.

   * **Database name**: Enter **tempdb**, which is the name of the database to where you are going to replicate data. If you created a new database for this purpose, enter the name of that database.

   ![The General tab of the New Endpoint Connection dialog.](https://help.qlik.com/en-US/replicate/May2026/Content/Resources/Images/Replicate/add_database_sqlSrv_sample.png)

4. Click Test Connection to verify the information you entered and the availability of the database.

5. Click Save to add the database.

You can also set advanced settings for the Microsoft SQL Server database, but this is beyond the scope of this tutorial. For more information, see [Setting advanced connection properties](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/SQLServerDBSource_AdvProps.htm).

For information on adding other types of databases, see the chapter for the required database. For a list of supported databases, see [Supported Platforms and Endpoints](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Support%20Matrix/supported_platforms.htm).