CODEWITHSUNDEEP
sql-serverreporting-services
Earth Engine
Earth Engine

Reputation: 10436

MS Reporting Services not authenticate on local domain name

I can access my reports through

http://mymachine:808/Reports

or

http://localhost:808/Reports

but not

http://myhost.mydomain.com:808/Reports

even when I have myhost.mydomain.com map to 127.0.0.1 in the host file. It was keep asking user name and password, but the same user name and password works fine in other ways to access.

How to fix this?

Update

It prompts to type in user name and password, but just to pop up again. So there is no way to get into the page with the broken URL.

This is consistent in at least 2 browsers: Firefox 47.0, and Edge 25.10586.0.0

Also, I didn't have Report Manager installed, here is my menu of Reporting services configuration manager:

enter image description here

Upvotes: 1

Views: 478

Answers (2)

Earth Engine
Earth Engine

Reputation: 10436

From the hint in comments the issues is in the Reporting Services.

I was using the default settings, but MSDN said you can have different authentication types. I checked my reportserver.config file and I was using NTLM. Change it to use basic authentication solves the problem.

My guess of the reason, is that the browser will send a "Host" property for every request, and as this is inconsistent with NTLM's "domain", so Reporting Services reject the authentication. However, when switch to basic authentication, it simply pass the credential to Windows, so now it accepts.

References:

Upvotes: 2

DeanOC
DeanOC

Reputation: 7282

You could try adding a new URL for Report Manager. To do this

  • Open Reporting Services Configuration Manager
  • Select Report Manager URL
  • Click Advanced
  • Click Add to add details

Here's a screenshot to help.

enter image description here

Upvotes: 0

Related Questions