Error: The backup/restore job failed because there is already another job scheduled. Delete the timer job from the Timer Job Definitions page, and then restart the backup/restore job.
1. In Central Admin > Operations > Global Configuration, click on Timer job definitions.
2. Click the timer job with the title of "backup/restore."
3. Delete the timer job.
Now you can run the backup/ restore process.
Error: The EXECUTE permission was denied on the object 'proc_getNewObjects', database 'SharePoint_Config', schema 'dbo'. MOSS 2007 Error
Event ID: 5214
Run MSSqlserver service as network account. For this
1. My Computer > Right click Select “Manage” > Services and Application > Services
2. Select MSSqlserver service >properties > Log On
If your installation is not single server farm then select “This Account” option and give domain user and password which has sufficient permission to access database.
See also: http://technet.microsoft.com/en-us/library/cc561019.aspx
Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 3351
Time: 12:45:30 AM
SQL database login failed. Additional error information from SQL Server is included below.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Solution: Run Timer service as network account in similar manner as in above problem.
Error: The search request was unable to connect to the Search Service.
Solution: See Here
Error: Access denied in Editing SPD workflow in MOSS 2007
Solution: 1. Go to Sharepoint designer-> workflow->RightClick->Properties->Security->Manage permission using the browser->set user permission(Approver)
2. Right click on workflow -> Publish files