Micro Focus Enterprise Test Server 2.3 Update 1 > Data Access > Database Access > 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. In this version of HCOSS, this check box has no effect on the connection.
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.