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