This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Originally posted as an SQL MDS issue but not convinced that's the root cause.
I have IIS installed on Windows Server 2019 in support of an SQL Master Data Services installation. When I try to login to the site from the same server I get repeated prompts for my username/password. If I cancel the login, I get a 401 error.
If I try to access the site from another computer on the same domain, the symptoms are identical.
However... if I access the site from my home workstation (no domain) while connected to the corporate network through VPN it works fine.
All attempts using MS Edge and the same credentials.
I'm reasonably sure this worked after I first installed MDS - although I can't evidence that. However we recently had to create some SPNs (including a machine SPN) to enable the Power BI on this server to communicate with SSAS on another machine. I don't know if this is the cause of the problem but wanted to include all potential causes.
I have modified the "Authentication" settings on the "Default Web Site" to match the MDS site and the symptoms are now the same on the "Default Web Site" - so it's definitely not an MDS issue.
Any ideas? Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYD%3C/text%3E%3C/svg%3E)
Hi @Peter Bishop ,
What authentication have you enabled? Before you start troubleshooting, you need to check that you entered the correct username and password. And what error message do you see in the console panel? Could you provide details about the 401 error?
As this is working from my home workstation, I know it's not a credentials issue.
The 401 error only occurs if I click "cancel" and then it just reports "Unauthorised".
Hi @Peter Bishop ,
According to your description, machines in the same domain in your organization cannot be accessed, but you can connect your home workstation to the company network and can access it normally, why don't you think it's a network policy issue but an IIS issue?
I'm not saying it's not a "network policy" issue. I just said it can't be a "credentials" problem since my credentials work fine from a different device.
This issue was caused by the SPN on SQL Reporting Services (also running on the server) having SPNs of HTTP/... rather than HTTPS/... which is how the site was configured.