Database Reference
In-Depth Information
Figure 4-2:
Provide the basic information needed to connect to the target database.
Log on to the Server:
These are your login credentials. Depending on how your IT depart-
ment gives you access, you select either Use Windows Authentication or Use SQL Server
Authentication. Windows Authentication essentially means that the server recognizes
you by your windows login. SQL Server Authentication means that the IT department cre-
ated a distinct username and password for you. If you're using SQL Server Authentication,
you need to provide a username and password.
●
Save My Password:
Select the Save My Password check box if you want your username
and password to be stored in the workbook. This allows your connections to remain refre-
shable when being used by other people. There are obviously security issues with this
option, because anyone can view the connection properties and see your username and
password. You should only use this option if your IT department set you up with an appli-
cation account — that is, an account created specifically to be used by multiple people.
●
Database Name:
Every SQL Server can contain multiple databases. Enter the name of the
database you are connecting to. You get this from your IT department when you are
given access.
●
4.
In the Choose How to Import the Data screen, shown in Figure 4-3, choose whether to select
from a list of tables and views, or write your own custom query using SQL syntax. Click Next
when done.
Search WWH ::
Custom Search