Masuk
 
AwalPerpustakaanWikiPelajariUnduhDukunganKomunitasForum
Resources for IT Professionals >
> 
> 
Insufficient SQL database permissions for user “” - MOSS 2007 Search Service

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

  • 19 Juni 2012 13:52
     
     
    Masuk untuk Memilih
    0

    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
     

Semua Balasan

  • 19 Juni 2012 13:59
     
     
    Masuk untuk Memilih
    0

    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 14:08
     
     
    Masuk untuk Memilih
    0

    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




     
  • 20 Juni 2012 5:33
     
     Jawab
    Masuk untuk Memilih
    0

    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


     
  • 22 Juni 2012 10:14
     
     Jawab
    Masuk untuk Memilih
    0

    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