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

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

  • Server box.
  • Use Trusted Connections check box.
  • Login ID box.
  • Password box.
  • OK, Cancel, Help, and Options buttons.

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

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

Control Description

Server box

The name of a SQL Server on your network. If you select a server name in the list, no further configuration is needed. If you type 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.

You can enter "(local)" in the server box when 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 nonnetworked version of SQL Server. To specify a named instance of SQL Server, the server name is specified as ServerName\InstanceName.

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 OLE DB provider request a secure (or trusted) connection to a SQL Server. 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 Microsoft Windows login with a SQL Server login ID.

When clear, SQL Server uses standard login security 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.