Provides a drop-down list of installed and supported SQL Server ODBC providers to select for the connection. Available for
System and
User connection types only.
Important:ODBC provider selection for SQL Server connections applies to System or User connections. Azure connections do not use ODBC
connections. The "SQL Server" ODBC provider from Microsoft is an older provider that ships with Microsoft Windows and lacks
certain features available in many newer Microsoft ODBC providers. As such, it is not shown in Manage Connections ODBC drop-down
selectors. Microsoft ODBC provider versions provide support for particular versions of SQL Server. To help you select an appropriate
ODBC provider,
System requirements, installation, and driver files page on the Microsoft Web site.
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.