19 Juni 2012 13:52
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?
I can confirm that the service account has dbo access rights including sysadmin.Thanks
19 Juni 2012 13:59
19 Juni 2012 14:08
Talib I've verified the account credentials, everthing else works fine on the server, in-fact even the search. However I'm unable to get rid of the error in the log, it keeps popping up in intervals of one minute.
- Diedit oleh Imran Azad 19 Juni 2012 14:46
20 Juni 2012 5:33
Did you check under the services.msc that
Windows SharePoint Services search and Office SharePoint Server Search has the proper user account and that user account have proper rights on the DB.
22 Juni 2012 10:14
HI Imran Azad,
The issue might be caused because of NTFS permissionon the Office Server Web Services website files. By default these files are located at C:\Program Files\Microsoft Office Servers\12.0\WebServices\Root.
Could be an access deniedon the web.config located at C:\Program Files\Microsoft Office Servers\12.0\WebServices\Root
1) Determine what account is running the application pool for the Office Server Web Services
2) Grant this account Read, List Folder Contents on the Root folder as well as the files within
3) Reset IIS
- Ditandai sebagai Jawaban oleh Lhan HanModerator 01 Juli 2012 15:10