The Microsoft SQL Server ODBC driver displays the SQL Server Login dialog box when you attempt an ODBC connection without specifying enough information for the driver to connect to a SQL Server instance.

When the SQL Server Login dialog box is first displayed, it contains only the following:

  • The Server box, or the name of the data source.
  • The Use Trusted Connections check box.
  • The Login ID box.
  • The Password box.
  • The OK, Cancel, Help, and Options buttons.

If you click the Options button, the dialog box expands to also contain the Options group:

  • The Database box.
  • The Language box.
  • The Application Name box.
  • The Workstation ID box.

Server box

The name of a SQL Server on your network. If you select a server name from the list, no further configuration is needed. If you type in a server name, it must be an advanced entry in the SQL Client Configuration utility or the network name of a server running SQL Server. This box is replaced with the data source name (DSN) if you specified a DSN for the connect.

You can enter "(local)" in the server box if you are using the same computer as SQL Server. The user can then connect to a local copy of SQL Server, even when running a non-networked version of SQL Server.

For more information about server names for different types of networks, see the SQL Server installation documentation in SQL Server Books Online.

Use Trusted Connection check box

When selected, specifies that the SQL Server ODBC driver will request a secure (or trusted) connection to a SQL Server. When selected, SQL Server uses integrated login security (Windows Authentication) 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 network ID with a SQL Server login ID.

When clear, SQL Server uses standard login security (SQL Server Authentication) to establish connections using this data source. You must specify a login ID and password for all connection requests.

Login ID box

Specifies the SQL Server login ID to use for the connection if Use Trusted Connection is not selected. If Use Trusted Connection is selected, the Login ID box is disabled.

Password box

Specifies the password for the SQL Server login ID used for the connection if Use Trusted Connection is not selected. If Use Trusted Connection is selected, the Password box is disabled.

Database box

Specifies the default database to use on the connection. This overrides the default database specified for the login on the server. If no database is specified, the connection uses the default database specified for the login on the server.

Language box

Specifies the national language to use for SQL Server system messages. The SQL Server instance must have the language installed. This overrides the default language specified for the login on the server. If no language is specified, the connection uses the default language specified for the login on the server.

Application Name box

Optionally specifies the application name to be stored in the program_name column in the row for this connection in master.dbo.sysprocesses.

Workstation ID box

Optionally specifies the workstation ID to be stored in the hostname column in the row for this connection in master.dbo.sysprocesses.