用户"IIS APPPOOL \ App名称"没有访问"SSAS多维数据集名称"数据库的权限，或者该数据库不存在 [英] Either the user, 'IIS APPPOOL\App Name', does not have access to the 'SSAS Cube Name' database, or the database does not exist

问题描述

第一-我使用SSAS(SQL Server Analysis Services)将多维数据集部署到localhost

1st - I deployed the cube to localhost using SSAS (SQL Server Analysis Services)

2-我使用SSMS(SQL Server Management Studio)验证了多维数据集数据库的存在，即使

2nd - I verified the cube database exists using SSMS (SQL Server Management Studio) even tough the SSAS DB is not showing in SSMS

第3次-在此第四-我在SSMS中向本地服务器中的Analysis Services添加了一个新连接(而不是与本地服务器中的数据库引擎的连接)

4th - I added a new connection in SSMS to Analysis Services in localhost server (instead of a connection to the database engine in the localhost server)

5th-我意识到关系数据库和多维数据库的授予权限的过程是不同的，并且先前的答案不起作用，因此我按照microsoft docs来

5th - I realized that the process for granting permissions is different for relational databases and multidimensional databases and the previous answer would not work, so I followed microsoft docs to grant cube or model permissions

第六-我尝试查找IIS进程的一些标识符以添加在步骤5中创建的角色.我没有找到任何标识符，也不知道该怎么做才能授予对ISS进程的访问权限，所以我继续进行尝试再次连接到多维数据集数据库，但未成功.

6th - I tried finding some identifier of the IIS process to add in the role I created in step 5. I did not find any and have no idea what to do to grant access to the ISS process, so I went ahead and tried connecting to the cube database again without success.

7日-我尝试更改连接字符串以包括数据库sa用户的密码.还是没有运气.

7th - I tried changing the connection string to include password for the sa user of the database. Still no luck.

我花了太多时间解决这个问题，因此决定在继续努力解决问题的同时向stackoverflow发布问题.感谢您对解决方案的帮助/指点.

I am taking too long with this issue so decided to post question to stackoverflow while I continue my efforts to solve it. Thanks for any help/pointers to a solution.

推荐答案

这是我解决的方法:

1-连接到部署了多维模型的Analysis Services服务器.

1 - Connect to Analysis Services server where the multidimensional model is deployed.

2-数据库-> SSAS(*)解决方案名称->角色

2 - Databases->SSAS(*) Solution Name->Roles

3-通过创建新角色来授予多维数据集或模型权限

4-在成员资格中，添加->高级.单击立即查找，选择IUSR和IIS_IUSRS，然后单击确定.注意:也许只需要IIS_IUSRS.

4 - In membership, Add->Advanced. Click Find Now, select IUSR and IIS_IUSRS, click ok all the way. Note: Maybe only IIS_IUSRS is required.

* SQL Server Analysis Services

*SQL Server Analysis Services

这篇关于用户"IIS APPPOOL \ App名称"没有访问"SSAS多维数据集名称"数据库的权限，或者该数据库不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！