Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS V2: Prompted for credentials when trying to edit a document

  Asked By: Abhilash    Date: Jan 02    Category: Sharepoint    Views: 1690

Does anybody know why when I click on Edit document in Microsoft Word or Excel
or any of the office applications, I get prompted for username and password? I'm
already authenticated through the portal and I'm accessing this portal via the
extranet. The weird thing is that it only prompts me the first time for each
application. For example, it will prompt me the first time when I try to open
Excel and all Excel documents I open afterwards, I don't get prompted. This is
the same for all the office applications.



9 Answers Found

Answer #1    Answered By: Puneet Shiwde     Answered On: Jan 02

This is expected - the office  app needs to authenticate since it is
communicating directly with SharePoint. There's no good/secure way to pass
Basic auth credentials  between applications, so the 2nd prompt  is necessary.

Answer #2    Answered By: Brandyn Slater     Answered On: Jan 02

So I guess my next question is, does MS have a solution for this or is
this something we all have to deal with?

Answer #3    Answered By: Hubert Pollard     Answered On: Jan 02

There is no solution to this at this time  - this will happen whenever using
Basic authentication. This does not happen with Windows Integrated auth, but
that is not available in most (any?) extranet deployments.

Answer #4    Answered By: Gladys Trevino     Answered On: Jan 02

But I am using Integrated Authentication for my portal. I'm not using Basic.

Answer #5    Answered By: Jignesh Pitale     Answered On: Jan 02

If you are using integrated auth then you should not be receiving any
authentication prompts  at all - either for the portal  or Office. In this case
your Windows login credentials  are passed through seamlessly for both.

Answer #6    Answered By: Ravish Patel     Answered On: Jan 02

On another note, I was wondering if anybody has seen this problem. When I use
Basic Authentication, my portal  will not index therefore, the users are not able
to search for documents. When I use Integrated Authentication, my portal will
index and the users are able to search for documents. I have not been able to
figure this out. So that is another reason why I have my portal set to use
Integrated Authentication.

Answer #7    Answered By: Satyajit Kabadagi     Answered On: Jan 02

What if in XP you stored you logon and password  in the users control
panel? I believe this works.

Answer #8    Answered By: Kameron Richmond     Answered On: Jan 02

I tried that and still got prompted.

Answer #9    Answered By: Kenton Ewing     Answered On: Jan 02

To enlighten the subject:

1. When using basic auth user will be prompted  to enter credentials

a. First time  he/she enter the web page
b. First time an office  application is opened (i.e. by
clicking Edit in for instance). If you leave the Office application
opened then you will not be prompted for credentials

2. When using integrated auth user will be prompted to enter
credentials when

a. Client credentials  does not map to a valid Sharepoint

In that case, rules on 1 applies as well

b. A firewall is blocking the integrated challenge response
and preventing successful authentication (Then you need to switch to
c. The SharePoint site is recognized as not being in the
"Intranet Zone", this force authentication. To avoid this, add the
SharePoint in the Local Intranet Zone manually.

Although it is true that username/password can be cached with Windows
XP, I believe this may not work with Office depending on the version
(But I usually get inconsistent results with password  caching)