摘要:為何Excel 2007 無法發佈Excel Service 至 SharePoint 2007 of Windows 2008 Server?
這星期遇到一個很鳥的問題.就是Excel 2007 publish (發佈)成Excel Service 完全找不到MOSS Server.
其實跟本不是找不到而是認證過不了.
原因是因為
1.Sharepoint 2007不支援使用WebDav.
2.Windows Server 2008 IIS7的WebDav是另外安裝.
3.WebDav就算不啟用依然會改變IIS 7 的Application的認證方式.(實際情況我測試後並不知道是為什麼無法通過認證.)
會發生WebDav 405的錯誤.
解決方法:
若需要透過WSS Explorer View 請移除iis 7 WebDav
原文說明如下:
WebDAV, IIS, and SharePoint
Many people are under the misconception that SharePoint uses the WebDAV functionality provided by IIS 6.0. Actually, SharePoint provides its own WebDAV implementation using the Stsfilt.dll ISAPI filter that is installed with both Windows SharePoint Services and SharePoint Portal Server. Enabling or disabling the WebDAV extension in IIS 6.0 has no effect on SharePoint functionality.
You only need to enable WebDAV on IIS if you want to use the Web Sharing feature.
Correct. Sharepoint does not requied webdav at all, however if you want to use advance features of widnows explorer with sharepoint you need webdav enabled.
You can try yourself.
- With webdav disabled, Select a Document library with documents and open it in explorer view. called FPRPC in the white paper.
- Now enabled webdav (may need to reset IIS) and open the same library again and you will notice the left explorer sidebar has additional functionallity (Webdav).
- Also the site address will may change in win explorer. Without webdav it may be similiar to http://yoursite and with it enabled it wil be mapped as a file share \\Yoursite
- There is a client service called (webclient) that needs to be running on client machines (not the iis server) to use webdav. It is on by default on xp and off in win2003/win2008 (don't know about vista). If some users work and others don;t this may be the issue.
Note that this is windows explorer view and not sharepoint explorer view available on some doc lib types.
On Win2003 the webdav is enable at the IIS level and is turned on for all server applications.
-------------- Update/Wrong - Do Not Do This !! ------------------------
On Win2008 you will need to download and install the webdav http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1621 librarys and enabled in the "webdav authoring rules" for each application in IIS.
Again,
Not required in SPS/MOSS but available if required by your users or if you have processes where you want to treat a library like a standard file share for loads and extracts. (We ftp download files from a supplier and xcopy them to a doc library like it is a file share)
If is off by default due to security conisderations. My network guys do not like it and exposing it on the intranet is a bad idea. Turn on only if you need it and you have a secure environment.
------------------------------------------------------------
UPDATE:
If the WebDav http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1621 librarys is installed on Win2008 x64 it will break Sharepoint / MOSS Explorer view and cause security prompts on XP and possiably Vista clients. This will occur even if Win2008 webdav is not enabled for the for the Moss Web Application. Do not install if you want to use WSS 3.0 explorer view.
With much chagrin Christian, I stand corrected.
On the flip side if you wish to diable Sharepoint/Moss WebDav, install it...
請大家永躍參與Facebook MSBI 粉思團:http://www.facebook.com/#!/group.php?gid=303757165010