Thursday

Error: Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

Problem:
Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

Solution:

1. From the WFE (Web Front End). Type Run > Regedit
2. Then on the registry window go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa"
3. Right click on "Lsa" and create a new DWORD value
4. Give it a name "DisableLoopbackCheck"
5. Then edit the value of the DWORD "DisableLoopbackCheck" to "1"
6. Exit the windows registry and perfrom a new crawl of the content.

Wednesday

By the time you forget the SharePoint Services Account Password

How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0


I believe this article is very useful for SharePoint Administrators who may come across problems when you dont know how to find the SharePoint Services Accounts password.

See this link from Microsoft - http://support.microsoft.com/kb/934838

The Execute Permission was denied on the object 'proc_UpdateVirusInfo'

Problem with 'proc_UpdateVirusInfo'
Event 5214, Category: Database, SharePoint Web Front End.

Insufficient SQL Database permissions for user "xxxxx" in database 'SharePoint_AdminContent_xxxx'
The EXECUTE permission was denied on the object 'proc_UpdateVirusInfo'





Solution:
1. Ensure that the service account indicated in this error is a login on the SQL Server. 
2. Go to the SQL Server.
Expand the Instance > Expand Databases > Locate the database SharePoint_AdminContent_xxxx (indicated in the error)
3. Expand Programmability > Expand Stored Procedures
4. Locate 'dbo.proc_UpdateVirusInfo'
5. Right-click and select properties
6. In the new window, select Permissions, Add the user indicated in the error and apply Grant for Execute


7. Click Ok

Thursday

SharePoint Columns: Extract the First Letter in a Full Name Colum

I was creating a list of names and I needed to extract the first letter in a Full name column that I could use it in a list view grouping so a name can be found easily using the first letter of the surname.

Solution:
1. Create a calculated column (e.g Name Letter)
2. Insert the following formula without the quotes "=LEFT([Surname],1)", where Surname is the column you need to extract the first letter.

Useful links
- http://office.microsoft.com/en-us/excel-help/left-leftb-functions-HP010062568.aspx
- http://sharemypoint.in/2009/03/04/sharepoint-calculated-columns-formulas/

SpamAssassin Rule: FH_DATE_PAST_20XX

Fix: FH_DATE_PAST_20XX The date is grossly in the future

Currently I am running a mail server running Hmail. I've got SpamAssassin running to eliminate spam. But most clean mails that gets delivered has the SPAM tag attached to the subject.

I see the report in the body of the mail.
"3.4 FH_DATE_PAST_20XX The date is grossly in the future"

I checked my mail server date settings and made sure the date is synced with a time server.
But I was still getting clean mails with the Subject having "*****SPAM****"
This sometimes means the mail is unreadable or filled with gibberish.

Then I noticed the "FH_DATE_PAST_20XX" seems to be the culprit. Now here what I did to solve it.

1. Edited the local.cf file. This file can be found in (Installation location)/etc/spamassassin/local.cf

2. Edited the (installation location)/share/spamassassin/72_active.cf file

3. Ran the sa-update


And this has solved the problem.