Open Manage Essentials installation fails

Hi,

Thanks for your post.

Are you using the pre-installed version of SQL? In that case, are you using custom installation option and pointing to the existing DB? You can look at "C:\Windows\Temp\InstallUtil.log" to see if there are any additional errors reported by the installer.

Regards

Abhijit

Dear Abhijit,

Below is the log from location, i see that somewhere it is unable to create the database even though the login is having full role.please advise

2012-10-02 11:18:34 AM

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

Uninstall()

Exception thrown while uninstalling our windows security groups.

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "OMEssentials" requested by the login. The login failed.

Login failed for user 'AK\Administrator'.

  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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

  at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)

  at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)

  at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

  at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

  at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

  at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

  at System.Data.SqlClient.SqlConnection.Open()

  at InstallUtil.Installers.Database.Database.OpenSqlConnection(String initialDatabaseName)

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

Deleting Database [OMEssentials]

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

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '='.

  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()

Hi,

Can you address Abhijit's question from above: Is this a pre-installed (existing) SQL install?  Or are you letting OME install SQL express?

Thx.

Rob

Thanks for the udpates. Are you using custom install option in OME and selecting the existing database or choosing the default?

You're putting SCOM _and_ OME on the same server?? :-)

Not related to the db error you mention (most likely).  But how much RAM & cores do you have on that 2950?

Rob

sorry if i forgot to mention, it is a pre installed sql 2005 with sp4 and there are other databases running with the same credentials , i have SCOM 2007 on the same server where i am trying to install the OME for doing the firmware and other updates.

Thanks

Can you also confirm if the account you are using has dbowner privileges for the SQL? OME needs dbowner privileges for installation.

I had tried both the options , same result.

How many devices to you plan on managing in OME on this server?

thx!

around 45 servers including blade chassis

8 gb ram , dual core i guess 3.4ghz. db_owner was not selected but i had applied and restarted sql but still the installatino failed again

Ok thx.

That should be ok as long as SCOM isn't taking any cycles.  UG shows 4GB and 2 core for 100 servers or less.

If other software is running on that server, you could get CPU bound, so take care.

thx

Rob

support.dell.com/.../UG_en.pdf

Thanks for the updates. It would be better to call support and they can look at all the logs. It would be good to verify that the account has db_create permissions and you might have to delete OMEservice user from the DB if you have one before trying to install again. Here is the number for support 800-945-3355

Regards

Abhijit