Posts Tagged "Operations Manager"

System Center 2012 SP1 Operations Manager: Datawarehouse configuration failed to install

Posted by on Feb 19, 2013 in SC Operations Manager, SQL Server, Transact-SQL | 1 comment

System Center 2012 SP1 Operations Manager: Datawarehouse configuration failed to install

While installing Microsoft System Center 2012 SP1 Operations Manager I got following error: In the log I could see that Setup could not create the Datawarehouse database: EXEC(@sql);: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file ‘E:\SQL\Data.mdf’. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. I have a standalone SQL 2012 SP1 server (SQL) and a Windows...

Read More

Error 18054 and Error 777971002 in SQL log after moving System Center Operations Manager 2007 Database

Posted by on Jan 4, 2013 in SC Operations Manager, SQL Server | 3 comments

Error 18054 and Error 777971002 in SQL log after moving System Center Operations Manager 2007 Database

I just needed to move the System Center Operations Manager 2007 Database from one SQL server to another. I followed Kevin Holman’s instructions step by step and ran into the same problem he was noticing after the move. The error I got was: Error 777971002, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. So I followed the steps he took which did not solve my problem. I still got these errors in the log. But there is another way to fix this...

Read More