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.
Create the HCODemo connection
- In
Visual Studio, click
View > Micro Focus SQL Tools >
HCO for SQL Server Tools.
This opens the
Micro Focus HCO for SQL Server dialog box.
- From the HCO for SQL Server interface, click
Manage Connections.
- Click the
Connection List tab.
- In the
Connection Type group, click
User.
- 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
localhost 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 list, select the
HCO_Test destination database that you created in SQL Server Management Studio.
- Click
Test. If the test fails, review your field and make corrections as appropriate, and try again. When you have a successful connection,
click
OK.
- Click
Save.
This takes you back to the
Connection List tab where you will now see your SQL Server connection listed.