Problem Installation Always On with Cireson System Center Service Manager Portal

Margarete_Jussen

Hello,

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

 

Brian_Wiest

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.

Brian_Wiest

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. 

Brian_Wiest

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. 

Brian_Wiest

Server=db-uklac202
Is this your listener or one of the nodes?

Margarete_Jussen

One of the nodes.

Brian_Wiest

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.

Margarete_Jussen

I installed the Service Management Database while the Service Manager Database was already in the AG. Was that already a fault?

Brian_Wiest

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. 

Margarete_Jussen

In the install wizard the Name of my listener was not found. I try it now with the ip-adress of my listener. Maybe it works.

Brian_Wiest

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. 

Margarete_Jussen

Ok. I thought this might not be. Thank you very much I will try again.