I noticed recently that I was getting an error in my Application Event log every time the WSS Search Service ran. That means an error every five minutes, which is a little disheartening. One option is to change the WSS index schedule so that the error only occurs once per day – but some might say that is avoiding the issue. Which I suppose is a fair point.
The error that was showing up in my Application Event Log was:
Event ID 2424
The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again.
Context: Application 'Search', Catalog 'index file on the search server Search'
I fixed this by going to Central Administration – Operations – Services on Server. I selected the Windows SharePoint Services Search entry. I then changed the Service Account username and password to match the Content Access Account details. Click OK on the bottom of the page and wait five minutes.
Once I saw that the error was no longer being logged I went back and set the Service Account back to its original username and password. Still no sign of the error. I also verified that WSS was indexing content again.
So a bit of a strange issue. It looks like some settings got messed up along the way and just need to be reset. I did notice that the error started to happen after some scheduled maintenance on the SQL Server. I'll have a word with the SQL Admin and see what he's been up to.
16 comments:
Thank you for this! I just spent 3 hours trying to sort out the problem and the answer is so simple!
Thanx a bundle from me as well. I had the same error immediately after installation of moss - don't blame the SQL guy too quickly.
Well I tried and it didn't work. The same error 2424 is still logged. At first look, WSS was using a pre-defined account (local). I changed the accounts to "administrator" and my own account (an administrator) and no go on either one. WSS 3.0 is installed as stand-alone next to WSS 2.0 within SBS 2003 SP1. Any other ideas??
Thank you very much. I had the same problem and I find this to be non-intuitive by Microsoft. It should be possible to run the service under a higher level account and then simply control it from within the SharePoint interface. Simply solution for a poor user interface by MS.
Sorted mine at as well :-)
I've spent days trying to resolve this issue.. Thanks a million for your tip! You've just made my day....
I noticed this error after installing AVG Antivirus. I had to make an exception for the local machine in AVG's web shield settings.
Great, you save my day
Same situation
LAB Description
One Windows 2008 Forest
One Windows 2008 Domain
One MOSS 2007 SP1 Server on Windows 2008
One SQL 2008
After try to star WSS services
Windows SharePoint Services Search content access
Windows SharePoint Services Search
using two accounts
I got unkonw error, looking at event viewer, just an error Unknown SQL Exception 262 occured. Additional error information from SQL Server is included below.
How I deal to solve, after fail database is created but without tables, I add both login for each wss service as logins, and give to moss setup users and wss seach and contente users listed permission that follow
CREATE TABLE permission denied in database 'WSS_Search_MOSSW2K8'.
USE [WSS_Search_MOSSW2K8]
CREATE USER [test\wsssearsrv] FOR LOGIN [test\wsssearsrv]
USE [WSS_Search_MOSSW2K8]
CREATE USER [test\wsssearcont] FOR LOGIN [test\wsssearcont]
USE [WSS_Search_MOSSW2K8]
GRANT ALTER ANY APPLICATION ROLE TO [test\setup]
GRANT ALTER ANY ASSEMBLY TO [test\setup]
GRANT ALTER ANY ASYMMETRIC KEY TO [test\setup]
GRANT ALTER ANY CERTIFICATE TO [test\setup]
GRANT ALTER ANY CONTRACT TO [test\setup]
GRANT ALTER ANY DATABASE AUDIT TO [test\setup]
GRANT ALTER ANY DATABASE DDL TRIGGER TO [test\setup]
GRANT ALTER ANY DATABASE EVENT NOTIFICATION TO [test\setup]
GRANT ALTER ANY DATASPACE TO [test\setup]
GRANT ALTER ANY FULLTEXT CATALOG TO [test\setup]
GRANT ALTER ANY MESSAGE TYPE TO [test\setup]
GRANT ALTER ANY REMOTE SERVICE BINDING TO [test\setup]
GRANT ALTER ANY ROLE TO [test\setup]
GRANT ALTER ANY ROUTE TO [test\setup]
GRANT ALTER ANY SCHEMA TO [test\setup]
GRANT ALTER ANY SERVICE TO [test\setup]
GRANT ALTER ANY SYMMETRIC KEY TO [test\setup]
GRANT ALTER ANY USER TO [test\setup]
GRANT ALTER TO [test\setup]
GRANT AUTHENTICATE TO [test\setup]
GRANT BACKUP DATABASE TO [test\setup]
GRANT BACKUP LOG TO [test\setup]
GRANT CHECKPOINT TO [test\setup]
GRANT CONNECT REPLICATION TO [test\setup]
GRANT CONTROL TO [test\setup]
GRANT CREATE AGGREGATE TO [test\setup]
GRANT CREATE ASSEMBLY TO [test\setup]
GRANT CREATE ASYMMETRIC KEY TO [test\setup]
GRANT CREATE CERTIFICATE TO [test\setup]
GRANT CREATE CONTRACT TO [test\setup]
GRANT CREATE DATABASE DDL EVENT NOTIFICATION TO [test\setup]
GRANT CREATE DEFAULT TO [test\setup]
GRANT CREATE FULLTEXT CATALOG TO [test\setup]
GRANT CREATE FUNCTION TO [test\setup]
GRANT CREATE MESSAGE TYPE TO [test\setup]
GRANT CREATE PROCEDURE TO [test\setup]
GRANT CREATE QUEUE TO [test\setup]
GRANT CREATE REMOTE SERVICE BINDING TO [test\setup]
GRANT CREATE ROLE TO [test\setup]
GRANT CREATE ROUTE TO [test\setup]
GRANT CREATE RULE TO [test\setup]
GRANT CREATE SCHEMA TO [test\setup]
GRANT CREATE SERVICE TO [test\setup]
GRANT CREATE SYMMETRIC KEY TO [test\setup]
GRANT CREATE SYNONYM TO [test\setup]
GRANT CREATE TABLE TO [test\setup]
GRANT CREATE TYPE TO [test\setup]
GRANT CREATE VIEW TO [test\setup]
GRANT CREATE XML SCHEMA COLLECTION TO [test\setup]
GRANT DELETE TO [test\setup]
GRANT EXECUTE TO [test\setup]
GRANT INSERT TO [test\setup]
GRANT REFERENCES TO [test\setup]
GRANT SELECT TO [test\setup]
GRANT SHOWPLAN TO [test\setup]
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [test\setup]
GRANT TAKE OWNERSHIP TO [test\setup]
GRANT UPDATE TO [test\setup]
GRANT VIEW DATABASE STATE TO [test\setup]
GRANT VIEW DEFINITION TO [test\setup]
GRANT ALTER ANY APPLICATION ROLE TO [test\wsssearcont]
GRANT ALTER ANY ASSEMBLY TO [test\wsssearcont]
GRANT ALTER ANY ASYMMETRIC KEY TO [test\wsssearcont]
GRANT ALTER ANY CERTIFICATE TO [test\wsssearcont]
GRANT ALTER ANY CONTRACT TO [test\wsssearcont]
GRANT ALTER ANY DATABASE AUDIT TO [test\wsssearcont]
GRANT ALTER ANY DATABASE DDL TRIGGER TO [test\wsssearcont]
GRANT ALTER ANY DATABASE EVENT NOTIFICATION TO [test\wsssearcont]
GRANT ALTER ANY DATASPACE TO [test\wsssearcont]
GRANT ALTER ANY FULLTEXT CATALOG TO [test\wsssearcont]
GRANT ALTER ANY MESSAGE TYPE TO [test\wsssearcont]
GRANT ALTER ANY REMOTE SERVICE BINDING TO [test\wsssearcont]
GRANT ALTER ANY ROLE TO [test\wsssearcont]
GRANT ALTER ANY ROUTE TO [test\wsssearcont]
GRANT ALTER ANY SCHEMA TO [test\wsssearcont]
GRANT ALTER ANY SERVICE TO [test\wsssearcont]
GRANT ALTER ANY SYMMETRIC KEY TO [test\wsssearcont]
GRANT ALTER ANY USER TO [test\wsssearcont]
GRANT ALTER TO [test\wsssearcont]
GRANT AUTHENTICATE TO [test\wsssearcont]
GRANT BACKUP DATABASE TO [test\wsssearcont]
GRANT BACKUP LOG TO [test\wsssearcont]
GRANT CHECKPOINT TO [test\wsssearcont]
GRANT CONNECT REPLICATION TO [test\wsssearcont]
GRANT CONTROL TO [test\wsssearcont]
GRANT CREATE AGGREGATE TO [test\wsssearcont]
GRANT CREATE ASSEMBLY TO [test\wsssearcont]
GRANT CREATE ASYMMETRIC KEY TO [test\wsssearcont]
GRANT CREATE CERTIFICATE TO [test\wsssearcont]
GRANT CREATE CONTRACT TO [test\wsssearcont]
GRANT CREATE DATABASE DDL EVENT NOTIFICATION TO [test\wsssearcont]
GRANT CREATE DEFAULT TO [test\wsssearcont]
GRANT CREATE FULLTEXT CATALOG TO [test\wsssearcont]
GRANT CREATE FUNCTION TO [test\wsssearcont]
GRANT CREATE MESSAGE TYPE TO [test\wsssearcont]
GRANT CREATE PROCEDURE TO [test\wsssearcont]
GRANT CREATE QUEUE TO [test\wsssearcont]
GRANT CREATE REMOTE SERVICE BINDING TO [test\wsssearcont]
GRANT CREATE ROLE TO [test\wsssearcont]
GRANT CREATE ROUTE TO [test\wsssearcont]
GRANT CREATE RULE TO [test\wsssearcont]
GRANT CREATE SCHEMA TO [test\wsssearcont]
GRANT CREATE SERVICE TO [test\wsssearcont]
GRANT CREATE SYMMETRIC KEY TO [test\wsssearcont]
GRANT CREATE SYNONYM TO [test\wsssearcont]
GRANT CREATE TABLE TO [test\wsssearcont]
GRANT CREATE TYPE TO [test\wsssearcont]
GRANT CREATE VIEW TO [test\wsssearcont]
GRANT CREATE XML SCHEMA COLLECTION TO [test\wsssearcont]
GRANT DELETE TO [test\wsssearcont]
GRANT EXECUTE TO [test\wsssearcont]
GRANT INSERT TO [test\wsssearcont]
GRANT REFERENCES TO [test\wsssearcont]
GRANT SELECT TO [test\wsssearcont]
GRANT SHOWPLAN TO [test\wsssearcont]
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [test\wsssearcont]
GRANT TAKE OWNERSHIP TO [test\wsssearcont]
GRANT UPDATE TO [test\wsssearcont]
GRANT VIEW DATABASE STATE TO [test\wsssearcont]
GRANT VIEW DEFINITION TO [test\wsssearcont]
GRANT ALTER ANY APPLICATION ROLE TO [test\wsssearsrv]
GRANT ALTER ANY ASSEMBLY TO [test\wsssearsrv]
GRANT ALTER ANY ASYMMETRIC KEY TO [test\wsssearsrv]
GRANT ALTER ANY CERTIFICATE TO [test\wsssearsrv]
GRANT ALTER ANY CONTRACT TO [test\wsssearsrv]
GRANT ALTER ANY DATABASE AUDIT TO [test\wsssearsrv]
GRANT ALTER ANY DATABASE DDL TRIGGER TO [test\wsssearsrv]
GRANT ALTER ANY DATABASE EVENT NOTIFICATION TO [test\wsssearsrv]
GRANT ALTER ANY DATASPACE TO [test\wsssearsrv]
GRANT ALTER ANY FULLTEXT CATALOG TO [test\wsssearsrv]
GRANT ALTER ANY MESSAGE TYPE TO [test\wsssearsrv]
GRANT ALTER ANY REMOTE SERVICE BINDING TO [test\wsssearsrv]
GRANT ALTER ANY ROLE TO [test\wsssearsrv]
GRANT ALTER ANY ROUTE TO [test\wsssearsrv]
GRANT ALTER ANY SCHEMA TO [test\wsssearsrv]
GRANT ALTER ANY SERVICE TO [test\wsssearsrv]
GRANT ALTER ANY SYMMETRIC KEY TO [test\wsssearsrv]
GRANT ALTER ANY USER TO [test\wsssearsrv]
GRANT ALTER TO [test\wsssearsrv]
GRANT AUTHENTICATE TO [test\wsssearsrv]
GRANT BACKUP DATABASE TO [test\wsssearsrv]
GRANT BACKUP LOG TO [test\wsssearsrv]
GRANT CHECKPOINT TO [test\wsssearsrv]
GRANT CONNECT REPLICATION TO [test\wsssearsrv]
GRANT CONTROL TO [test\wsssearsrv]
GRANT CREATE AGGREGATE TO [test\wsssearsrv]
GRANT CREATE ASSEMBLY TO [test\wsssearsrv]
GRANT CREATE ASYMMETRIC KEY TO [test\wsssearsrv]
GRANT CREATE CERTIFICATE TO [test\wsssearsrv]
GRANT CREATE CONTRACT TO [test\wsssearsrv]
GRANT CREATE DATABASE DDL EVENT NOTIFICATION TO [test\wsssearsrv]
GRANT CREATE DEFAULT TO [test\wsssearsrv]
GRANT CREATE FULLTEXT CATALOG TO [test\wsssearsrv]
GRANT CREATE FUNCTION TO [test\wsssearsrv]
GRANT CREATE MESSAGE TYPE TO [test\wsssearsrv]
GRANT CREATE PROCEDURE TO [test\wsssearsrv]
GRANT CREATE QUEUE TO [test\wsssearsrv]
GRANT CREATE REMOTE SERVICE BINDING TO [test\wsssearsrv]
GRANT CREATE ROLE TO [test\wsssearsrv]
GRANT CREATE ROUTE TO [test\wsssearsrv]
GRANT CREATE RULE TO [test\wsssearsrv]
GRANT CREATE SCHEMA TO [test\wsssearsrv]
GRANT CREATE SERVICE TO [test\wsssearsrv]
GRANT CREATE SYMMETRIC KEY TO [test\wsssearsrv]
GRANT CREATE SYNONYM TO [test\wsssearsrv]
GRANT CREATE TABLE TO [test\wsssearsrv]
GRANT CREATE TYPE TO [test\wsssearsrv]
GRANT CREATE VIEW TO [test\wsssearsrv]
GRANT CREATE XML SCHEMA COLLECTION TO [test\wsssearsrv]
GRANT DELETE TO [test\wsssearsrv]
GRANT EXECUTE TO [test\wsssearsrv]
GRANT INSERT TO [test\wsssearsrv]
GRANT REFERENCES TO [test\wsssearsrv]
GRANT SELECT TO [test\wsssearsrv]
GRANT SHOWPLAN TO [test\wsssearsrv]
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [test\wsssearsrv]
GRANT TAKE OWNERSHIP TO [test\wsssearsrv]
GRANT UPDATE TO [test\wsssearsrv]
GRANT VIEW DATABASE STATE TO [test\wsssearsrv]
GRANT VIEW DEFINITION TO [test\wsssearsrv]
rerun SharePoint Products and Technologies Configuration Wizard
removes the errors also
You may need a host entry to point the server back to itself if you are in a farm environment or have ISA or other firewall that might be causing an issue.
It works for me.
Hi,
I was facing the same problem for the past 2 days. I did the same and it didnot work out for me. Any ideas?
Windows SharePoint Services 3 Search error
I get this error message every 2minutes and it driving me nuts. Anyone with a different suggest which is different from the ones posted above.
My Event viewer log for this error is as follows:
---------------------
Failed to update committed transaction in SQL, DocID is 6130.
Context: Application 'Search index file on the search server', Catalog 'Search'
Details:
One or more errors occurred during processing of command. (0x80040e14)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
-----------------
Any assistance would be appreciated.
Remandlo
Post a Comment