.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SharePoint 2007 - Opening an office document in portal demands authentication

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :SharePoint

Hi there,

Environemnt:  SharePoint 2007, SQL Server 2005

In order to get into Intranet portal it is required to enter USERNAME, PASSWORD [WINDOWS AUTHENTICATION]. That has been working fine for few years.

Now when the office document is opened it demands authentication, requiring the end user to enter username and pasword again. Can this be reverted? Once the credentials are entered first time to get into Intranet portal it should allow office documents to be opened without demanding authentication?

To simplyfy I would like to avoid the second time authentication while opending office document from SharePoint portal.

Help is appreciated.



Apriori algorithm [association rule]

View Complete Post

More Related Resource Links

Sharepoint 2007 Document Search and Highlight in Office 2007 and PDF


We will be implementing Document Search (DOC, DOCX, PDF, TIFF, PPT, PPTX, XLS, XLSX) for one of our customers. We were evaluating a few MOSS 2007 based solutions, and happened to visit your site.  What we intend to achieve are the following functionalities:


a.       User should be able to search through 1000s of documents which are in a Sharepoint Document Library

b.      The documents could be in English, International Languages.

c.       Each document is 70-100 pages, and therefore it is important that the Search Results show the relevant pages on which the Search Text appears (Get Highlighted) within each document . Clicking on the link will take the user to the right page.

d.      The additional requirement is Synonym search. So, I can search for

Opening office Documents in MOSS 2007 document Library.... You get a prompt to login...

*Sigh* i know i'm not the only one who has experienced this.   You have a Moss 2007 farm on your Server... yet you have employees and users who use Office 2003 products (word, excel, power point) Everything is installed correctly you yourself use office 2007. but don't post office 2007 docs.. just open the docs that people already post (2003 stuff) Computer Environment si am using....It does this in both Environments1st one Windows Vista Ultimate Updated Service Packs Office 2007 All update Serice Packs Internet explorer 7.0 2nd Environment Windows XP all updated Service Packs Office 2007 All updated Service Packs Windows Internet Explorer 7.0 Server Environment Moss 2007 with SP1 installed Microsoft 2003 Server No matter what happens.... when i try to open up a word documents or excel or anything.. when using office 2007..... it ask me for a login...I believe there was an article about correcting something in the registry or something.. can someone give me detail bulleted / bold instructions... this has been bothering me for a while.

Office 2007 Documents Open in Read-Only when Opening them from a WSS 2.0 Document Library

Hi, When any of our Windows 7 Pro computers that run Office 2007 Pro attempt to open a Word document that resides in a WSS 2.0 document library by using the drop down menu and selecting "Edit with MS Word", the documents open in read-only.  Our work-around is to save the document locally, modify it, and then save it back to the document library. We have some Windows XP and Vista systems that run Office 2007 and they are fine and can simply edit the document and save it.  We also have a handful of pc's that run Office 2003 and they are not having any issues either. Things I've tried: Office 2007 Repair - no luck Office Reinstall - no luck Some registry mod HKCU\Software\Microsoft\Office\12\Internet\OpenDocumentReadWrite=1 (noted on a MSKB article) - no luck and after re-reading the article it clearly states that this will not address content hosted on WSS or SPS sites Clearing IE temp files, resttting IE to defaults - no luck Once again, this only seems to happen to Win7Pro pc's that run Office 2007.  Honestly, I can't tell if IE8 has anything to do with this. Any thoughts or help would be extrememly appreciated. Thanks, Mike

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

Long delay opening Word documents from SharePoint 2007 with Office 2010


The first time a document is opened it's fine, opens in just a few seconds.

Subsequently, there is a long delay (about 20 seconds) in the "Contacting server for information..." step.

This happens to all users and all documents, each one will open fast the first time then slowly the second and subsequent times (until, we think, the app pool is recycled - there is no schedules iisreset/reboot).

This does not happen when using Office 2007.

IE6 and 7 exhibit the same behaviour.



Hi All,

We have applied the ADFC successfuly on our Moss 2007 environment. But we are not able to open the document in Office 2003 component.

But all the document are getting open in Office 2007 component. Any help or work around?


Unable to save Office 2007 document to SharePoint My Site Personal Documents document library


...also when Office documents are saved to document library they open as Read-only and cannot be saved back to the same document library.

This only happens in my production SharePoint 2007 environment from client XP and IE7 machine.  It does not happen in developement environment (which mirrors production) from client XP/IE7 machines.

Save works fine to SharePoint document libraries from client Win 7 and IE8 machines in both production and development environments.

This only happens when attempting to save to a My Site Personal Documents document library.  Any other document library this behavior does not exist from XP or Win 7 machine.

What settings controls ones ability to save to a personal My site document library.  What setting could be different between prod and dev installations?  It only happens

SharePoint 2007, Forms Based Authentication and Microsoft Office Protocol Discovery

On a SharePoint 2007 extranet site using FBA the Microsoft Office Protocol Discovery Options request is causing multiple authentication requests that must be closed. The best proposed "solution" I've found is to disable client integration for that zone. Has any other solution been found?

Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

Office Space: Security Programming in SharePoint 2007


This month Ted Pattison presents an overview of programming security and permissions for Windows SharePoint Services 3.0.

Ted Pattison

MSDN Magazine February 2008

Office Space: Events in SharePoint 2007


Windows SharePoint Services (WSS) 3.0 provides a new and improved infrastructure for handling server-side events. In this installment of Office Space, we look at techniques for hooking up Before Events and After Events using both Features and code.

Ted Pattison

MSDN Magazine November 2007

Office Space: Solution Deployment with SharePoint 2007


WSS 3.0 introduces a new deployment mechanism that lets you move your development efforts into a staging or production environment.

Ted Pattison

MSDN Magazine August 2007

Advanced Basics: Setting Word Document Properties the Office 2007 Way


The last time I wrote this column (March 2006), I shared an application that allows you to update all the Microsoft® Word documents in a folder and its subfolders. Each time the application finds a document in the specified path, it updates the document properties to match those you specified in the application.

Ken Getz

MSDN Magazine June 2006

How to enable Mixed authentication for single webapplication in sharepoint 2007?


Hi All,

      I have requiremnt to enable Mixed mode ( Windows & Forms Based) authentication on Single web application( with out extending). I have done it in Sharepoint server 2010, It is so simple also. But my requirement is on Moss 2007. I have found some Post and gone through Those posts, in those posts, all are suggesting to extend the default webapllication and enabling forms authentication on extending/Default application another one is on Wondows authentication.

  Is it way to suggest the client or any other alternative to enable the mixed mode authentication?

please suggest me with right solution. Thank you in advance.

Thanks & regards,

Naresh Kapa.


In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Running multiple websites in Sharepoint 2007 with AX2009 Enterprise Portal


I need to setup two separate webshops with public access and different layouts using AX2009 Enterprise Portal.

However I am uncertain how to implement two completely different layouts/designs because the Sharepoint Templates are located inside the 12 hive and not seperate for each website.

Can anybody give me some hints on how to do this - and if so, which requirements I have to meet (VSS 3.0 or MOSS Standard / Enterprise) in order to do it.

I am speculating whether I need to setup two separate web-servers with each own Sharepoint installation (and Business Connector Proxy)

Thanks in advance


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend