Part VI: Access as an Enterprise Platform
1208
The description in Figure 37.8 is not essential, but you must provide the SQL Server
instance name. You’ll experience a delay when you drop down the list of SQL Server
instances at the bottom of this dialog box. The dialog box actually goes out across the
network and retrieves the names of all the SQL Server installations it can find. Depending
on the size of the local network, the delay can be up to a minute or more.
FIGURE 37.8
Specifying the DSN name and SQL Server instance- Click Next after selecting a SQL Server instance.
- You specify the authentication mode for the DSN connection in the next dialog box (see
Figure 37.9). Depending on how the SQL Server installation was configured, you may
need to use NT login or mixed-mode authentication.
The default settings shown in Figure 37.9 assume you have a SQL Server with operating
system authentication. (SQL Server uses your Windows login name and password to
authenticate you and grant permission to its databases.) The alternative (mixed-mode
authentication) means that you’ve been assigned an explicit user name and password for
the selected SQL Server installation.
- Specify the authentication mode and click Next.
- Select the DSN’s database in the next dialog box.
The drop-down list at the top of the dialog box contains the names of all the databases
managed by the SQL Server instance selected in Figure 37.8. In Figure 37.10, the
CollectibleMiniCarsSQL database is selected for the new DSN.
By default, the DSN’s database is set to master, a system database used by SQL Server to
manage its internal information. Check the Change the Default Database To check
box to enable the database drop-down list so that you can select a working data source
for the DSN and click Next.