Micro Focus Studio Enterprise Edition for Windows > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > User Interface Reference > Manage Connections > SQL Server Connection tab

SQL Server Connection tab

ODBC Driver: Shows the name and version of the ODBC driver in use for the current connection. Visible for System and User connection types only.

Data Source Name: Type a name for this connection.
Integrated Windows Authentication: Automatically send your Windows user ID and password as login credentials for this connection.
Use SQL Server Login: Send the User ID and Password supplied in the corresponding fields as login credentials for this connection.
User ID: Type the user ID you want to use for your SQL Server login. This is required only when you have selected Use SQL Server Login.
Password: Type the password you want to use for your SQL Server login. This is required only when you have selected Use SQL Server Login.
Allow Saving ADO.NET Connection Password: Set HCOSS to remember your ADO.NET password. When unchecked, the system prompts you for a password each time you connect from other HCOSS tools. This check box applies only when you have selected Use SQL Server Login.
SQL Server Instance: Select a SQL Server instance from the drop-down list, or type the name of a SQL Server instance. Use . or (local) to specify your local machine.
Refresh: Refresh the list of available SQL Server instances.
Confirm Server: When you specify a SQL Server instance by typing into the SQL Server Instance field rather than selecting from the drop-down list, click this to confirm the specified instance and test its validity.
Use a database other than the default database: dbname: Activates the Database drop-down list, enabling you to specify an alternative database for this connection.
Database: Select a database from the drop-down list, which includes all SQL Server databases available for the login credentials you specified for this connection.
Test: Verify that the information you have specified on this tab is sufficient to create a working SQL Server connection.
Save: Create an ODBC and an ADO.NET SQL Server connection, each based on the information you have specified on this tab.