Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Sessions are handled separately from Forms Authentication. There is a good explanation of this <a href="https://stackoverflow.com/questions/1335472/does-formsauthentication-setauthcookie-make-a-session-based-cookie/1335538#1335538">here</a>.</p> <p>The most common reason for Forms Authentication failures on load-balanced environments is lack of synchronization of the MachineKey element. You've stated that you've got the server operators to ensure that the MachineKey is synchronized, but have you verified this yourself in some way? Is this the case on ALL the web servers? From previous dealings with a couple of commercial web hosts, I've found that it is (unfortunately) difficult to take their assurances at face value. </p> <p>Another thing to check is if the FormsAuthentication configuration (timeout, path, name, etc.) is the same on all of the hosts.</p> <p>Are the patch levels the same on all of the hosts? You might want to see if the compatibility switch mentioned <a href="http://support.microsoft.com/kb/2659968" rel="nofollow noreferrer">here</a> is applicable in your situation.</p> <p>Assuming that the hosting setup is correct, maybe you have initialization code on the page that logs you out if some condition is not fulfilled?</p> <p>Try to take a look at the server logs and trace the sequence of HTTP requests involved during a failed page request. That might produce a clue. </p> <p>Edit: This guide to troubleshooting Forms Authentication problems is detailed, and quite helpful: <a href="http://www.iis.net/learn/troubleshoot/security-issues/troubleshooting-forms-authentication" rel="nofollow noreferrer">Troubleshooting Forms Authentication</a> </p>
    singulars
    1. This table or related slice is empty.
    1. POUsers are being logged out of web site due to round robin load balancer
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMaxam
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUsers are being logged out of web site due to round robin load balancer
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, the trouble shooting guide helped me establish that the client is not actually sending the ASPXAUTH cookie when it's requesting the page after the short delay resulting in the server thinking they aren't authenticated. However I'm still struggling to think what the next step is. The fiddler log shows "Tunnel to" "www.mydomain.co.uk:443" both times so why would it not see that as the same URL and pass the cookie in? On both servers the cookie shows the expiry as "At end of session" and is associated with the domain "https://www.mydomain.co.uk"...which in my understanding should work.
      singulars
      1. PO
      1. USColinRobertson
    2. COI've marked your answer as accepted because, as you predicted, the web host hadn't fully deployed the MachineKey changes. They had changed it in the Framework folder, but had not changed in the Framework64 folder. Thanks for your help.
      singulars
      1. PO
      1. USColinRobertson
    3. COGlad it's working for you now!
      singulars
      1. PO
      1. USMaxam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload