Deploying Reports Sql Server 2008 R2 - dialog box appears prompting for credentials

Question

0.00/5 (No votes)

See more:

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

Posted 21-Dec-10 7:12am

phanikanth

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

maheswariragu · Answer 1 · 2010-12-28T10:41:00

create a local user in that machine and add the user to administrator group , sqlserver20008reportingservicewebserivesuser$... ,
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.