问题 无法在Reporting Services配置管理器中访问报表管理器URL


我在我的PC上安装了SQl Server 2008 Reporting服务,但是当我尝试访问Report Manager URL时

(http://localhost/Reports) 

我首先得到提示登录,然后经过几次尝试我最终在一个空白屏幕。

我不知道它是否是权限,甚至是设置不完整的基本内容。

到目前为止我找到的最好的链接是这个页面:
http://www.gotknowhow.com/articles/reportserver-permissions-granted-are-insufficient-for-performing-this-operation-rsaccessdenied

我已经按照步骤进行了第4步。我没有被重定向

http://localhost/Reports/Pages/Folder.aspx.

手动键入URL会在IE中显示空白页面,但我在Firefox中遇到xml解析错误。

任何建议和帮助将不胜感激。

谢谢

一些额外的信息。使用Business Intelligence Design Studio时,我可以部署数据源和报告,并且输出窗口报告成功。

更多信息: 我以管理员身份登录我的计算机。 我安装了MS Sql Server 2008 RS(标准版)

我已经走到了尽头。无法再进一步了。我见过的几乎所有内容都表明问题与不是管理员有关,但我是。


12016
2018-04-13 14:53


起源

StackOverflow上的这个链接描述了我遇到的同样问题。但它建议的解决方案还没有对我有用。 stackoverflow.com/questions/930947/...  那说我会说如果其他人有类似的问题,那么上面的链接似乎是最好的起点。 - Daniel Hollinrake
我应该澄清一下,我在本地计算机上安装了Reporting Services。 - Daniel Hollinrake


答案:


并非所有管理员都是平等的。我最近买了一台新PC并设置了一个“管理员”帐户。

本文解释了我需要做些什么来启用真正的“管理员”。一旦他在那里,我以前的帐户,显然是一个“管理员”恢复为标准用户,并解决了这个难题。

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/7f477018-aa14-4db0-8989-ce763b122a2a 

真正帮助我的评论是'dana_working'。如果文章被删除,我已经完全重新制作了它。

Hi,

I don't know if the OP solved his issue or not, but I had the same problem and 
after banging my head against my desk for two days thought I would share what 
worked for me.
One caveat - I did try a number of things before hitting on what worked for me, 
and there may be something else I did along the way that was also necessary 
(though not sufficient).  I did not make any registry or direct .config changes:

System setup:  Windows 7 64-bit Home Premium; AMD processor; SQL Server Express 2008 R2;   
just running this stuff on my machine for development purposes.

Symptoms:  Could not get the URLs in Report Services Configuration Manager to work, 
even though it was all working fine on a Vista system I set up a few months ago.  
I have administrator priveleges.  I tried opening IE as administrator, authorizing 
my login in various ways through the configuration manager but just could not get in.    
It is not possible, btw, to manage the report server grough SSMS in the Express 
version.  You need to find a way into Report Manager with the URL.

Crux/Solution:  Basically, my administrator account was not THE administrator 
account for the computer; THE administrator (which is hidden) is different than 
having administrator rights.  So the following steps worked to fix the issue 
for me:

I authorized the "hidden Administrator" account.  In Home Premium edition I did 
this by opening a command prompt "as administrator" and entering net user 
administrator /active:yes

From what I've read, this can be done through control panel with higher 
versions of Windows 7.

Log off and voila there is another user now besides yourself.  
Logon now as Administrator

Open IE "as administrator" and go to http://servername/Reports_SQLEXPRESS url.  
I was able to log in at this point.

Once in Report Manager, I authorized my regular Windows account with all 
privileges.  I did this in two locations - maybe someone can explain the 
difference between the two.

Click upper right for "Site Settings"; "Security"; Add yourself as New 
Role as a Site Administrator - you can do this following the steps outlined 
in reply Jin Chen above.

I also found I needed to go back to "Home"; "Folder Settings"; Add yourself 
as New Role with Content Manager as outlined above by MustafaH.
Apply, save, etc.; log out; go back to your regular logon; 
open IE "as administrator" (not sure if that's necessary but I did it anyway) 
and go to the URL, log on with your id, saving credentials.

You now can get into Report Manager just opening IE and going to the URL's;  
Deployment from Bus Intelligence Studio works now too.

Good luck!!

13
2018-04-14 21:31



这对我有用。删除“int”。来自Daniel的网址,否则您将收到证书错误。然而Dana_Working的帖子却是钱。我还有一个额外的步骤,即添加密码到我的管理员帐户,否则您无法登录到ReportManager页面(密码为空)。修改它然后您可以登录,然后将您的主帐户添加到站点安全性和作为内容管理器的文件夹属性下。为什么这样的例行任务如此困难?微软? - Mike K
嗨,迈克,谢谢你提到链接的问题。我编辑了我的帖子并立即更新了。很高兴这对你有所帮助。 - Daniel Hollinrake
感谢回答者详细说明了有效的答案以及围绕它的警告。这对我有用。让我补充一点,这仍然是SQL Server 2016 ctp 2中SSRS的一个问题。我认为这是因为在工作组而不是加入域的机器上运行SSRS;在前者, 任何 BUILTIN / Administrators的成员可以毫不费力地工作,但在工作组,YMMV。 - BobHy


尝试在服务器上创建新的本地用户并将其添加到Administrators组。

然后,浏览到报表管理器URL,并在提示您输入凭据时,输入您用于新本地用户的凭据。

这应该允许您访问报表管理器。为我工作!


0
2018-03-22 13:53



我在本地计算机上安装Reporting Services,所以我认为我的帐户已经是管理员了。 - Daniel Hollinrake


我之前遇到过同样的问题而且我也陷入困境。我不是专家,只是SSRS的初学者,但想分享我的exp。在这里,如果它可以帮助某人。在我的情况下的问题是我没有设置特定登录到Hom页面(ROOT)的权限,导致登录结束给出空白页面。当您不提供对应该调用这些报告的登录的访问权限时,赋予报告和子目录的权限将不起作用。

检查Reportserver URL主页中的权限。


0
2018-05-19 05:55



感谢您的评论。我希望它对某人有帮助。这不会解决我遇到的问题。那是我机器上的初始设置。 - Daniel Hollinrake