Red Gate forums :: View topic - Windows authentication in IIS 7
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Windows authentication in IIS 7

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mortenn@hapro.no



Joined: 02 Aug 2011
Posts: 12

PostPosted: Wed May 22, 2013 3:17 pm    Post subject: Windows authentication in IIS 7 Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu May 23, 2013 5:45 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
mortenn@hapro.no



Joined: 02 Aug 2011
Posts: 12

PostPosted: Fri May 24, 2013 12:23 pm    Post subject: Reply with quote

I am trying to use windows authentication between my browser and the web site.
Back to top
View user's profile Send private message
mortenn@hapro.no



Joined: 02 Aug 2011
Posts: 12

PostPosted: Tue Jun 04, 2013 7:44 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Tue Jun 04, 2013 8:41 am    Post subject: Reply with quote

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/system.webserver/security/authentication/windowsauthentication

I'm sorry again for the delay and for not being able to provide much help.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group