The Enterprise Reporter Server service will not start (4236998)

Things to try

• If the service was running previously and discoveries were run, run the following SQL script against the ER database to ensure there are no discoveries still queued to run:
   
  update [tblTask] set Status = 'Finished', AssignedNodeID = null, EndDate = StartDate, SeqNo = null where [Status] not like '%%Finished%%' 
   
  update [tblJobRun] set Status = 'Finished', EndDate = StartDate, SeqNo = null where Status not like '%%Finished%%'
• Make sure that the drive in which the database files are hosted has enough disk space.
• Try granting the account db_owner rights to the ER database
• If the account that the service is running as has a $ in the name, try using an account that does not have a $ in the name and that is a member of the Reporter_Discovery_Admins
• Confirm the account that the service runs as is a member of the Local Administrators group on the ER server
• Confirm the account that the service runs as is a member of the Reporter_Discovery_Admins.
• Create a new Database

If the above suggestions do not resolve the issue, please check the Windows Application Event log for an entry similar to the following that would have been logged when ER was installed:

Unable to create service Quest.Reporter.Core.Server.NotificationManagement.NotificationManager, Quest.Reporter.Core.Server.NotificationManagement - HTTP could not register URL http://+:8888/Quest.Reporter.Core.Server.Host/NotificationManager/ because TCP port 8888 is being used by another application

Confirm there is another application/service listening on port 8888. If so, please use the following steps to change the port used by ER:

1. Launch SQL Management Studio
2. Backup the Enterprise Reporter database (default name dbReporter)
3. Run the following SQL queries against the Enterprise Reporter database (the script, as is, will change the port number to 8885. You can change it to a different port if you wish):
    
   DECLARE @PortNumber int
   SET @PortNumber = '8885' 
    
   DECLARE @KeyId NVARCHAR(256)
   SET @KeyId = (
   SELECT [KeyId]
   FROM [dbReporter].[dbo].[tblSettingsKey]
   WHERE KeyName = 'App.config')
     
     
   UPDATE [dbReporter].[dbo].[tblSettingsValue]
   SET VALUE = REPLACE (VALUE, '8888', @PortNumber) WHERE keyid = @KeyId