I'm working with SharePoint 2007 and when I start the search service I keep getting the following error:
Insufficient SQL database permissions for user '' in database Test_ConfigDB on SQL Server instance test. Additional error information from SQL Server is included below. EXECUTE permission denied on object 'proc_getNewObjects',database 'SharePoint_Config', schema 'dbo'.
The strange thing is where it says "for user", there is no user.
I've had a look at the search service in Central Admin and defined a search user, so why is it not picking it up?