Microsoft Office Tutorials and References
In Depth Information
SQL Server Authentication. (In this case, you need to provide user name and password in
this dialog box.) Your IT department tells you what authentication method to use; in this
book, we always assume we are using Windows Authentication.
■ Database name In this box, you need to specify the name of the database to which you
want to connect. A single SQL Server normally hosts many databases, so you need to
provide the name of the specific database of interest to you. Again, you need help from the IT
department so that they can give you the name of the database that contains your data.
Before continuing, it is a good practice to test the connection with the Test Connection button
so that you can be sure that there are no problems with the connection parameters. If the
connection test runs fine, you can confidently save this connection and proceed with the next
steps. If, on the other hand, you find any kind of problem, it is better to discover it now and
solve it immediately.
Clicking Next brings you to the next window of the wizard (see Figure 5-3), where you need
to make an important choice: whether you want to load data directly from tables or views or
whether you want to write a SQL query to perform some advanced data loading.
FIguRE 5-3 Choosing the correct loading method.