...
The following JSON code block explains the the parameters required and their intention:
| Code Block | ||||
|---|---|---|---|---|
| ||||
{
//These are the credentials used to access the EdFi_Admin database.
"AdminCredentials":{
"Password":"[dbpassword]",
"UserName":"[dbuser]"
},
// This is the address of the MsSQL server. This can be a DNS or an IP Address.
"HostName":"[the SQL Server: sql.somthing.com]",
// These are the credentials that will be stored encrypted that the Admin App will use to connect to the Ed-Fi ODS API
"ProductionApiCredentials":{
"Password":"[SecurePassword]",
"UserName":"EdFiOdsProductionApi"
},
"AdminAppCredentials":{
"Password":"[SecurePassword]",
"UserName":"EdFiOdsAdminApp"
}
} |
Modify the SQL statement below by providing the User Name and Password for the required fields marked with square brakets "[...]"
Following the steps above open SSMS or Azure Query Editor and execute the following statement against the EdFi_Admin database.
| Code Block | ||||
|---|---|---|---|---|
| ||||
BEGIN TRAN
UPDATE adminapp.AzureSqlConfigurations set field='{"AdminCredentials":{"Password":"PW Specified in Deployment Script","UserName":"SERVER Master UN"},"HostName":"","ProductionApiCredentials":{"Password":"Enter PW","UserName":"EdFiOdsProductionApi"},"AdminAppCredentials":{"Password":"","UserName":"EdFiOdsAdminApp"}}' WHERE Id=1;
COMMIT TRAN |
...