Permissions and 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.

1. Open SQL Server Configuration Manager as an administrator.
2. Make sure the following services are Running and Automatically:
   1. SQL Server Agent
   2. SQL Server FullText Search, if on MSSQL 2005.

The user that runs LIME Pro Server needs permissions to create jobs on the SQL Server Agent, by membership of the SQLAgentUserRole.

1. Open SQL Server Configuration Manager as an administrator.
2. Go to the following node in the Object Explorer: <DB> | Security | Logins | <The user that runs LIME Pro Server, right click and choose Properties.
3. Under Select a page, select User Mapping
4. Under Users mapped to this login, select msdb
5. Under Database role membership for: msdb, check SQLAgentUserRole