Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific functionality, but this has caused a side effect with Word / Excel files when opened from the site using Office 2007 / 2010.

Some users are challenged for authentication when opening a Word / Excel document from IE (but not when they select "save file" instead of "open file"). A window pops up behind IE / Word / Excel (so you often don't realise it's there) showing the sites login page. If the window is dismissed then the document continues to open normally.

It seems to be environmental. Most Office 2007 / 2010 users internally experience this and we've had confirmed reports externally of this happening.

Anyone know how to prevent this behaviour?

In case it's relevant: The company also has an internal SharePoint site using NTML authentication allowing internal users to edit the same content visible externally. So there are 2 sharepoint sites being driven from the same content:

  1. http://internal.domain.com - Allows internal users to edit site content. Uses NTML and AD. No issues here.
  2. http://www.domain.com - Site visible to external users. Uses FBA to allow users access to a few special pages.

I originally suspected the SharePoint header added to responses may be alerting Office to check for authentication to allow extended functionality, but I remove the response header in IIS and it didn't make any difference.

The Authentication Provider for the FBA enabled site has "Enable Client Integration" set to "No". I've tried both the "yes" and "No" options but neither makes any difference.

share|improve this question
    
are your clients vista? –  djeeg Jan 26 '11 at 22:38
    
Gavin, Have you found a permanent solution to this? I am also experiencing the same issue. We only run SP2007 as an internal portal with auto-authentication happening via AD accounts. When staff try to open a Word or Excel file they get the prompt for credentials. Regardless of what they enter it will never be accepted as valid but if they just cancel out of the prompt the documents open fine. Hope that you can share your success with me. Thanks SS –  user3769 Jun 16 '11 at 19:50
    
Hmmm... I'm not getting links to reply to comments (or "add comment") for some reason so comment replies here: @djeeg - Clients are a mix of Windows versions - XP, Vista and Windows 7. @Sandra - Sorry, not found a solution to this issue yet myself. Please share if you find one. Cheers. –  Gavin Jun 20 '11 at 20:49
1  
Welcome to SharePoint.SE! You should modify your original question to add additional information. Regarding commenting, looks like you had two accounts so I went ahead and merged them. You should be able to leave comments for your question. Additionally, once you gain 50 reputation you'll be able to leave a comment anywhere. –  Kit Menke Jun 20 '11 at 21:50
add comment

2 Answers

up vote 0 down vote accepted

We have faced similar problems in Anonymous sites . When opening Office documents (Word and Excel) it asks for credentials . When we click on cancel in the Login Box the document opens

The fix which i used is mentioned below link and it worked

Link

share|improve this answer
    
Thanks Thomson - very much appreciated! I hope to try the solution soon and mark answer as correct if it works for us. Cheers, Gavin. –  Gavin Jul 20 '11 at 21:47
    
Thomson - you're a legend! You've just made a lot of users my end very happy indeed as we've been living with this issue since Nov 2010. Thank you :) –  Gavin Jul 21 '11 at 1:03
add comment

You'll want to disable the ViewFormPagesLockDown feature. Once that's disabled you should not get the authentication requests

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.