SSAS: Unable to view database| http://localhost/mis/tmis/msmdpump.dll

Question

Hello, We have MSSQL2016 Enterprises Edition. When we connect to Analysis Server Instance "hostname\instancename" we can see databases. When we enter [http://localhost/mis/tmis/msmdpump.dll] we connect to Analysis Server Instance but cannot be view database. Request to Please assist for the same. Regards, Nikhil Desai

Answer 1

Hi @Nikhil Desai,

You will need to grant permissions on the Analysis Services instance. Each database object will have roles that provide a given level of permissions (read or read/write), and each role will have members consisting of Windows user identities.

To set permissions, you can use SQL Server Management Studio. Under the Database | Roles folder, you can create roles, specify database permissions, assign membership to Windows user or group accounts, and then grant read or write permissions on specific objects. Typically, Read permissions on a cube are sufficient for client connections that use, but do not update, model data.

Check Configure HTTP Access to Analysis Services on IIS 8.0

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.