用户IIS APPPOOL \DefaultAppPool无权访问PDW测试数据库，或者数据库不存在。 [英] Either the user, IIS APPPOOL\DefaultAppPool, does not have access to the PDW test database, or the database does not exist.

问题描述

 

当我尝试使用OLAP控件连接sql 2008 R2分析服务时，我收到以下错误

" 用户IIS APPPOOL \DefaultAppPool无法访问PDW测试数据库或数据库不存在。"

 

这是我使用的连接字符串： < add name =" OlapDB" connectionString =" Provider = MSOLAP; Data Source = PCT86\PCT86_R2; Initial
Catalog = Adventure Works DW; Persist Security Info = false; Integrated Security = SSPI" />

 

任何人都可以让我知道我错在哪里!!!

 

谢谢，

Mayur

解决方案

< span style ="font-family：" Verdana"，" sans-serif" ;; font-size：10pt"> Hello 

 

 

感谢您的发帖！我建议您将问题发布在
SQL Server开发人员中心 >
SQL Server论坛
> SQL Server Analysis Services

位于此处： 

http： //social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads

祝你有美好的一天！

Hi,

 

When i try to connect sql 2008 R2 analysis service using OLAP control then i get following error

"Either the user, IIS APPPOOL\DefaultAppPool, does not have access to the PDW test database, or the database does not exist."

 

Here is connection string that i used: <add name="OlapDB" connectionString="Provider=MSOLAP;Data Source=PCT86\PCT86_R2;Initial Catalog=Adventure Works DW;Persist Security Info=false;Integrated Security=SSPI" />

 

can anyone let me know where i am wrong!!!

 

Thanks,

Mayur

解决方案

Hello 

 

 

Thank you for your post!  I would suggest posting your question in one of the SQL Server Developer Center > SQL Server Forums > SQL Server Analysis Services

located here:  http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads

Have a great day!

这篇关于用户IIS APPPOOL \DefaultAppPool无权访问PDW测试数据库，或者数据库不存在。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！