How to change e-mail address to a MOSS 2007 user

You can find the users e-mail address information for MOSS 2007 in the UserInfo table on the Content Database for your MOSS 2007 site. The field is tp_Email.

Using a simple SQL UPDATE statement you can change the value for the e-mail. Be careful to select only the record you need.

MOSS 2007: cannot delete a question in a survey (Unknown Error)

Problem: In a MOSS 2007, when try to delete a question in a survey a message saying Unknow Error (before SP2) or Unable to validate data.   at System.Web.Configuration.MachineKeySection (after SP2) is displayed.

Resolution: in the web server browse to the path C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS, open the file mngfield.aspx (if MOSS is not installed in the default paths, browse for the file) in Notepad and add the following line:

<asp:Content ContentPlaceHolderId="PlaceHolderSearchArea" runat="server">
</asp:Content>

We have MOSS installed in a front end server and the database in a backend server. I don´t know if other configurations this solution could work.

MOSS 2007 LOG file is big

Problem: In our MOSS 2007 server log file for SharePoint_Config database is huge, almost 14 GB size. We need to shrink the file and recover hard disk space.

Resolution: Execute the following SQL Sentence for the database above

USE SharePoint_Config
GO
DBCC SHRINKFILE(SharePoint_Config_log, 1)
BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
DBCC SHRINKFILE(SharePoint_Config_log, 1)

Office documents prompt for password in anonymous SharePoint site

Problem: In a SharePoint site published in the Internet as anonymous, opening Office Documents in Internet Explorer prompts for password. Pressing the Cancel button opens the file.

Solution: You can check the solution in http://www.objectsharp.com/cs/blogs/max/archive/2008/04/21/enabling-anonymous-access-on-moss-2007-wss-3-0-web-applications.aspx. We implemented it but after a while (may be weeks) the problem rose again. Trying to implement the same solution again did not work.

Our environment uses Microsoft ISA Server 2006 as firewall so we configure the http filter on the web site publishing rule so that it do not allow the verb OPTIONS. After that, the problem was solved. Using this approach, our internal users can still use the advanced features that are disabled when you implement the solution in the link above and our external users can open the files without the prompt.