Database Reference
In-Depth Information
4.
Select (or type in) the database you want to pull the data from, and then click
Test Connection to ensure that all your settings are correct.
5.
Click OK to close this dialog and take you back to the Data Source Properties
dialog. It should now look like Figure 8-6, which shows the appropriate
connection type and connection string.
Figure 8-6. Completed Data Source Properties dialog
Granted, these steps are no different than those for connecting to a local database. But although the
steps are the same, some of the key selection components are different, such as those in Figures 8-4 and
8-5, where you select the specific Microsoft SQL Azure provider and the SQL Azure-specific connection
information.
Your data source definition also allows you to specify the credentials with which to connect to your
data source. Selecting Credentials at left in the Data Source Properties dialog shows you four options.
Windows Authentication (integrated security)
Prompt for credentials
Specify a user name and password
Do not use credentials
Obviously, you need to use credentials, so not specifying credentials isn't the option you want. And
integrated security isn't available with Azure, so that won't work either. You can either prompt for
credentials or specify a username and password. The default value is to prompt for credentials; if you
leave that setting, the report prompts you to enter a username and password every time you run the
report. Continue as follows:
Search WWH ::




Custom Search