AddDistributedSqlServerCache connection not working

Question

Below code is not working with this connection string. Connection string "Server=AZURESQLSERVER.database.windows.net,1433;Database=AZURE_DB;Authentication=Active Directory MSI;"

services.AddDistributedSqlServerCache(options =>
    {                
                options.ConnectionString = CRAFDBConnection;                
                options.SchemaName = "dbo";
                options.TableName = "SQLSessions";
   });

Any suggestions ??

Answer 1

It's hard to know without the exact error you're getting, but Managed Identity Auth (MSI) is only available with Microsoft.Data.SqlClient 2.1.0 or newer. If you're using a user-assigned managed identity, you'll need to specify either the client id (v3+) or object id (v2.1), like so: // With Microsoft.Data.SqlClient v3.0+ string ConnectionString1 = @"Server=demo.database.windows.net; Authentication=Active Directory Managed Identity; Encrypt=True; User Id=ClientIdOfManagedIdentity; Database=testdb";