Database Reference
In-Depth Information
Figure 2-55.
Verifying the connection
4.
Once this dialog window appears, verify that the server name is appropriate for your
computer by reviewing the Server Name textbox. if the server name is incorrect,
change it to the correct one now.
Important
: Remember, if you have installed SQL server on the same computer multiple times, your SQL
2012 installation may be called a name other than (local). For more information, search the web for “SQL
Server Named instances.”
5.
Confirm that the DwweatherTracker database is selected in the “Select or enter
database name” dropdown box (Figure
2-55
).
6.
Click the Test Connection button to verify that your connection works (Figure
2-55
).
7.
Click OK to close the Connection Manager window and return to the Dialogue Source
Designer window (Figure
2-55
).
8.
Please leave the Dialogue Source Designer dialog window open for now.
Change the Impersonation Settings
Each SSAS project uses an impersonation account to deploy and process its cubes and dimensions. Now
configure the connection to use the impersonation information suitable for your computer.
