Reporting Database Schema Timeout
Hi, I am trying to restore my Forefront Reporting to working order after a SQL database corruption. I have the Database running but when I run the configuration wizard it errors out on the Report Database Schema load. I have changed the timeouts to 0 everywhere I could find them and continue to get the error. What am I missing? MS Server 2003 SQL Server 2005 MOM 2005 FCS 2005 Here is the error: [8/4/2011 2:54:11 PM] Task(Reporting Database Schema) Starting this SQL script: d:\Program Files\Microsoft Forefront\Client Security\Server\MOM_DWH_SQL_Addons.sql [8/4/2011 3:19:47 PM] Task(Reporting Database Schema) Exception thrown during SQL command. Exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Near line: 1706 SQL command: IF (SERVERPROPERTY('EditionID') = 1804890536) BEGIN IF NOT EXISTS(SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[dbo].[' + N'SC_EventFact_Table' + N']') AND name = N'inxSAS_EventFact_DateTimeGenerated_ClusteredIndex') BEGIN CREATE CLUSTERED INDEX inxSAS_EventFact_DateTimeGenerated_ClusteredIndex ON SC_EventFact_Table ( DateTimeGenerated ASC, DateTimeStored ASC ) ON scmSAS_DailyPartitions(DateTimeStored) END END [8/4/2011 3:19:47 PM] Task(Reporting Database Schema) System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Thanks,
August 4th, 2011 4:42pm

Hi Raiderpb, Thanks for posting your question here. From your description, I found that the error happens after you re-run the SQL Server. Please check your SQL Server environment from below two directions. 1. The SQL server needs to be started with a domain account (recomended) or network _service 2. Make sure SQL agent is started. Hope them helps you. Thanks, Sharp Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2011 12:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics