SQL Server Connection tab
Restriction: This topic applies to Windows environments only.
- 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
-
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.
