Prompting for user credentials when any file (Excel) uploaded to SharePoint Server (2010)

Question

Hi,
When we open any excel file in SharePoint Server, we get the user credential popup (Domain Level). Not accepting the login credentials for any user. Please refer to the attached image. We are facing an issue after restating the SharePoint server.

Workaround and findings:

1. We have tried to restart the SharePoint IIS site.
2. Checked the IIS user authentication testing.
3. Tested for all authentications anonymous and user-defined.

We request immediate support on this issue.

Answer 1

Hi @Sanket Kathale ,

According to your description, I did some research and find some ways for your reference:

1, A hotfix is available to resolve this issue. After you apply this hotfix, you have to create a registry entry that is named "AuthForwardServerList." For more information, see the "Registry information" section.

Registry information

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 How to back up and restore the registry in WindowsTo enable this hotfix, follow these steps:

1. Click Start, type
   regedit in the Start Search box, and then press ENTER.
2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
3. On the Edit menu, point to
   New, and then click Multi-String Value.
4. Type AuthForwardServerList, and then press ENTER.
5. On the Edit menu, click
   Modify.
6. In the Value data box, type the URL of the SharePoint Server site, 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.
7. Exit Registry Editor.

After this registry entry is created, the Web Client service reads the entry value. If the client computer tries to access a URL that matches any of the expressions in the list, the user credentials are sent to authenticate the user, and the user is not prompted for the credentials.
Notes

• You must restart the Web Client service after you modify the registry.
• You can apply the registry change on any later Windows Operating System as well (no specific hotfix is required there, just the registry modification).

https://support.microsoft.com/en-us/topic/you-are-prompted-unexpectedly-to-enter-your-credentials-when-you-access-a-sharepoint-server-site-from-a-windows-based-computer-that-has-a-proxy-server-configured-fa4b4c6c-bdd1-d3d3-f973-aa6f2b1b99c5

2,

In Internet Explorer, go to ‘Tools’ Click on ‘Internet Options’ Open the Security tab, then click on the “Trusted Sites” Zone SharePoint Keeps Asking for Password? Add SharePoint Site’s URL to the Trusted sites zone. (Make sure you are adding FQDN to the site. E.g. Add: https://SharePoint.Crescent.com rather “*.Crescent.com” ) Now, Click on the ‘Custom level’ button Scroll down to the bottom and select ‘Automatic logon with current username and password Click OK sharepoint site keeps prompting for password The next time you log on, select “Remember my password”.

https://www.sharepointdiary.com/2012/04/sharepoint-keeps-asking-for-password.html#:~:text=Try%20these%20solutions%3A,and%20remove%20any%20credentials%20stored

Or you can bypass Windows Authentication by other means:

https://support.intermedia.com/app/articles/detail/a_id/25238/~/how-do-i-keep-sharepoint-from-asking-for-my-password-when-opening-the-site-%2F

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

It will be helpful if someone can connect with us on teams to discuss the above issue.
Please let me know.

Answer 3

Hi @Sanket Kathale ,

You can try this method:

Using Registry Editor

Step 1: Use Windows Icon + R to launch a Run menu

Step 2: Type the command “REGEDIT”

Step 3: Expand node “Computer -> HKEY_LOCAL_MACHINE -> CurrentControlSet -> Control”

Step 4: Locate Key by the name “Lsa” as shown below

Step 5: Add a new DWORD Entry

• Select “Lsa” Key
• On the right-hand side panel create a new DWORD Entry as shown below
• Enter “DisableLoopbackCheck” in Value Name field
• Enter “1” in Value Date Field
• Select “Hexadecimal” radio button
• Click OK to save the DWORD

Hope you find it helpful.

Also, currently according to our policy, we can only do forum support. If you want more direct support, you can open a ticket.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.