How to provide permissions to Search account on SQL Database?
0
votes
1 Answers
0
votes
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)