Database Reference
In-Depth Information
FIguRe 3-6
Analysis Services backup directory location
Right-click Databases and choose Restore. Browse to
OECD_Data.abf
in the backup folder, and then type in
the name of the Database (OECD_Data), and restore it.
Your final step is to connect this cube to the SQL data-
base you restored previously. Right-click Databases and
choose Refresh to show the database you just restored.
Open
OECD_Data.abf
, expand the connections, and
then double-click the connection as shown in Figure 3-7.
In the Connection Properties dialog box, click the
Connection String property and then click the ellipsis
next to it to see the connection string builder shown
in Figure 3-8.
FIguRe 3-7
Changing an Analysis Services
Connection
Set the connection to your SQL database and test the connection. If you get an
error, you may need to edit the security settings on your SQL Database. Start
by going Start
a
All Programs
a
Microsoft SQL Server 2012
a
Configuration
tools
a
SQL Server Configuration Manager. Click SQL Server Services and
check what account Analysis Services is running under, as shown in Figure 3-9.
