Set Up HCO_TEST SQL Server Database Access

Guides you through the process of creating the HCO_Test SQL Server database, and creating the HCODemo SQL Server connection to access it.

Create the HCO_Test SQL Server database

Start Microsoft SQL Server Management Studio.
Connect to the server where you want to create your database.
Note: The user ID and password you provide must log you on to SQL Server with dbadmin or sysadmin permissions that enable you to create a SQL Server database.
Create a SQL Server database named HCO_Test.
Close SQL Server Management Studio.

In Visual Studio, click View > Micro Focus SQL Tools > HCO for SQL Server Tools.
From the HCO for SQL Server interface, click Manage Connections.
Select the User Connection Type.
From the Connection List tab, click New SQL Server Connection. This takes you to the SQL Server Connection tab.
In the Data Source Name field, type HCODemo.
Click Integrated Windows Authentication to select it. This means that SQL Server uses your Windows logon credentials to access the database.
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.
Click Confirm Server to confirm that HCOSS can locate your specified SQL Server Instance.
Check Use a database other than the default database:.
From the Database drop-down menu, select the HCO_Test destination database that you created in SQL Server Management Studio.
Click Test. If the test fails, review your field entries, make corrections accordingly, and try again. When you have a successful connection, click OK.
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.