Reporting Services Login Username And Password.

chitra2009
chitra2009 used Ask the Experts™
on
Hi Experts.
I am new to SSRS .I am using SSRS 2005. When i deploy a reports in reportserver http://localhost/Reports . It is asking UserName and Password? I have tried all the Possibilities.But still It is Asking . Please help me to solve this issue.

Thanks in Advance.
Regards,
chitra.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
if the report is asking for a username and a password probably the datasource hasn't been setup propperly..

normally the username / password are necessary to contact the datasource.

Author

Commented:
Hi p nuts,
In that datasource I have Connected with SQL Authentication user name and password then In that Credential have set a specific username and password . Here what is the problem? Can u please help me. what i wants to do to set datasource properly.

Commented:

Make sure your target server URL  http://localhost/ReportServer  when you want to deploy  it is "Reportserver"  to access to http://localhost/Reports
 
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

Author

Commented:
Hi expects,
Sorry i am new to Reporting. I have one doubt,can i deploy a report in either http://localhost/Report Server or http://localhost/Reports? Can u please tell me sugesstion about this reporting services login?
You should deploy the report to the folder in SSRS that you want the report to be.
For your login, you should configure the datasouce used in the report to use the right credentials.
1.  Use localhost/Reports
2. Click on the Show Details (attached screen s1)
3.  Select your Data Source and edit it - this will open up a screen (attached screen s2)
4.  Make sure you have selected either Windows integrated security or Credentials stored securely in the report server - play with this - you will find success.
 

s1.png
s2.png

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial