Options

The data source name used by an ODBC application when it requests a connection to the data source. For example, "Personnel." The data source name is displayed in the ODBC Data Source Administrator dialog box.

(Optional) A description of the data source. For example, "Hire date, salary history, and current review of all employees."

The name of an instance of SQL Server on your network. You will need to specify a server in the next edit box.

In most cases, the SQL Server Native Client ODBC driver can connect by using the default protocol order and the server name supplied in this box. Use SQL Server Configuration Manager if you want to create an alias for the server or configure client network libraries.

You can enter "(local)" in the server box when you are using the same computer as SQL Server. The user can then connect to the local instance of SQL Server, even when running a non-networked version of SQL Server. SQL Server 2000 and later versions support multiple instances of SQL Server running on the same computer. 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.

If the information specified on this screen is all that is needed to connect to SQL Server, you can click Finish. Defaults are used for all attributes specified on other screens of the wizard.