Tutorial: Create a SQL Server Database Connection

Requirements

Before attempting this tutorial, you must complete Tutorial: Create a SQL Server Database.

Create the Connection

1. Start Enterprise Developer as an administrator. If you need instructions, see To start Enterprise Developer as an administrator.
2. From Eclipse, click Run > Tools > Data Tools > HCO for SQL Server.
3. From the HCO for SQL Server interface, click Manage Connections.
4. Select the User Connection Type.
5. From the Connection List tab, click New SQL Server Connection. This takes you to the SQL Server Connection tab.
6. In the Data Source Name field, type HCODemo.
7. Click Integrated Windows Authentication to select it. This means that SQL Server uses your Windows logon credentials to access the database.
8. In the SQL Server Instance field, type the name of your SQL Server instance. If you have a default instance, this could be . or (local). If you have a named instance, use the combined server name and instance name. For example: mysqlserver\myinstance.
9. Click Confirm Server to confirm that HCOSS can locate your specified SQL Server Instance.
10. Check Use a database other than the default database:.
11. From the Database drop-down menu, select the HCO_Test destination database that you created in SQL Server Management Studio.
12. Click Test. If the test fails, review your field entries, make corrections accordingly, and try again. When you have a successful connection, click OK.
13. Click Save to save the connection. This takes you back to the Connection List tab where you should now see your SQL Server connection listed.