On the first screen of the wizard, you can specify the name and description of the data source, and the name of the server running Microsoft SQL Server to which the data source will connect.

Name box

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.

Description box

An optional description of the data source. For example, "Hire date, salary history, and current review of all employees".

Server box

The name of a SQL Server instance on your network. If you select a server name from the list, no further configuration is needed. If you enter the name of a server that does not exist as an entry in the SQL Client Configuration Utility, you can create a server alias for the new name on the next screen of the wizard.

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 copy of SQL Server, even when running a non-networked version of SQL Server. SQL Server supports 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 required to connect to SQL Server, you can click Finish. Defaults are used for all attributes specified on other screens of the Wizard.