Windows authentication in IIS 7

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Windows authentication in IIS 7

Postby mortenn@hapro.no » Wed May 22, 2013 3:17 pm

Hello,

I am having some trouble getting SQL Monitor to use Windows authentication through IIS.

If I enable windows authentication and disable forms authentication in IIS, I get prompted for a username and password.
Entering credentials in this prompt does not work.
Aborting it, I this;

HTTP Error 401.2 - Unauthorized
You are not authorized to view this page due to invalid authentication headers.

lookint at http headers in firebug, I send NTLM Authorization header to the server, but the response only has a WWW-Authenticate Negotiate NTLM header in it.

NTLM authentication is working fine against other sites hosted on a different IIS server.

I have tried this a few times now, with no success.

Any pointers would be greatly appreciated.

// Cheers, Morten
mortenn@hapro.no
 
Posts: 12
Joined: Tue Aug 02, 2011 12:21 pm

Postby chriskelly » Thu May 23, 2013 5:45 pm

Thank you for your post.

Where are you trying to use Windows Authentication? It isn't entirely clear in your post.

The tool login has three user rules which do not support Windows Authentication in any way. But windows user accounts can be used for the actual monitoring.

But if you can clarify what you are trying to do, then I might be able to give a more specific answer.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby mortenn@hapro.no » Fri May 24, 2013 12:23 pm

I am trying to use windows authentication between my browser and the web site.
mortenn@hapro.no
 
Posts: 12
Joined: Tue Aug 02, 2011 12:21 pm

Postby mortenn@hapro.no » Tue Jun 04, 2013 7:44 am

Hi,

I have still not been able to resolve this..
Is it really that strange to want to secure the access to web frontends using NTLM/Kerberos?

// Morten
mortenn@hapro.no
 
Posts: 12
Joined: Tue Aug 02, 2011 12:21 pm

Postby chriskelly » Tue Jun 04, 2013 8:41 am

My apologies, I thought that I had replied.

While SQL Monitor does support IIS, unfortunately we cannot support the configuration of IIS. The problem is that without an intimate knowledge of your IIS setup it is incredibly difficult for me to diagnose any IIS problem, including the cause of your HTTP 401.2 error.

I do know that other users have done what you are trying to do, and I have pointed them towards the link below on the iis.net website as a starting point.

http://www.iis.net/configreference/syst ... entication

I'm sorry again for the delay and for not being able to provide much help.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest