PREREQUISITES: You must use SQL Server Management Studio 2014 with Cumulative update package 6.
Before you publish your project to Azure Web Apps, you must upload your project's database to Azure SQL Database.
Perform the following:
<add dbType="SqlAzure" name="Sitefinity" connectionString="Server=<serverName>.database.windows.net;User ID=<userName>@<serverName>;Password=<password>;Database=<databaseName>; Trusted_Connection=False;Encrypt=True" providerName="System.Data.SqlClient" />
NOTE: For Sitefinity CMS to function normally with SQL Azure, set the dbType attribute to SqlAzure.
If you receive an error similar to: Error SQL71564: The element User: [NT AUTHORITY\NETWORK SERVICE] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12 (Preview)…, remove all users that rely on local login from the database before starting the deployment procedure.
Back To Top
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.