none
Unable to install the Web Console in SCOM RRS feed

  • Question

  • Hi All,

    I am trying to install the Web Console for SCOM. I have the infrastructure as specified. I have one Virtual Machine that has the AD and DNS. The second Virtual Machine has the SCOM and the SQL server installed in it. this Server also has the Reporting console installed. I am now trying to install the web console on to a third Virtual Machine. This Machine is domain-joined and has the necessary IIS roles installed in it. I have also restarted the system after the installation the IIS roles.

    When I try to install the web console using the operations manager setup, I get the below mentioned error and this has happened for a number of times.

     I have tried to find the solution of this error but I did not get satisfactory result. Kindly help.

    Thanks in advance.

    Thursday, May 30, 2019 12:41 PM

Answers

  • I have seen that issue and 2 main reasons:

    1. Your Install account needs to be a Sysadmin as the Installer runs few SP's on the Master database where the Operationsmanager DB is hosted.

    2. Your SQL team changed the Database backup location, And did not restart the SQL services for the changes to take effect.

    In the Install Log for the 1st issue you would see the below error:

    09:36:51]:        Info:        :Info:Using DB command timeout = 1800 seconds.

    [09:36:51]:        Error:        :DB operations failed with SQL error 297: The user does not have permission to perform this action.

    : Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: The user does not have permission to perform this action.

    [09:36:51]:        Error:        :StackTrace:   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

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

       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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

       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 Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, SqlDataReader& result)

       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.Execute[T](SqlCommand sqlCommand, SqlRetryPolicy retryPolicy, GenericExecute`1 genericExecute)

    [09:36:51]:        Error:        :Error:Failed to execute sql command. Setup will not retry on this Sql error. Command: SELECT ar.replica_server_name FROM sys.availability_group_listeners agl INNER JOIN sys.dm_hadr_availability_replica_states ars ON agl.group_id = ars.group_id INNER JOIN sys.availability_replicas ar ON ars.replica_id = ar.replica_id WHERE ars.role_desc = 'PRIMARY' AND agl.dns_name = @ServerName

    [09:36:51]:        Error:        :Sql error: 16. Error: 297. Error Message: The user does not have permission to perform this action.

     

    In the Install Log for the 2nd issue you would see the below error:

    [14:51:39]: Error: :IsDatabaseCreationAllowed(): Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: A file activation error occurred. The physical file name 'E:SCOMINSTALLTESTDB_636438486997762726.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
    CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
    [14:51:39]: Error: :StackTrace:   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.CreateTempSqlDatabase(SqlConnection sqlConnection, String databasePath, String databaseLogPath)
    [14:51:39]: Info: :Info:Database Creation succeeded: False
    [14:51:39]: Info: :Info:Attempting to create directories specified for the databases.
    [14:51:39]: Debug: :MSSQLSERVER on server SCOMDB01 is in a running state
    [14:51:39]: Debug: :Connection was not open.  We will try to open it.
    [14:51:39]: Debug: :SqlConnectionReady returned True.
    [14:51:39]: Info: :Info:Using DB command timeout = 1800 seconds.
    [14:51:39]: Info: :SQL Product Level: SP1
    [14:51:39]: Info: :SQL Edition: Standard Edition (64-bit)
    [14:51:39]: Info: :SQL Version: 13.0.4001.0
    [14:51:39]: Info: :Info:Using DB command timeout = 1800 seconds.
    [14:51:39]: Info: :Info:  Provided SQL Server is already a physical endpoint
    Log Name:      Application
    Source:        .NET Runtime
    Date:          10/17/2017 2:51:39 PM
    Event ID:      1026
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SCOMWEB01
    Description:
    Application: SetupChainerUI.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.UriFormatException
       at System.Uri.CreateThis(System.String, Boolean, System.UriKind)
       at Microsoft.EnterpriseManagement.OperationsManager.SetupCommon.SetupUtils.ConvertPathToRemote(System.String, System.String)
       at Microsoft.EnterpriseManagement.OperationsManager.SetupCommon.SetupUtils.CreateDirectoryForDatabase(System.String, System.String, Boolean ByRef)
       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.CreateSqlDirectories(System.String, System.Nullable`1<Int32>, System.String, System.String, DeleteDirectory ByRef)
       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.IsDatabaseCreationAllowed(System.String, System.Nullable`1<Int32>, System.String, System.String)
       at Microsoft.SystemCenter.Essentials.SetupFramework.WebConsoleSite.GetValidationProperties(System.Object)
       at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
       at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()

    Let me know if this helps.


    Gautam.75801

    • Marked as answer by garima4496 Friday, May 31, 2019 5:47 AM
    Thursday, May 30, 2019 8:33 PM
  • I was trying to install the webconsole using the local administrator account. I logged on to the system as the User that has the proper rights and then I was able to install the Web console without failure.
    • Marked as answer by garima4496 Friday, May 31, 2019 9:03 AM
    Friday, May 31, 2019 9:03 AM

All replies

  • Hi,

    Could you provide some more information about your environment?

    • SCOM server operating system version
    • SQL Server version
    • SCOM version

    Please check the SCOM installation logs for any more information regarding why your setup is failing.

    You can find the logs over here:

    • %LocalAppData%\SCOM\Logs\WebConsole.log

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, May 30, 2019 1:12 PM
  • I have seen that issue and 2 main reasons:

    1. Your Install account needs to be a Sysadmin as the Installer runs few SP's on the Master database where the Operationsmanager DB is hosted.

    2. Your SQL team changed the Database backup location, And did not restart the SQL services for the changes to take effect.

    In the Install Log for the 1st issue you would see the below error:

    09:36:51]:        Info:        :Info:Using DB command timeout = 1800 seconds.

    [09:36:51]:        Error:        :DB operations failed with SQL error 297: The user does not have permission to perform this action.

    : Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: The user does not have permission to perform this action.

    [09:36:51]:        Error:        :StackTrace:   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

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

       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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

       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 Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, SqlDataReader& result)

       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SqlRetryHandler.Execute[T](SqlCommand sqlCommand, SqlRetryPolicy retryPolicy, GenericExecute`1 genericExecute)

    [09:36:51]:        Error:        :Error:Failed to execute sql command. Setup will not retry on this Sql error. Command: SELECT ar.replica_server_name FROM sys.availability_group_listeners agl INNER JOIN sys.dm_hadr_availability_replica_states ars ON agl.group_id = ars.group_id INNER JOIN sys.availability_replicas ar ON ars.replica_id = ar.replica_id WHERE ars.role_desc = 'PRIMARY' AND agl.dns_name = @ServerName

    [09:36:51]:        Error:        :Sql error: 16. Error: 297. Error Message: The user does not have permission to perform this action.

     

    In the Install Log for the 2nd issue you would see the below error:

    [14:51:39]: Error: :IsDatabaseCreationAllowed(): Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: A file activation error occurred. The physical file name 'E:SCOMINSTALLTESTDB_636438486997762726.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
    CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
    [14:51:39]: Error: :StackTrace:   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.CreateTempSqlDatabase(SqlConnection sqlConnection, String databasePath, String databaseLogPath)
    [14:51:39]: Info: :Info:Database Creation succeeded: False
    [14:51:39]: Info: :Info:Attempting to create directories specified for the databases.
    [14:51:39]: Debug: :MSSQLSERVER on server SCOMDB01 is in a running state
    [14:51:39]: Debug: :Connection was not open.  We will try to open it.
    [14:51:39]: Debug: :SqlConnectionReady returned True.
    [14:51:39]: Info: :Info:Using DB command timeout = 1800 seconds.
    [14:51:39]: Info: :SQL Product Level: SP1
    [14:51:39]: Info: :SQL Edition: Standard Edition (64-bit)
    [14:51:39]: Info: :SQL Version: 13.0.4001.0
    [14:51:39]: Info: :Info:Using DB command timeout = 1800 seconds.
    [14:51:39]: Info: :Info:  Provided SQL Server is already a physical endpoint
    Log Name:      Application
    Source:        .NET Runtime
    Date:          10/17/2017 2:51:39 PM
    Event ID:      1026
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SCOMWEB01
    Description:
    Application: SetupChainerUI.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.UriFormatException
       at System.Uri.CreateThis(System.String, Boolean, System.UriKind)
       at Microsoft.EnterpriseManagement.OperationsManager.SetupCommon.SetupUtils.ConvertPathToRemote(System.String, System.String)
       at Microsoft.EnterpriseManagement.OperationsManager.SetupCommon.SetupUtils.CreateDirectoryForDatabase(System.String, System.String, Boolean ByRef)
       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.CreateSqlDirectories(System.String, System.Nullable`1<Int32>, System.String, System.String, DeleteDirectory ByRef)
       at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.IsDatabaseCreationAllowed(System.String, System.Nullable`1<Int32>, System.String, System.String)
       at Microsoft.SystemCenter.Essentials.SetupFramework.WebConsoleSite.GetValidationProperties(System.Object)
       at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
       at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()

    Let me know if this helps.


    Gautam.75801

    • Marked as answer by garima4496 Friday, May 31, 2019 5:47 AM
    Thursday, May 30, 2019 8:33 PM
  • 1. Please review c:\users\<UserName>\Appdata\Local\SCOM\Logs\WebConsole.log for logging of Web console installation. to see any error to provide hint of the error cause.

    2. make sure that your OS version is supported for SCOM web console

    • SCOM 2019 web console supports Windows Server 2016 and Windows Server 2019.
    • SCOM 2016 web console supports Windows Server 2016 and Windows Server 2012R2.

    3. User account used to install web console has local administrative credentials.

    Roger

    Friday, May 31, 2019 2:56 AM
  • I have Windows Server 2016 installed as the Operating System for the server and I am trying to install SCOM 2016. The SQL Server Version is 2016.
    Friday, May 31, 2019 3:37 AM
  • Since you marked Gautam's reply as answer, we would be glad if you could share with us what you did to solve your issue!

    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, May 31, 2019 6:44 AM
  • I was trying to install the webconsole using the local administrator account. I logged on to the system as the User that has the proper rights and then I was able to install the Web console without failure.
    • Marked as answer by garima4496 Friday, May 31, 2019 9:03 AM
    Friday, May 31, 2019 9:03 AM
  • Thanks for sharing your solution with the community!

    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, May 31, 2019 9:06 AM