Login prompt appearing when opening Office documents
Each timeI open an Office document in a SharePoint library, I have to re-enter my credentials. I am using MOSS 2007, Windows XP and IE 7. I've checked the 'remember my password' option when being prompted for my credentials. The strangest thing is even that when I press Cancel on the pop-up window asking for my credentials, the document is still opened... I found already some posts around this matter and tried already following suggestions: * I added my site to the trusted sites * I checked that 'basic authentication' is unchecked under Central Administration -> Application Management -> Authentication Providers * I've added my credentials for the server hosting the SharePoint environment in the managed passwords for my user account in the control panel (though I am not 100% sure of having this done correctly. It is asking upon entering an extra credential for a server name. I entered here the same name as the one appearing on top of the pop-up window asking for credentials, after 'connect to') Opening .pdf, .zipfiles is not asking for the credentials. So it is only Microsofts own files which are creating the problem.Moreover, using FireFox, you don't have the problem. But I don't think it should be recommended upon selling MOSS to use FireFox with it to have a more user-friendly interface... Anybody knowing how to fix my issue?
August 16th, 2007 3:19pm

The fix of adding the site to Trusted Sites works for IE*6*. For IE7 the equivalent is adding the site to the Intranet Security Zone. (Note that although this seems mad as Intranet is surely a subset of Trusted, it isn't. It does work! [usually]) Mike Walsh
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2007 12:18pm

What OS are you using for your client, and what version of Office? There is a known issue with Vista/Office 2007 that will sometimes cause this, details at http://blogs.msdn.com/sharepoint/archive/2007/10/19/known-issue-office-2007-on-windows-vista-prompts-for-user-credentials-when-opening-documents-in-a-sharepoint-2007-site.aspx
January 9th, 2008 12:04am

Bryan, thanks for the link. Changing that connection setting does in fact seem to do the trick. Although I could have sworn I've seen this behavior on XP as well. I'll have to do more testing to verify. Thanks again. Dana
Free Windows Admin Tool Kit Click here and download it now
January 9th, 2008 5:54pm

hey all, I'm having almost the exact same problem as patrick in the exact same environment (moss 2007 ie6 and ie7) firefox does not have this issue i can open all files (txt, zip, pdf, ..etc) except and word and xls (haven't tested ppt or xml files yet in firefox, but for whatever reason not in ie6 or 7... the only difference is, is that hitting the esc key doesn't open the any office documents. this is only on the extranet, i've changed, and added my site to the trusted on both intranet and internet sites, made sure ot allow auto logon on both and still no good. this is definitely a office issue and it really shouldn't be. does anyone have a clue?
February 1st, 2008 11:41am

Hi, Try with this Kb: http://support.microsoft.com/kb/932118/en-us If the problem is accesing docs from Internet and you are publishing sharepoint withisaserver,this is a common issue and occurs because Word (orother non-web apps)is seen as a new session by ISA and hence the authentication cookie provided to the web browser is only valid for that particular web session and not Word; hence the addtional authetication prompt. The common way to fix the issue is to enable a feature called "persistent cookies" which essentially creates a machine cookie which can be used by ALL applications on the machine. The downside to this approach is that this is not a great security solution if used on non-managed PCs like Internet cafes etc. A good compromise is to enable persistent cookies only on private computers, this way if the user clicks on the private computer option in the ISA form, they will use persistent cookies, but if they choose public, they will not. The only downside is that if users choose the wrong option, it could mean that a persistent cookie could be applied to a public machine. The persistent cookies do have a timeout value, so this providessome level of protection and can be modified to meet your paranoia level Regards, Hector
Free Windows Admin Tool Kit Click here and download it now
March 18th, 2008 6:56pm

Hi Hrsanchez How do you enable the feature "persistent cookies". Is this something you should enable on your ISA or your IIS? Or is this feature enabled just by choosing the "This is a private computer" option upon logon in the ISA form?
March 18th, 2008 11:40pm

Hi, Patrik, Persistent cookies are enabled in the Forms=>Advanced tab on the web listener you are using for SharePoint. Hector
Free Windows Admin Tool Kit Click here and download it now
March 19th, 2008 3:50pm

Well I got it to work...partially.I had the client IE browser set to Trusted Site, with a custom setting of "automatically logon with current username/password." Now, with FBA, I get the initial login, then a 2nd authentication window which when I login too, everything afterwards works great. I can open up documents, check-out, check-in, edit, etc.... without a windows authentication prompt. The question is, why does the 2nd window of authentication come up again? Didn't I get through with the FBA?
October 2nd, 2008 9:22pm

I am having the same problem of double authentication request when opening Office docs from Sharepoint, but only in Window 7. XP systems accessing the same docs on the same domain with either IE 6, 7 or 8 have no problem and open fine. Trying to open the same doc's within IE 8 on a windows 7 system cause the credentials prompt, but cancelling it still allows the document to open. Only happens with Office docs (pdf's and jpg's etc are fine). Strangely if you checkout the document for editing, it opens but doesn't prompt for credentials. Has anyone solved this issue yet?
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2009 7:18pm

Hi,I have solved the issue with following trick. I created the link as follows: <a href="javascript:STSNavigate('http://<servername>:<port>/_layouts/download.aspx?SourceUrl=/doc lib name/documentname.doc');">download a copy</a>Hope this helps.Thanks,Gaurav Dixit
November 23rd, 2009 3:58pm

Hi,I am experiencing the same issue however I am on windows 7. I tried the settings as above regarding the "Automatic logon with Current Username and Password" however I still get the prompt for credentials. Any ideas if there is a fix for this on windows 7?Anesh| http://christopheranesh.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2010 6:48pm

I have spent far too long on this one.Simpley put Windows XP & Windows 7 is fixable. Vista is notWindows XP has no issues with logging in as it knows to use persistant cookiesWindows 7 slips up because of the different security zones....IE7/8 are in the low zone, Office in the medium and High end Admin processes in the High zonePersistant cookies stored in the low zone aren't available to apps in the medium zoneMake the SharePoint site a trusted site and the cookie gets promoted to the medium zone and hey ho its all worksWindows Vista has the same issue as Windows 7 but it also has the issue that Windows Vista & Office communicate via webdav which effectively sends your login credrentials up to SharePoint and ignores the persistant cookies. There are registery hacks, and ways of disabling webdav and installing web folders (the old xp system of connecting to drives on sharepoint) but they are all potentially dangerous and shouldn't be deployed.Solution: Use SharePoint as an Intranet service, with external access being given via VPN until you upgrade to Windows 7. Or downground everyone to XP.MS have been aware of the Vista webdav issue for many years. Its fixed in Windows 7 but nothing has been done about vista
January 26th, 2010 11:05pm

Fin H,What's the fix for Windows 7? I can't seem to find a fix that works for me. When I was on Vista, what worked for me was to put office 2007 products in XP Sp2 mode. i did it with GPO making a reg change. This fix doesn't work for Win7. How did you fix your win7 problem?
Free Windows Admin Tool Kit Click here and download it now
January 28th, 2010 5:11pm

Guarav-You are a lifesaver! I've been searching far and wide for a js workaround like this. It worked for me. THANK YOU.Joe
February 10th, 2010 9:30pm

Set WINWORD.EXE to XP SP2 compatibility and that fixed it for me. Tried everything else listed above first without success. I am running on Win 7 through Forefront Threat management Gateway (ISA 2010).
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2010 7:14pm

We i have read through teh entire forum and have tested this well. no matter what, it will still prompt for credentials.KB http://support.microsoft.com/kb/838028 explains the same though it is not published for Office 2007 but the behavior is the same.1. if you have a site which prompts for credentials at the time of login, office would also prompt for credentials but if the versioning is not enabled, it should work fine.Elseto you would have to publish teh site anonymously.KB838028You may be prompted for authentication when you open Office files. This behavior occurs if the Web server requires authentication to process an OPTIONS call to the URI of the folder. Changes to the server configuration can typically be made to avoid this problem by giving anonymous users browse permissions to the folder. Browse permissions are also know as list permissions. The prompt for authentication is expected if the server requires authentication.
February 23rd, 2010 8:17pm

Hello the solution to login prompt is checking "Use Remote Interfaces" to true in the actual site permissions level Site Permissions Permission Full Control Design Contribute Read Limited Access Use Remote Interfaces X X X X X Yee Momo
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2010 8:14pm

Replying to Mahamed Hachem:Use Remote Interfaces is "Use SOAP, Web DAV, or SharePoint Designer interfaces to access the Web site. "I believe it will reduce the security level of the site.Sara
March 19th, 2010 12:43am

I dont know if this has been resolved or not but a very helpful source is the following link http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/023f4b23-3ce6-4d83-8cb0-7398b88ba6ab/?prof=required Uninstalling WebDav from your Sharepoint Servers will resolve the problem. Above link also talks about the misconception where you need WebDav installed as part of server but actually Sharepoint works with its own version of WebDav. Besides Password prompts, you also resolve the Open in Windows Explorer issues by uninstalling WebDav. Hope it helps.lJawad
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2010 6:27pm

HI All i had this problem from long time . finally we solved and the problem was on Host header configuration during create web application, you shouldn't PUT THE FQDN never that was the main problem Ex. Sharepoint.contoso.local with prompt for Authentication or re-authenticate Ex2.Sharepoint only and you creat Canme for you dns point to the IP address that will work to change the Host Header or Site URL after creation follow this : to make it simple, please follow the following steps to configure AAM (alternate access mapping) On the Alternate Access Mappings page, click Edit Public URLs . If the mapping collection that you want to modify is not specified, then choose one. In the Alternate Access Mapping Collection section, click Change alternate access mapping collection on the Alternate Access Mapping Collection menu. On the Select an Alternate Access Mapping Collection page, click a mapping collection. In the Public URLs section, you may add new URLs or edit existing URLs in any of the following text boxes: Default, Intranet, or you can change the Default from http:// Sharepoint.contoso.local to http://Sharepoint Click Save . Now you’ll have to switch over to your DNS server. Within the DNS Management Console and Under Forward Lookup Zones: Add a new Primary Zone with your new domain name. Add a new Host (A) to the records for http://Sharepoint and point the IP Address to the sharepoint server DON'T Ever Make any modifications from IIS make all from Central Administration Cheers,
June 21st, 2010 10:50am

The FQDN removal fixed the issue for me. WSS 3.0 on 2003 Server with a mixed XP/Vista/7 Environment all with office 2007.
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2010 4:37pm

If your site is a FQDN then you need to implement this fix http://support.microsoft.com/?id=943280 For Vista machines pre SP1 you need to apply the hotfix and implement the regkey fix in the article. IF you have Vista Sp2 then the hotfix is not needed but the regkey is. For Windows7 all you will need to do is the regkey fix. Registry information To use this hotfix, you have to modify the registry. Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: 322756 (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows After you apply this hotfix, you have to create a registry entry. To do this, follow these steps: Click Start, type regedit in the Start Search box, and then press ENTER. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters On the Edit menu, point to New, and then click Multi-String Value. Type AuthForwardServerList, and then press ENTER. On the Edit menu, click Modify. In the Value data box, type the URL of the server that hosts the Web share, and then click OK. Note You can also type a list of URLs in the Value data box. For more information, see the "Sample URL list" section in this article. Exit Registry Editor. After this registry entry is created, the WebClient service will read the entry value. If the client computer tries to access a URL that matches any of the expressions in the list, the user credential will be sent successfully to authenticate the user, even if no proxy is configured. Note You have to restart the WebClient service after you modify the registry. Sample URL list The following is a sample URL list: https://*.Contoso.com http://*.dns.live.com *.microsoft.com https://172.169.4.6 This posting is provided "AS IS" with no warranties, and confers no rights
July 9th, 2010 6:43pm

Why is this marked as Answer????
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2010 6:03am

I have probably spent hours, if not days, scouring technet and the internet for an answer for these symptoms. My particular issue happens with my XP pcs which are running Office 2010, IE8, and they are accessing MOSS 2007 Office files. This does not happen with my Windows 7 pcs. The sharepoint site is part of the "Trusted Sites" zone and it is set to "Low". Here is what I have found regarding my particular issue. Issue: This issue occurs when a user changes their password on a Windows XP pc. They have saved their login information while accessing an Office document before. Stored login information does not seem to change and causes Office files to not open correctly from the sharepoint website because the PC seems to use "bad" login information. There may be 2 username/password prompts but one does not show itself because the information is saved. Clearing the stored information through normal methods (Internet Explorer’s saved passwords and XP’s “Stored User Names and Passwords”) does not work. I have not been able to confirm (yet) that if a user does not save their login information that they do/don't encounter this issue. Symptoms: This only happens with Office files on sharepoint. The issue does not happen while using a 3rd party browser. Symptoms include but not limited to: a delay in opening the file, possibly multiple login prompts, file may eventually open, file might not save, and a login prompt while closing the file. Fix: This can be done with the Admin or users's account. First close all Internet Explorer windows. Go to this location for the user with the issue: C:\Documents and Settings\%Username%\Application Data\Microsoft\Credentials. There may be multiple folders and I believe they may safely be renamed. Rename each folder by adding a “.bac” (no quotations) to it so they can be restored if there is an issue. Go back to the sharepoint website, login, and test opening an Office document. It worked for me! I hope this helps others because of the amount of time I spent trying to find an answer.
November 23rd, 2010 12:28pm

Thanks to all for suggestions on how to fix this. I have created a tutorial to solve the login prompt once and for all. http://www.uv.mx/personal/gvera/2010/09/28/sharepoint-login-prompt-when-accessing-files-in-a-document-library/ Hope it helps you.
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 2:26pm

I have a slight modification on the issue above. Users of 32 bit WinXP have no problems, users if Windows 7 x64 have no problems, however Users if Wondows 7 x32 with Office 2007 see a login prompt every time they try to access an office document. However canceling the login prompt causes the document to open anyway. If a user selects "Edit this document in Word" (or excel or powerpoint etc) then the document opens without a login prompt. So far none of the options listed above have worked. If anyone has any furhter sugestions it would be much appreciated.
February 10th, 2011 6:38am

I have a slight modification on the issue above. Users of 32 bit WinXP have no problems, users if Windows 7 x64 have no problems, however Users if Wondows 7 x32 with Office 2007 see a login prompt every time they try to access an office document. However canceling the login prompt causes the document to open anyway. If a user selects "Edit this document in Word" (or excel or powerpoint etc) then the document opens without a login prompt. So far none of the options listed above have worked. If anyone has any furhter sugestions it would be much appreciated.
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2011 6:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics