Data Source Wizard Screen 2

On the second screen of the wizard, you can specify the method of authentication. You can also set up Microsoft SQL Server advanced-client entries, and specify the login and password the SQL Server ODBC driver will use to connect to SQL Server while configuring the data source.

With Windows NT authentication using the network login ID

The With Windows NT authentication using the network login ID option button specifies that the SQL Server ODBC driver will request a secure (or trusted) connection to a SQL Server instance. When selected, SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The SQL Server system administrator must have associated your Windows login with a SQL Server login ID.

With SQL Server authentication using a login ID and password entered by the user

The With SQL Server authentication using a login ID and password entered by the user option button specifies that the SQL Server ODBC driver will not request a secure (or trusted) connection to SQL Server. When selected, SQL Server uses standard login security to establish connections using this data source. You must specify a SQL Server login ID and password for all connection requests.

Client Configuration

If you specified a new name in the Server box on the first screen of the wizard, you might need to use this dialog box to add a server alias configuration entry whose name matches the name you specified in the Server box on the first screen of the ODBC wizard. The alias name must match the name you specified in the Server box. For SQL Server, you do not usually need a server alias configuration. In most cases, the SQL Server ODBC driver can connect by using the default value in the Network libraries list and the network name supplied in the Server box on the first screen of the wizard.

Click Client Configuration if you want the connection to use a network library other than the client's default network library. Also click Client Configuration if the actual network address of the server must be specified for a successful connection. For example, when using the TCP/IP Net-Library, you might have to specify the port and socket address of the server. If a SQL Server instance is listening on an alternate named pipe, you must specify the pipe name in the advanced entry.

For more information about configuring clients, see SQL Server Books Online.

Connect to SQL Server to obtain default settings for the additional configuration options

When you select the Connect to SQL Server to obtain default settings for the additional configuration options check box, the SQL Server driver obtains initial settings from the SQL Server instance for the options on the following screens of the wizard. The SQL Server driver connects to the SQL Server instance named in the Server box on the first screen.

When clear, the driver uses standard defaults as the initial settings for the options on the following screens in the wizard.

Login ID box

The Login ID box specifies the login ID that the SQL Server driver uses when connecting to SQL Server if With SQL Server authentication using a login ID and password entered by the user is selected. This only applies to the connection made to determine the server default settings; it does not apply to subsequent connections made using the data source after it has been created.

Password box

The Password box specifies the password the SQL Server instance uses when connecting to SQL Server if With SQL Server authentication using a login ID and password entered by the user is selected. This only applies to the connection made to determine the server default settings; it does not apply to subsequent connections made using the new data source.

Both the Login ID and Password boxes are disabled if With Windows NT authentication using the network login ID is selected, or if Connect to SQL Server to obtain default settings for the additional configuration options is not selected.