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
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.
Powered by Progress Sitefinity