Charanjit Singh (Partner) asked a question.

Managed Identity DB connection issue

Hello,

 

We recently migrated to managed-identify DB connection.

The given connection string from the Data team is:

  1. <add connectionString="Server=REDACTED-sql.database.windows.net,1433;Database=REDACTED;Authentication=Active Directory Managed Identity;User Id=REDACTED;Encrypt=True;TrustServerCertificate=False;" providerName="Microsoft.Data.SqlClient" dbType="SqlAzure" name="Sitefinity" />

The Sitefinity app failed to start with the error message:

  1. Message: Telerik.OpenAccess.OpenAccessException: System.ArgumentException: Invalid value for key 'authentication'.
  2. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes)
  3. at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType)
  4. at OpenAccessRuntime.Relational.RelationalStorageManagerFactory..ctor(StorageManagerFactoryBuilder b)
  5. at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL() ---> System.ArgumentException: Invalid value for key 'authentication'.
  6. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes)
  7. at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType)
  8. at OpenAccessRuntime.Relational.RelationalStorageManagerFactory..ctor(StorageManagerFactoryBuilder b)
  9. at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
  10. --- End of inner exception stack trace ---
  11. at DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_ec665e4f2599486cb10c4a4d56ab78ac.Initialize(String providerName, NameValueCollection config, Type managerType)
  12. at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, Type managerType)
  13. at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, Type managerType)
  14. at Telerik.Sitefinity.Data.ManagerBase`1.ResolveProvider(String providerName, String dataSourceName)
  15. at Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName)
  16. at Telerik.Sitefinity.Data.Metadata.MetadataManager..ctor()

Looks like the `Authentication=Active Directory Managed Identity` is not recognized/allowed by Sitefinity's base DB connector.

I can confirm that the new connection string works with the generic `System.Data.SqlClient` on our VM.

 

Any advice to resolve the issue please.

 

Thanks