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.

Error 5785 – Unable to connect publishing custom string handler.


See the screenshot below.


Photobucket


Solution:


NB: Note that when the error appears for /_layouts/images/*.gif for a SharePoint Application
Add the following to the"web.config" file for the web application in the error just before </system.web> in the section <location path=''_layouts/images"/>


<httpModules>
  <remove name="PublishingHttpModule" />
</httpModules>





 

Error/Event 18456

Recently I had the oppurtunity to deploy hMail Server. I need a WebMail server to serve my hMail server email accounts.

On installing AfterLogic WebMail Pro (ASP.NET)on my home network, as part of the installation I needed to connect to my SQL DB, I supplied the credentials and got this error. Error 18456.
On further search on the net, i found this resource.

In this case the error included "State 6" . I then created an SQL account and provided same.

Issue resolved!

Friday

Issues: Uninstalling .Net 3.5 SP1

This week, I had 2 issues to deal with:
1. Upgrade PMPoint from v6 to v8.1
I performed the upgrade and it failed as I realised it had too many dependencies and made so many changes to the farm, therefore the installation didnt work as web.config had changed. So i rolled back.

This action then affected Doc Ave 4.5 which was running off another server in the SharePoint farm. After a bit of research, I found out that Doc Ave 4.5 does not support .NET 3.5 SP1 while this was a requirement for PMPoint v8.1. Now that means you need to beware of things like having to different applications on the same far having different requirements to function.

Issues:
1. Doc Ave client stopped communicating.

Solution:
1. Remove .Net 3.5 SP1
2. Uninstall .Net 3.0 SP2
3. Uninstall .Net 2.0 SP2
4. Install .Net 3.5 (no SP1)

RED ALERT! Once you remove .Net 3.5 IIS websites will start throwing up the following Errors 404 & 403.

To fix:

See
Doc Ave 4.5 Support

Finally from IIS Manager, goto Web Service Extensions and Allow ASP.NET

See Microsoft Support