Problem Installation Always On with Cireson System Center Service Manager Portal
Margarete_Jussen
Customer Adept IT Monkey ✭✭
we want to installed our new productive environment on a Server who is part of an Availability Group. After Failover the database is not reachable via web console. The following error message occurs.
Error accessing SQL Database: Server=db-uklac202;Database=ServiceManagement;Trusted_Connection=True; Error: System.Data.SqlClient.SqlException (0x80131904): The target database, 'ServiceManagement', is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability replicas in the group. For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Cireson.ServiceManager.DAL.Database.<ReadFromStoredProcedure>d__31`1.MoveNext()
ClientConnectionId:90bd4a28-f2cb-45ff-a4ae-7eeaf48f8e1f
Error Number:976,State:1,Class:14
Could anyone help, please?
Regards Margret
Best Answers
-
Brian_Wiest
Customer Super IT Monkey ✭✭✭✭✭
When you install the portal with AG
Do not have the AG synced, the Detpak install will faile so only have the DB on one node.(IE have the AG configured but the DB not in the AG)
Then in the install wizard
ServiceManagement Database Server Name = AG Listener
Also if your SCSM is in a AG make sure to use the Listener for that setting.
Once the portal install complete add the DB back to the AG
Also remember this applies to the Analytics DB for the install.6 -
Brian_Wiest
Customer Super IT Monkey ✭✭✭✭✭
Service Manager is a AG during install I never had an issue with.
The Cireson install while they support AG's when the install runs the detpac deployment will fail. So I always have to remove the DB from the AG run the install then rebuild the AG.5 -
Brian_Wiest
Customer Super IT Monkey ✭✭✭✭✭
You need to use the name.
Is it that your are getting the yellow triangle? I get that as well but continue thru and it will install successfully.5
Answers
Is this your listener or one of the nodes?
Do not have the AG synced, the Detpak install will faile so only have the DB on one node.(IE have the AG configured but the DB not in the AG)
Then in the install wizard
ServiceManagement Database Server Name = AG Listener
Also if your SCSM is in a AG make sure to use the Listener for that setting.
Once the portal install complete add the DB back to the AG
Also remember this applies to the Analytics DB for the install.
The Cireson install while they support AG's when the install runs the detpac deployment will fail. So I always have to remove the DB from the AG run the install then rebuild the AG.
Is it that your are getting the yellow triangle? I get that as well but continue thru and it will install successfully.