Database Reference
In-Depth Information
Figure 9-16.
Connecting to the SSAS server from SQL Server Management Studio
if you are unable to make a connection to SSAS with your current Windows account, you cannot use that
account for the impersonation information and must select another.
Even if you are able to connect, you must still verify that you have permissions to create databases on the
SSAS server. You can do so by right-clicking the server icon in object Explorer and selecting Properties from
the context menu.
When the Analysis Server Properties dialog window appears, look to the left side for the Security page
and click its icon. The security page displays a list of Windows accounts that have been granted SSAS
administrator access. Your account should be listed. if it is, then you have all the permissions you need!
You can also grant different Windows accounts administrator privilege by clicking the Add button and
selecting a Windows account. Figure
9-17
shows the Randal account on his local computer in the process of
being added as an SSAS administrator.
