Orchestrator Installation on Oracle Cloud

Hello, I am trying to install orchestrator after installation when i try to access the website for login i get error 500 when i see the event viewer i get the following error

Log Name: Application
Source: WebhookService
Date: 11/21/2022 6:20:51 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Window2019ForUI
Description:
LedgerManagerSql::GetLedgerMessageAsync - component id := “WebhookSubscriber” instance id := “ad85259e-cb5c-4288-b4e0-6a9e4c70b89b” exception := “Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "UiPath" requested by the login. The login failed.
Login failed for user ‘IIS APPPOOL\Webhooks’.
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(CancellationToken cancellationToken) --- End of stack trace from previous location --- at UiPath.Platform.Ledger.Common.LedgerClientSqlHelper.ExecuteSqlAsync(Func1 createConnection, String subscriberId, String instanceId, String commandStatement, IEnumerable`1 parameters, CancellationToken cancellationToken)
at UiPath.Platform.Ledger.Managers.LedgerManagerSqlBase.GetLedgerMessageAsync(CancellationToken cancellationToken)
ClientConnectionId:d9013d4e-9d01-4ddd-9cc9-8e3c101f758d
Error Number:4060,State:1,Class:11”

Event Xml:



0
2
0
0x80000000000000

2887
Application
Window2019ForUI



LedgerManagerSql::GetLedgerMessageAsync - component id := “WebhookSubscriber” instance id := “ad85259e-cb5c-4288-b4e0-6a9e4c70b89b” exception := “Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "UiPath" requested by the login. The login failed.
Login failed for user ‘IIS APPPOOL\Webhooks’.
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(CancellationToken cancellationToken) --- End of stack trace from previous location --- at UiPath.Platform.Ledger.Common.LedgerClientSqlHelper.ExecuteSqlAsync(Func1 createConnection, String subscriberId, String instanceId, String commandStatement, IEnumerable`1 parameters, CancellationToken cancellationToken)
at UiPath.Platform.Ledger.Managers.LedgerManagerSqlBase.GetLedgerMessageAsync(CancellationToken cancellationToken)
ClientConnectionId:d9013d4e-9d01-4ddd-9cc9-8e3c101f758d
Error Number:4060,State:1,Class:11”


I have solved this.
The issue was to add the IIS APPPOOL\ * had to be added to the sql database login