SQL 2005 SP2
I have a remote sql server installation of SCOM 2007 so I'm running the
database install on the SQL Server first. I'm getting this error message:
Error 25154.Failed to execute SQL script. Error Code: -2147217900 (Ad hoc
update to system catalogs is not supported.)
The log shows the following info:
CheckDatabaseExists: Succesfully connected to 'master' database on server.
SQLSERVER
CheckDatabaseExists: Succesfully retrived database list from 'master'
database.
CheckDatabaseExists: Database exists. OperationsManager
ExecuteSqlScripts: Succesfully connected to database. OperationsManager
ExecuteSqlScripts: Executing SQL script. D:\MSSQL\Database\build_mom_db.sql
ExecuteSqlScriptFileFromMsi: CreateFile successfully opened file.
D:\MSSQL\Database\build_mom_db.sql
ExecuteSql: Failed to execute SQL script. Error Code: 0x80040E14.
RECONFIGURE. Additional Error Description : Ad hoc update to system catalogs
is not supported.
ExecuteSqlScriptFileFromMsi: Failed to execute sql script in the specified
file. Error Code: 0x80040E14. D:\MSSQL\Database\build_mom_db.sql
ExecuteSqlScripts: ExecuteSqlScriptFileFromMsi returned error. Error Code:
0x80040E14.
Error 25154.Failed to execute SQL script. Error Code: -2147217900 (Ad hoc
update to system catalogs is not supported.).
MSI (s) (70!88) [09:26:01:247]: Product: System Center Operations Manager
2007 -- Error 25154.Failed to execute SQL script. Error Code: -2147217900 (Ad
hoc update to system catalogs is not supported.).

Action ended 9:26:01: InstallFinalize. Return value 3.

Any ideas?

anders bengtsson

Hi wayne,

Have you done any configuration to your SQL server or is it all default SQL
settings?


-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


w> update to system catalogs is not supported
w>

error 25156

Anders,

I had the similar problem while I installing Operations Manager 2007
SP1 Evaluation Full Package. Please see below for details. What is my next
step please?

CreateDatabase: Custom Action Data.
MOMXDB TIV08 OperationsManager 1 1000 D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ D:\Microsoft SQL Server\MSSQL.1\MSSQL\Log\
CreateDatabase: Succesfully connected to 'master' database on server. TIV08
CheckDatabaseExists: Succesfully connected to 'master' database on server.
TIV08
CheckDatabaseExists: Succesfully retrived database list from 'master'
database.
CreateDatabase: Creating database. OperationsManager
CreateDatabase: Create database query. CREATE DATABASE ON
PRIMARY(NAME=MOM_DATA,FILENAME='D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf',S IZE=1000MB,MAXSIZE=1000MB,FILEGROWTH=0MB)
LOG ON(NAME=MOM_LOG, FILENAME='D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Log\OperationsManager.ldf',SI ZE=500MB,MAXSIZE=500MB,FILEGROWTH=0MB) COLLATE SQL_Latin1_General_CP1_CI_AS
ExecuteSql: Failed to execute SQL script. Error Code: 0x80040E14. CREATE
DATABASE ON PRIMARY(NAME=MOM_DATA,FILENAME='D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf',S IZE=1000MB,MAXSIZE=1000MB,FILEGROWTH=0MB)
LOG ON(NAME=MOM_LOG, FILENAME='D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Log\OperationsManager.ldf',SI ZE=500MB,MAXSIZE=500MB,FILEGROWTH=0MB)
COLLATE SQL_Latin1_General_CP1_CI_AS. Additional Error Description : The file
"D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf" is
compressed but does not reside in a read-only database or filegroup. The file
must be decompressed.
CreateDatabase: ExecuteSql failed. Error Code: 0x80040E14.
Error 25156.Failed to create MOM database. Error Code: -2147217900 (The file
"D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf" is
compressed but does not reside in a read-only database or filegroup. The file
must be decompressed.).
MSI (s) (34!8C) [17:39:56:406]: Product: System Center Operations Manager
2007 -- Error 25156.Failed to create MOM database. Error Code: -2147217900
(The file "D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf"
is compressed but does not reside in a read-only database or filegroup. The
file must be decompressed.).

Action ended 17:39:56: InstallFinalize. Return value 3.

Thanks,
Jonathan

anders bengtsson [mvp]

Hi Error,

Is your disc compressed ? Seems that there is something strange with the
target disc.


--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se

EE> Anders,
EE>
EE> I had the similar problem while I installing Operations Manager
EE> 2007 SP1 Evaluation Full Package. Please see below for details. What
EE> is my next step please?
EE>
EE> CreateDatabase: Custom Action Data.
EE> MOMXDB TIV08 OperationsManager 1 1000 D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Data\ D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Log\
EE> CreateDatabase: Succesfully connected to 'master' database on
EE> server. TIV08
EE> CheckDatabaseExists: Succesfully connected to 'master' database on
EE> server.
EE> TIV08
EE> CheckDatabaseExists: Succesfully retrived database list from
EE> 'master'
EE> database.
EE> CreateDatabase: Creating database. OperationsManager
EE> CreateDatabase: Create database query. CREATE DATABASE ON
EE> PRIMARY(NAME=MOM_DATA,FILENAME='D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf',S IZE=1000MB,MAXSIZE
EE> =1000MB,FILEGROWTH=0MB)
EE> LOG ON(NAME=MOM_LOG, FILENAME='D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Log\OperationsManager.ldf',SI ZE=500MB,MAXSIZE=5
EE> 00MB,FILEGROWTH=0MB) COLLATE SQL_Latin1_General_CP1_CI_AS
EE> ExecuteSql: Failed to execute SQL script. Error Code: 0x80040E14.
EE> CREATE
EE> DATABASE ON PRIMARY(NAME=MOM_DATA,FILENAME='D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf',S IZE=1000MB,MAXSIZE
EE> =1000MB,FILEGROWTH=0MB)
EE> LOG ON(NAME=MOM_LOG, FILENAME='D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Log\OperationsManager.ldf',SI ZE=500MB,MAXSIZE=5
EE> 00MB,FILEGROWTH=0MB)
EE> COLLATE SQL_Latin1_General_CP1_CI_AS. Additional Error Description :
EE> The file
EE> "D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf"
EE> is
EE> compressed but does not reside in a read-only database or filegroup.
EE> The file
EE> must be decompressed.
EE> CreateDatabase: ExecuteSql failed. Error Code: 0x80040E14.
EE> Error 25156.Failed to create MOM database. Error Code: -2147217900
EE> (The file
EE> "D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf"
EE> is
EE> compressed but does not reside in a read-only database or filegroup.
EE> The file
EE> must be decompressed.).
EE> MSI (s) (34!8C) [17:39:56:406]: Product: System Center Operations
EE> Manager
EE> 2007 -- Error 25156.Failed to create MOM database. Error Code:
EE> -2147217900
EE> (The file "D:\Microsoft SQL
EE> Server\MSSQL.1\MSSQL\Data\OperationsManager.mdf"
EE> is compressed but does not reside in a read-only database or
EE> filegroup. The
EE> file must be decompressed.).
EE> Action ended 17:39:56: InstallFinalize. Return value 3.
EE>
EE> Thanks,
EE> Jonathan