SharePoint 2007 and Credentials when Opening a Document

Posted on 2012-09-04
Last Modified: 2012-09-11
I have an single SharePoint 2007 server set up in a DMZ with a connection back to a SQL server inside the firewall.

I have a Shared Documents library set up that is having lots of documents uploaded to it which others are then having to open, manipulate, etc.  

I have received the complaint that the users do not like having to enter their SP credentials each and every time they open a new document.

I have read a work around to have the user open a document (enter their credentials) close the document, but not the application.  This of course works for some but not others and I don't know why.

I am a real beginner in administration of SharePoint and didn't know if there was something that I could change to make it so that this was not so tedious.  The user accounts are set up locally on the box and then given permission to the sites they need and as well as have profiles established if they need to receive emails.  (Just details that I thought I should provide to help troubleshoot).

Thank you for any help that you can provide.
Question by:mounty95
    LVL 38

    Expert Comment

    Couple of things could cause this issue.

    1. Not having Alternate Access Mappings properly set for the web application.  If users are accessing a web app with a URL not registered on the web app, it can cause problems.  Just verify in Central Admin - Web App Management - Alternate Access Mappings

    2. There has always been a bug between certain OS and Office versions with SharePoint 2007.  In these cases, the following registry edit must be made:

    Author Comment

    1.  I am not sure how the mappings are supposed to be set up.  I have four Internal URLs set up for the Default Zone.  I have read information in the SharePoint 2007 Bible on this and it doesn't make sense to me how I should set this up.  So to say that the URL mappings are not set up right.  I am not sure how they should be.  I can say that the users can access an Internal review in the default zone that is mapped to a Public URL for Zone.

    2.  I am wondering whether the fact that some users are using Office 2010 and the SharePoint server is 2007 could possibly be the problem.

    Any further clarification that you can make on the Alternate Access Mappings would be greatly appreciated.
    LVL 38

    Expert Comment

    For your setup, as long as the URL that users are accessing your site with, is registered as an internal URL (with the matching public URL), you should be fine.  Please double check that if you are using https, it says so in the mapping.

    I would do a test on one of the users with the problem, make the registry change on their machine, see if it fixes the issue.

    Author Comment

    The URL that users are accessing my site with is registered as an Internal URL.  I do not use https so that is not an issue in that everything registered is simply http://.

    I will try the registry change and get back to you.

    Thank you for the quick response.
    LVL 6

    Expert Comment

    Also you can add site into local intranet zone in user's browser (Internet options->security tab->local intranet->sites->add site to this zone), if for some reasons it is not detecting automatically.
    LVL 2

    Accepted Solution

    On the user machine in internet explorer add the site in trusted zone
    Then later in the custom level select the option "Automatically logon with the current username and password"
    Check if this works.

    Author Closing Comment

    So two things to add to this solution:
    1.  If you add the site under Trusted Sites you can't then add it under Intranet Sites and this isn't even an Intranet Site to be able to add so adding to Trusted Sites works.
    2.  Using Google Chrome instead of Internet Explorer or Firefox eliminated the credential prompting all together (once you had logged into the SharePoint site initially).

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    This video discusses moving either the default database or any database to a new volume.
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now