部署报表Sql Server 2008 R2-出现对话框提示输入凭据 [英] Deploying Reports Sql Server 2008 R2 - dialog box appears prompting for credentials

问题描述

我已经配置了Sql服务器报告服务.当我尝试部署报告时，系统会提示我提供凭据.我不记得创建任何密码.我尝试使用所有用户名和密码，但没有任何效果.我什至尝试在Sql Sever中创建一个新用户来授予权限.但是，没有任何效果.

我已将Reporting Service URL更改为"localhost"，它仍然提示我提供凭据.最后，在报告的数据源中，我也使用了无凭据".所有这些更改都无法解决提示问题.
请让我知道，如何解决此问题.

谢谢，
Phani

Hi,
I have configured the Sql server reporting services. When I am trying to deploy a report, I am being prompted with credentials. I did not remember creating any password. I have tried with all the usernames and passwords, but nothing worked. I even tried to create a new user in Sql Sever to grant permissions. However, nothing works.

I have changed the Reporting Service URL to "localhost" and it still prompts me with the credentials. And finally, in the data source for the reporting I have used "No Credentials" too. All these changes has no solution for the prompts.
Please let me know, how to resolve this.

Thanks,
Phani

推荐答案

在该计算机上创建本地用户，并将该用户添加到管理员组sqlserver20008reportingservicewebserivesuser

create a local user in that machine and add the user to administrator group , sqlserver20008reportingservicewebserivesuser

...，
Sqlserver2008reportserveruser ....组

在Sql Server Reporting Services主页中，选择具有数据源的文件夹->单击属性->安全性->.新角色分配->提供本地用户名(计算机名\用户名，例如db2Server \ Phanikanth)并选中所有复选框，然后单击确定.

现在，当您尝试部署报告时，它将提示您输入凭据，以提供
本地用户名(计算机名\用户名)和密码.

它应该可以正常工作.


创建用户的步骤:-在mycomputer上->管理->单击并展开->本地用户和组->右键单击用户->新用户.

... ,
Sqlserver2008reportserveruser.... group

In Sql server reporting services home page select the folder which has datasource ->click properties - >security-> new role assignment-> give local user name(machinename\username eg. db2Server\Phanikanth) and select all check boxes and click ok.

Now when you try to deploy report it will prompt for credentials give
local user name (machinename\username) and password .

it should work fine.


Steps to create user :- right on mycomputer -> manage-> click and expand ->localusers and groups ->right click on users ->new user.

这篇关于部署报表Sql Server 2008 R2-出现对话框提示输入凭据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！