October 4, 2007 at 5:41 am
Anyone ever experienced this?
We had a test system, it seemed fine. We went live, overwriting the backend. In the live system our users randomly get logged out of the app - thrown back to the login screen.
I don't believe it is SQL Server related, and can't think how it can be (session state is not based in SQL server). Am I right?
I'm not expecting answers for the issue, just some fellow SQL DBAs to back me up with a "No it wouldn't be the SQL server" or "It coudl actually be this part of SQL..."
October 4, 2007 at 10:13 am
It really depends on what events will send the app back to the login screen, and how you handle errors. Ideally you will have some logging in the application that can tell you what condition caused the error ... without that information it could be a million things, including something SQL-related.
October 4, 2007 at 10:47 am
Well it seems to be switching between HTTP and HTTPS when it supposed to be all HTTPS so i think it may be dropping sessions. The errors occur randomly, although once someone gets thrown back to the login screen they tend to need to delete temp internet files and cookies before they can get passed the login screen.
What sort of SQL related problems could cause such behaviour?!
October 4, 2007 at 12:34 pm
I can't think of anything SQL-side. Something in the app may be hardcoded to use http (for example, a button or a server side transfer). Switching protocols may not be the reason for your problems though .... really logging the reason is the only way you will know for sure.
October 4, 2007 at 3:12 pm
Switching between HTTP and HTTPS in itself usually will drop the session info in IIS. Are you in a position on that IIS server to only allow https? That might help you find the culprit.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply