User`s guide

2 Getting Started with Database Toolbox
2-26
3
Click the System DSN tab and then click Add. When setting up an ODBC data
source, you can use a User DSN or System DSN. A User DSN is specific to the user
on a machine. Any data sources a user defines under User DSN are seen only by that
specific user. Conversely, a System DSN is not specific to the user on a machine. Any
data sources a user defines under System DSN on a machine can be seen by any user
who logs into that machine. Your ability to set up a User DSN or System DSN might
depend on the database and ODBC driver you are using. For details, contact your
database administrator or your database ODBC driver documentation.
4
A list of installed ODBC drivers appears in the Create New Data Source dialog box.
Select SQL Server Native Client 11.0 and click Finish.
5
In the Create a New Data Source to SQL Server dialog box, enter an appropriate
name for your data source. You use this name to establish a connection to your
database. Here, enter MS SQL Server as the data source name in the Name field.
Enter Microsoft SQL Server as the description in the Description field. Select
the database server for this data source to use in the Server field. Consult your
database administrator for the name of your database server. Click Next.
6
If you want to connect to Microsoft SQL Server using Windows authentication, click
the With Integrated Windows Authentication option button. Then click Next.