How to provide permissions to Search account on SQL Database?
A:
Presuming that you are actually asking what the permissions should be, not how to allocate the permissions in SQL Server, the account used for search should have the dbcreator and the securityadmin server roles in the SSP Search database.
Refer Technet for more details:
Plan for administrative and service accounts (Office SharePoint Server)
In case you do need guidance on setting SQL permissions, refer here:
Security Considerations for Databases and Database Applications (SQL Server 2005)
Brian Meinertz
2010-03-15 06:34:13
I am sorry for being ignorant, but I need to know "how to allocate the permissions"? thanks
abc234
2010-03-15 06:38:00
Open SQL Server Management Studio and connect to your server. Expand "Security" and click on "Server Roles". Double click dbcreator and add your Search account, then do the same to add the Search account to the securityadmin server role.
Brian Meinertz
2010-03-15 08:35:49