Azure App Identity Service Upgrade From 2019 To Latest Version Failed

News Knowledge Base
1

Running cli with arguments: install -d "" -r, Error is received.

Error:

Running cli with arguments: install -d "" -r

[16:07:14 FTL] An error has occurred while installing the database. Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.

at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

......................

at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()

Resolution:

  1. When upgraded from 2019 to the latest version after creating the identity service, make sure the Connection String need to be create in Azure app identity service.

12.jpg

  1. From the above screenshot, click on Advance Edit and copy paste the below script and edit as per the Database Server and credentials

[

{

"name": "Default",

"value": "Server=tcp:orch.database.windows.net,1433;Initial Catalog=orchd2021_10_4;Persist Security Info=False;User ID=test;Password=test@123;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;",

"type": "SQLAzure",

"slotSetting": false

}

]

Refer this doc for more information: Identity Server Steps .