If you are using DDW for the first time, you must create a new DDW Repository before performing any other activity.
You can create multiple DDW Repositories based on your business requirements, either on a Windows partition where DDW is installed (local server) or on a Windows partition in a different machine (remote server).
On the Repository menu, click New .
The New Repository dialog box appears.
From the Host Name drop-down list, select the required host or enter the host IP address.
If there are multiple network adapters / addresses, enter the host IP address instead of the host name to avoid name resolution issues.
To improve the security when Data Exchange connects to a DDW repository, you can enable secure connection. To do so, select the Secure Connection check box.
To use the Secure Connection option, you must ensure that SQL server is configured correctly for SSL encryption. You must install the Security Certificate on the machine(s) where DDW and SQL server is installed. If the requirements for secure connection are not satisfied, then when you try to choose a repository, it will result in an error. In such a case, deselect the Secure Connection option and then choose the required repository.
Choose one of the following authentication methods:
Windows Authentication: If you have added the Windows logon credentials as an administrator account or a user account that has the privilege of creating databases in the SQL Server Management Studio, select Windows Authentication.
SQL Server Authentication: If the logon credentials to the selected host are different from the Windows credentials, select SQL Server Authentication. Enter the login credentials in the Login User and Password for the selected SQL Server fields.
Note: SQL Server credentials must be created with a minimum of dbcreator server role in the SQL Server Management Studio.
Enter a name for the repository in the Repository Name field.
Click OK.
A new DDW Repository is created.
You can click Cancel to cancel the process.
Note: While creating a new DDW Repository on a remote machine, you must select certain security configuration options in Microsoft Distributed Transaction Coordinator (MSDTC). This is to save the information successfully in the repository.
Browse to Control Panel >Administrative Tools >Component Services > Computers >My Computer >Distributed Transaction Coordinator > Local DTC, and then right-click and select Properties.
Select the Security tab.
Ensure to select the following security configuration options:
Network DTC Access
Allow Remote Clients
Allow Inbound
Allow Outbound