none
Insufficient SQL database permissions for user “” - MOSS 2007 Search Service

    Pertanyaan

  • 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:52

Jawaban

  • 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.


    Aniket


    20 Juni 2012 5:33
  • 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

    regards,

    Veera

    22 Juni 2012 10:14

Semua Balasan

  • Cross verify that account credentials and is it giving problems only for Search Service ?








    Talib Ali Khan
    SharePoint Specialist
    MCTS
    Blog : http://www.onlineasp.net
    Twitter : https://twitter.com/TalibAliKhan
    LinkedIn: http://sa.linkedin.com/in/talibalikhan

    19 Juni 2012 13:59
  • 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.

    Thanks




    19 Juni 2012 14:08
  • 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.


    Aniket


    20 Juni 2012 5:33
  • 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

    regards,

    Veera

    22 Juni 2012 10:14