Назад | Перейти на главную страницу

Служба отчетов SQL не запускается после восстановления на новом оборудовании

У меня есть SQL-сервер, на котором не работает оборудование. В качестве решения мы восстановили образ сервера на многоядерном (более менее новом) сервере. Проблема в том, что SQL 2000 не может быть запущен, если количество процессоров не равно 2. Я нашел это статья Это помогло мне с хорошим трюком загрузить SQL просто отлично, но служба отчетов имеет ту же проблему.

Итак, я ищу решение, как загрузить службы Reporting Services на это новое оборудование. Вот журнал службы сервера отчетов.


<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>SA Western Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__06_05_2014_13_45_41.log</Path>
<SystemName>S*******R</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>

ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!e24!6/5/2014-13:45:41:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
ReportingServicesService!servicecontroller!e24!6/5/2014-13:45:41:: Error Starting Service: System.ArgumentException: Value does not fall within the expected range.
at Microsoft.ReportingServices.Diagnostics.ResourceUtilities.BitsSet(Int32 nr)
at Microsoft.ReportingServices.Diagnostics.ResourceUtilities.ThrottleCpu()
at Microsoft.ReportingServices.Diagnostics.Globals.InitializeProcessParameters()
at Microsoft.ReportingServices.Library.ServiceController.StartService()

Мне удалось решить проблему, выбрав количество ядер на сервере с помощью утилит на базе ПЗУ HP. Вместо того, чтобы использовать все 12 ядер от каждого процессора (всего 24), я понизил рейтинг до 8 на процессор, всего 16. Поскольку это степень двойки, проблема решена. Спасибо!