Unsolved

This post is more than 5 years old

42694

June 1st, 2012 02:00

OME Installation Fails with no reason why

I've attempted to install OME on a VM but the install is failing at the end. The exact error is:

"Installation Failed

Setup has failed to install Dell OpenManage Essentials.

Your system has not been modified. To complete installation at another time, please run setup again."

It's told a small lie, because if I open SQL Management Studio Express 2012, I can see the OMEssentials (Single User) database, and the OMEService user, so it has modified the system.

I have managed to successfully install Dell Licence Manager and Respository Manager with no problems.

The first time I attempted to install OME, I didn't meet all the pre-requisites (such as the NaviSphere for EMC as we don't have an EMC arrange) and the install failed. so I went back and made sure everything was met. The only pre-requisites now showing are 2 informational alerts relating to the readme and disk space (of which I have plenty).

I can't see anything logged in Event Viewer as to why the install is failing?

So, to summerise the system:

1. Windows 2008 R2 Standard 64-bit.

2.  VM assigned with 2 Cores, 8GB RAM.

3. SQL Express Edition 2012 was already installed locally.

5. Other software running on server: Kaspersky admin kit, Spiceworks, Exclaimer Signature Manager

6. IIS is installed, and I believe it's configured properly.

7. The server is in a domain and DNS is configured.

4 Apprentice

 • 

2.8K Posts

June 1st, 2012 07:00

Thanks for the post ElectroDan, sorry you are running into trouble.

See if there are any useful mesages in the install log file.  C:\Windows\Temp\InstallUtil.log.

I would expect the EMC pre-req message would have been just a warning, but I can't recall for sure.  If you are not managing EMC arrays, you don't need it.

See what the log file says, and that may give us a clue.

I'm not certain about Spiceworks, but running two system management tools in a two core VM may be cutting it a bit close.  We'll keep an eye on that.

The install is pretty solid.  Usually, install problems are: misconfigured IIS or corrupt IIS env, two few resources on the box, or a pre-existing SQL install that may be locked down or have some trouble.

Let me know if the install log gives you a clue and we'll go from there.

Rob

June 1st, 2012 08:00

I'm pasting today's entry from the log. There are older entries from when I tried to install previously, but I've not included them.

2012-06-01 09:24:55 AM

"C:\Program Files (x86)\Dell\SysMgt\Essentials\bin\WebInstall\InstallUtil.exe"  -DatabaseOptions 8 -i -WebsitePath "C:\Program Files (x86)\Dell\SysMgt\Essentials\WWWRoot\Essentials" -WebsitePort "2607"

Website unzip started...

Website un-install started...

Website un-install completed.

HostServiceInstaller.Uninstall()

Database.Install(...)

Database.UnzipDataScripts()

- C:\Windows\TEMP\OMEssentials 2012-06-01 09.24.56

- DatabaseAdd.sql

- UpgradeITAssist.sql

- UpgradeOMEssentials, 1.0.0.30.sql

LoadSqlLogin()

Using the current user to access SQL Server.

Website unzip complete.

LoadMixedMode(...)

LoadSqlLogin(...)

Adding the [OmeService] account.

Setting permissions on the [OmeService] account.

Dropping the existing [OMEssentials] database.

No database found.

Database.LoadServerPaths(...)

Server Name:   (local)

Database Name: OMEssentials

Script:        C:\Windows\TEMP\OMEssentials 2012-06-01 09.24.56\DatabaseAdd.sql

SQL Login:     Yes

Database.ExecuteSqlFile(...)

Changed database context to 'master'.

Creating OMEssentials...

Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.

Changed database context to 'OMEssentials'.

*

The .Net SqlClient Data Provider has received a severity 16, state 62 error number 2812

on line 1 of procedure '' on server '(local)':

Could not find stored procedure 'sp_dboption'.

/*

Pre-Deployment Script Template

--------------------------------------------------------------------------------------

This file contains SQL statements that will be executed before the build script.

Use SQLCMD syntax to include a file in the pre-deployment script.

Example:      :r .\myfile.sql

Use SQLCMD syntax to reference a variable in the pre-deployment script.

Example:      :setvar TableName MyTable

              SELECT * FROM $(TableName)

--------------------------------------------------------------------------------------

*/

-- These database configuration settings should match what is defined in 'Database.sqlsettings'

-- Setting the options here enforces that no matter what the settings are they will be set correctly.

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'OMEssentials') begin

ALTER DATABASE [OMEssentials]

SET READ_WRITE;

EXECUTE sp_dbcmptlevel [OMEssentials], 90;

   ALTER DATABASE [OMEssentials] SET

ANSI_NULLS ON,

ANSI_NULL_DEFAULT OFF,

       ANSI_PADDING ON,

       ANSI_WARNINGS ON,

       ARITHABORT ON,

       AUTO_CLOSE OFF,

       AUTO_CREATE_STATISTICS ON,

AUTO_SHRINK ON,

AUTO_UPDATE_STATISTICS ON,

AUTO_UPDATE_STATISTICS_ASYNC OFF,

       CONCAT_NULL_YIELDS_NULL ON,

       NUMERIC_ROUNDABORT OFF,

       QUOTED_IDENTIFIER ON,

       CURSOR_CLOSE_ON_COMMIT OFF,

       CURSOR_DEFAULT LOCAL,

       RECURSIVE_TRIGGERS OFF

WITH ROLLBACK IMMEDIATE;

   ALTER DATABASE [OMEssentials]

       SET PAGE_VERIFY NONE

       WITH ROLLBACK IMMEDIATE;

   IF (fulltextserviceproperty(N'IsFulltextInstalled') = 1) begin

EXECUTE sp_fulltext_database 'disable';

END

END

EXEC ('sp_dboption N''OMEssentials'', N''bulkcopy'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''dbo use'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log on chkpt.'', N''true''')

EXEC ('sp_dboption N''OMEssentials'', N''db chaining'', N''false''')

-- -- --

-- Add missing tables created before ITA 8.9

-- -- --

-- When the 'SchemaVersion' view is missing it is either an old database or a brand new database.

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[SchemaVersion]')) begin

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MaserInfo]') AND type in (N'U')) BEGIN

CREATE TABLE [dbo].[MaserInfo]

(

[DeviceId] [int] NOT NULL,

[MaserType] [nvarchar](256) NOT NULL,

[MaserOptionalStorageSize] [int] NULL,

);

END

END

*

The .Net SqlClient Data Provider has received a severity 16, state 62 error number 2812

on line 1 of procedure '' on server '(local)':

Could not find stored procedure 'sp_dboption'.

/*

Pre-Deployment Script Template

--------------------------------------------------------------------------------------

This file contains SQL statements that will be executed before the build script.

Use SQLCMD syntax to include a file in the pre-deployment script.

Example:      :r .\myfile.sql

Use SQLCMD syntax to reference a variable in the pre-deployment script.

Example:      :setvar TableName MyTable

              SELECT * FROM $(TableName)

--------------------------------------------------------------------------------------

*/

-- These database configuration settings should match what is defined in 'Database.sqlsettings'

-- Setting the options here enforces that no matter what the settings are they will be set correctly.

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'OMEssentials') begin

ALTER DATABASE [OMEssentials]

SET READ_WRITE;

EXECUTE sp_dbcmptlevel [OMEssentials], 90;

   ALTER DATABASE [OMEssentials] SET

ANSI_NULLS ON,

ANSI_NULL_DEFAULT OFF,

       ANSI_PADDING ON,

       ANSI_WARNINGS ON,

       ARITHABORT ON,

       AUTO_CLOSE OFF,

       AUTO_CREATE_STATISTICS ON,

AUTO_SHRINK ON,

AUTO_UPDATE_STATISTICS ON,

AUTO_UPDATE_STATISTICS_ASYNC OFF,

       CONCAT_NULL_YIELDS_NULL ON,

       NUMERIC_ROUNDABORT OFF,

       QUOTED_IDENTIFIER ON,

       CURSOR_CLOSE_ON_COMMIT OFF,

       CURSOR_DEFAULT LOCAL,

       RECURSIVE_TRIGGERS OFF

WITH ROLLBACK IMMEDIATE;

   ALTER DATABASE [OMEssentials]

       SET PAGE_VERIFY NONE

       WITH ROLLBACK IMMEDIATE;

   IF (fulltextserviceproperty(N'IsFulltextInstalled') = 1) begin

EXECUTE sp_fulltext_database 'disable';

END

END

EXEC ('sp_dboption N''OMEssentials'', N''bulkcopy'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''dbo use'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log on chkpt.'', N''true''')

EXEC ('sp_dboption N''OMEssentials'', N''db chaining'', N''false''')

-- -- --

-- Add missing tables created before ITA 8.9

-- -- --

-- When the 'SchemaVersion' view is missing it is either an old database or a brand new database.

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[SchemaVersion]')) begin

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MaserInfo]') AND type in (N'U')) BEGIN

CREATE TABLE [dbo].[MaserInfo]

(

[DeviceId] [int] NOT NULL,

[MaserType] [nvarchar](256) NOT NULL,

[MaserOptionalStorageSize] [int] NULL,

);

END

END

*

The .Net SqlClient Data Provider has received a severity 16, state 62 error number 2812

on line 1 of procedure '' on server '(local)':

Could not find stored procedure 'sp_dboption'.

/*

Pre-Deployment Script Template

--------------------------------------------------------------------------------------

This file contains SQL statements that will be executed before the build script.

Use SQLCMD syntax to include a file in the pre-deployment script.

Example:      :r .\myfile.sql

Use SQLCMD syntax to reference a variable in the pre-deployment script.

Example:      :setvar TableName MyTable

              SELECT * FROM $(TableName)

--------------------------------------------------------------------------------------

*/

-- These database configuration settings should match what is defined in 'Database.sqlsettings'

-- Setting the options here enforces that no matter what the settings are they will be set correctly.

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'OMEssentials') begin

ALTER DATABASE [OMEssentials]

SET READ_WRITE;

EXECUTE sp_dbcmptlevel [OMEssentials], 90;

   ALTER DATABASE [OMEssentials] SET

ANSI_NULLS ON,

ANSI_NULL_DEFAULT OFF,

       ANSI_PADDING ON,

       ANSI_WARNINGS ON,

       ARITHABORT ON,

       AUTO_CLOSE OFF,

       AUTO_CREATE_STATISTICS ON,

AUTO_SHRINK ON,

AUTO_UPDATE_STATISTICS ON,

AUTO_UPDATE_STATISTICS_ASYNC OFF,

       CONCAT_NULL_YIELDS_NULL ON,

       NUMERIC_ROUNDABORT OFF,

       QUOTED_IDENTIFIER ON,

       CURSOR_CLOSE_ON_COMMIT OFF,

       CURSOR_DEFAULT LOCAL,

       RECURSIVE_TRIGGERS OFF

WITH ROLLBACK IMMEDIATE;

   ALTER DATABASE [OMEssentials]

       SET PAGE_VERIFY NONE

       WITH ROLLBACK IMMEDIATE;

   IF (fulltextserviceproperty(N'IsFulltextInstalled') = 1) begin

EXECUTE sp_fulltext_database 'disable';

END

END

EXEC ('sp_dboption N''OMEssentials'', N''bulkcopy'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''dbo use'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log on chkpt.'', N''true''')

EXEC ('sp_dboption N''OMEssentials'', N''db chaining'', N''false''')

-- -- --

-- Add missing tables created before ITA 8.9

-- -- --

-- When the 'SchemaVersion' view is missing it is either an old database or a brand new database.

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[SchemaVersion]')) begin

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MaserInfo]') AND type in (N'U')) BEGIN

CREATE TABLE [dbo].[MaserInfo]

(

[DeviceId] [int] NOT NULL,

[MaserType] [nvarchar](256) NOT NULL,

[MaserOptionalStorageSize] [int] NULL,

);

END

END

*

The .Net SqlClient Data Provider has received a severity 16, state 62 error number 2812

on line 1 of procedure '' on server '(local)':

Could not find stored procedure 'sp_dboption'.

/*

Pre-Deployment Script Template

--------------------------------------------------------------------------------------

This file contains SQL statements that will be executed before the build script.

Use SQLCMD syntax to include a file in the pre-deployment script.

Example:      :r .\myfile.sql

Use SQLCMD syntax to reference a variable in the pre-deployment script.

Example:      :setvar TableName MyTable

              SELECT * FROM $(TableName)

--------------------------------------------------------------------------------------

*/

-- These database configuration settings should match what is defined in 'Database.sqlsettings'

-- Setting the options here enforces that no matter what the settings are they will be set correctly.

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'OMEssentials') begin

ALTER DATABASE [OMEssentials]

SET READ_WRITE;

EXECUTE sp_dbcmptlevel [OMEssentials], 90;

   ALTER DATABASE [OMEssentials] SET

ANSI_NULLS ON,

ANSI_NULL_DEFAULT OFF,

       ANSI_PADDING ON,

       ANSI_WARNINGS ON,

       ARITHABORT ON,

       AUTO_CLOSE OFF,

       AUTO_CREATE_STATISTICS ON,

AUTO_SHRINK ON,

AUTO_UPDATE_STATISTICS ON,

AUTO_UPDATE_STATISTICS_ASYNC OFF,

       CONCAT_NULL_YIELDS_NULL ON,

       NUMERIC_ROUNDABORT OFF,

       QUOTED_IDENTIFIER ON,

       CURSOR_CLOSE_ON_COMMIT OFF,

       CURSOR_DEFAULT LOCAL,

       RECURSIVE_TRIGGERS OFF

WITH ROLLBACK IMMEDIATE;

   ALTER DATABASE [OMEssentials]

       SET PAGE_VERIFY NONE

       WITH ROLLBACK IMMEDIATE;

   IF (fulltextserviceproperty(N'IsFulltextInstalled') = 1) begin

EXECUTE sp_fulltext_database 'disable';

END

END

EXEC ('sp_dboption N''OMEssentials'', N''bulkcopy'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''dbo use'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log on chkpt.'', N''true''')

EXEC ('sp_dboption N''OMEssentials'', N''db chaining'', N''false''')

-- -- --

-- Add missing tables created before ITA 8.9

-- -- --

-- When the 'SchemaVersion' view is missing it is either an old database or a brand new database.

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[SchemaVersion]')) begin

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MaserInfo]') AND type in (N'U')) BEGIN

CREATE TABLE [dbo].[MaserInfo]

(

[DeviceId] [int] NOT NULL,

[MaserType] [nvarchar](256) NOT NULL,

[MaserOptionalStorageSize] [int] NULL,

);

END

END

*

The .Net SqlClient Data Provider has received a severity 16, state 62 error number 2812

on line 1 of procedure '' on server '(local)':

Could not find stored procedure 'sp_dboption'.

/*

Pre-Deployment Script Template

--------------------------------------------------------------------------------------

This file contains SQL statements that will be executed before the build script.

Use SQLCMD syntax to include a file in the pre-deployment script.

Example:      :r .\myfile.sql

Use SQLCMD syntax to reference a variable in the pre-deployment script.

Example:      :setvar TableName MyTable

              SELECT * FROM $(TableName)

--------------------------------------------------------------------------------------

*/

-- These database configuration settings should match what is defined in 'Database.sqlsettings'

-- Setting the options here enforces that no matter what the settings are they will be set correctly.

IF EXISTS (SELECT name FROM sys.databases WHERE name = N'OMEssentials') begin

ALTER DATABASE [OMEssentials]

SET READ_WRITE;

EXECUTE sp_dbcmptlevel [OMEssentials], 90;

   ALTER DATABASE [OMEssentials] SET

ANSI_NULLS ON,

ANSI_NULL_DEFAULT OFF,

       ANSI_PADDING ON,

       ANSI_WARNINGS ON,

       ARITHABORT ON,

       AUTO_CLOSE OFF,

       AUTO_CREATE_STATISTICS ON,

AUTO_SHRINK ON,

AUTO_UPDATE_STATISTICS ON,

AUTO_UPDATE_STATISTICS_ASYNC OFF,

       CONCAT_NULL_YIELDS_NULL ON,

       NUMERIC_ROUNDABORT OFF,

       QUOTED_IDENTIFIER ON,

       CURSOR_CLOSE_ON_COMMIT OFF,

       CURSOR_DEFAULT LOCAL,

       RECURSIVE_TRIGGERS OFF

WITH ROLLBACK IMMEDIATE;

   ALTER DATABASE [OMEssentials]

       SET PAGE_VERIFY NONE

       WITH ROLLBACK IMMEDIATE;

   IF (fulltextserviceproperty(N'IsFulltextInstalled') = 1) begin

EXECUTE sp_fulltext_database 'disable';

END

END

EXEC ('sp_dboption N''OMEssentials'', N''bulkcopy'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''dbo use'', N''false''')

EXEC ('sp_dboption N''OMEssentials'', N''trunc. log on chkpt.'', N''true''')

EXEC ('sp_dboption N''OMEssentials'', N''db chaining'', N''false''')

-- -- --

-- Add missing tables created before ITA 8.9

-- -- --

-- When the 'SchemaVersion' view is missing it is either an old database or a brand new database.

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[SchemaVersion]')) begin

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MaserInfo]') AND type in (N'U')) BEGIN

CREATE TABLE [dbo].[MaserInfo]

(

[DeviceId] [int] NOT NULL,

[MaserType] [nvarchar](256) NOT NULL,

[MaserOptionalStorageSize] [int] NULL,

);

END

END

Undefined exception occurred:

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_dboption'.

Could not find stored procedure 'sp_dboption'.

Could not find stored procedure 'sp_dboption'.

Could not find stored procedure 'sp_dboption'.

Could not find stored procedure 'sp_dboption'.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at InstallUtil.Installers.Database.Database.RunScriptFile(SqlConnection sqlConnection, String filePath, String databaseName, String dataFilePath, String logFilePath)

  at InstallUtil.Installers.Database.Database.Install(DatabaseOptions databaseOptions)

  at InstallUtil.Program.RunInstall(CommandLineArgumentsDictionary arguments)

  at InstallUtil.Program.Main(String[] args)

2012-06-01 09:25:06 AM

"C:\Program Files (x86)\Dell\SysMgt\Essentials\bin\WebInstall\InstallUtil.exe" -u

Uninstall()

RemoveWindowsGroups(...)

Exception thrown while uninstalling our windows security groups.

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'OMEssentials.dbo.SecureRole'.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

  at System.Data.SqlClient.SqlDataReader.get_MetaData()

  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader()

  at InstallUtil.Installers.Database.Database.RemoveWindowsGroups(SqlConnection sqlConnection)

  at InstallUtil.Installers.Database.Database.Uninstall(Nullable`1 databaseOptions)

Deleting Database [OMEssentials]

Exception thrown while uninstalling the database.

System.Data.SqlClient.SqlException (0x80131904): Cannot drop database "OMEssentials" because it is currently in use.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at Helpers.Extensions.SqlConnectionHelper.DropDatabase(SqlConnection sqlConnection, String databaseName)

  at InstallUtil.Installers.Database.Database.Uninstall(Nullable`1 databaseOptions)

Exception thrown while uninstalling the [OMEService] SQL Server login.

System.Data.SqlClient.SqlException (0x80131904): Login 'OMEService' owns one or more database(s). Change the owner of the database(s) before dropping the login.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at InstallUtil.Installers.Database.Database.Uninstall(Nullable`1 databaseOptions)

RemoveRegistryKeys()

Website un-install started...

Website un-install completed.

HostServiceInstaller.Uninstall()

4 Apprentice

 • 

2.8K Posts

June 1st, 2012 08:00

Thanks for posting this log, it helped.

But then I went back to re-read your original post and you had the info I needed right there.

We currently support SQL 2005 and SQL 2008.  The readme shows the versions/SPs we support.  At the moment support for 2012 is in development and we hope to have that released later this year.  In the meantime, OME has SQL 2008 on the installer and will lay out down automatically (when no db is detected).  An alternative would be to install SQL 2008 on another server and point to that location for the database.

Hope this helps and good luck.

Rob

en.community.dell.com/.../20061471.aspx

June 1st, 2012 09:00

I did wonder when I saw the line:

Could not find stored procedure 'sp_dboption'

I'm guessing OME needs this procedure which is missing from 2012. I have another VM with 2008 on so I'll test it on there.

Thanks for your help Rob.

4 Apprentice

 • 

2.8K Posts

June 1st, 2012 10:00

Yep.  Good deal.  Keep me posted...thx!

June 13th, 2012 09:00

Successfully installed when running SQL Express 2008 R2 SP1!

4 Apprentice

 • 

2.8K Posts

June 13th, 2012 09:00

Ha! Great.  Let me know how the rest of it goes...we'll be around...

Rob

No Events found!

Top