Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

Reporting Services Authentication

I don't know what I did wrong but I cannot access my SSRS instance.  It keeps prompting me for a username/password.  The SSRS instance is installed on a seperate web server.  I've tried every possible combination of usernames/passwords that I have and it still doesn't authenticate me.  Does anyone have any suggestions?  I probably set it up incorrectly, this is my first time using SSRS.  I'm losing hope....

Windows Service Identity
Built-In Account: Local System

Database Setup
Credentials Type: SQL Server Credentials

I don't know if those are any help.  I'm using SQL Server 2005.
0
mmeisel
Asked:
mmeisel
1 Solution
 
BryanMICommented:
In the IIS configuration for that site, make sure that ONLY "Windows Integrated Authentication" is selected.  Sometimes having anonymous and integrated on at the same time will cause that to happen.
0
 
mmeiselAuthor Commented:
Still didn't work.  I tried checking "Anonymous" (just to see what would happen) and I got the following error message:

The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) Get Online Help

0
 
Chris LuttrellSenior Database ArchitectCommented:
mmeisel,
Did that solution really work for you or not?  Your comment said it did not, but then you accepted it without any clarification, but 2 months later.  Other people follow these questons to learn from them or solve similar problems and this does not present a clear answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now