Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The format of this string is JSON and specifies a few key: value pairs.

The string looks something like thisHere is a template of how it looks: {"AdminCredentials":{"Password":"[dbpassword]","UserName":"[dbuser]"},"HostName":"[the SQL Server: sql.somthing.com]","ProductionApiCredentials":{"Password":"[SecurePassword]","UserName":"EdFiOdsProductionApi"},"AdminAppCredentials":{"Password":"[SecurePassword]","UserName":"EdFiOdsAdminApp"}}

The following JSON code block explains the the 

Code Block
languagejs
titleSQL
{
	"AdminCredentials":{ //These are the credentials used to access the EdFi_Admin database.
	"AdminCredentials":{ 
			"Password":"[dbpassword]",
			"UserName":"[dbuser]"
	},
	"HostName":"[the SQL Server: sql.somthing.com]", // This is the address of the MsSQL server. This can be a DNS or an IP Address.
	"ProductionApiCredentials":{ 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"
	}
}

...

Code Block
languagesql
titleSQL
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


3) Update Admin App web site on IIS or Azure

...