Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
configuration:supersearch:troubleshooting:permissions-and-services [2014-04-04 07:17] jog removed |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Permissions and Services ====== | ||
| - | ===== Services ===== | ||
| - | |||
| - | **SQL Server Agent** needs to be enabled in order to run jobs. | ||
| - | |||
| - | On newer MSSQL versions, the **FullText Search** is enabled by default. But on MSSQL 2005, you need to start it yourself. | ||
| - | |||
| - | - Open //SQL Server Configuration Manager// as an administrator. | ||
| - | - Make sure the following services are //Running// and // | ||
| - | - SQL Server Agent | ||
| - | - SQL Server FullText Search, if on MSSQL 2005. | ||
| - | |||
| - | ===== Permissions to create jobs ===== | ||
| - | |||
| - | The user that runs LIME Pro Server needs permissions to create jobs on the SQL Server Agent, by membership of the **SQLAgentUserRole**. | ||
| - | |||
| - | - Open //SQL Server Configuration Manager// as an administrator. | ||
| - | - Go to the following node in the Object Explorer: < | ||
| - | - Under //Select a page//, select **User Mapping** | ||
| - | - Under //Users mapped to this login//, select **msdb** | ||
| - | - Under //Database role membership for: msdb//, check **SQLAgentUserRole** | ||