Solved

Prompting for usesrID/Pswd for multiple times - SQL master data services

Posted on 2013-11-07
4
200 Views
Last Modified: 2013-11-17
Recently I created web application for sql server master data services. when I am browsing on my local machine/other machine its prompting for user name and password and I am able to connect web application successful.

when i tried to connect second time (close IE & reopen new IE tab), its not prompting for  user name/password and automatically it connects to application.

Please let me know what configurations are required in IIS /IE to populate user name/password prompt every time (multiple time) when i tried to browse web application from local/other machines..
0
Comment
Question by:sqldba2013
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Zberteoc earned 125 total points
Comment Utility
It is possible that the session was still active and that is why did't ask for authentication. Either wait or try from another browser. It also may be some settings in the website itself.
0
 
LVL 15

Assisted Solution

by:dbbishop
dbbishop earned 125 total points
Comment Utility
In your web application, when it closes, have it perform a ClearAllPools. This will clear all open connection pools. Close returns a connection to the pool but does not necessarily terminate the connection.
0
 

Author Comment

by:sqldba2013
Comment Utility
Can we do this in IIS settings/properties instead of ClearAllpools?
0
 

Author Closing Comment

by:sqldba2013
Comment Utility
--
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now