Installing the database for an Azure project

After you have deployed your Azure project to the cloud, continue to installing the database. The Microsoft Azure project can use any type of SQL database, hosted either on a standard SQL Server or in the cloud. This topic describes the installation on an SQL Azure server.

If you have already configured the connection string for your project, you can skip the Generating the connection string and Setting the connection strings sections.

Installing a database on an Azure SQL server

To install the database on an Azure SQL server, use the system to generate the connection string, paste the connection string as a value to your cloud service and let the system install the database.

Generating the connection string

  1. Access the website of your deployed Azure project.

    • You can find the URL if you choose Cloud services -> select your service -> Dashboard under Site URL.
      Locating the URL of the Azure project
  2. Specify the target Azure SQL server (which you have created according to the instructions in Preparing the cloud environment) and supply the credentials for the server:

    • SQL Server name or IP address – enter the SQL Azure server name, which you can find at SQL Databases -> select your database -> Dashboard under Server name. The standard format is <servername> the Azure SQL server name and its credentials
  3. Click Next.

  4. Enter the name of the SQL database (which you have created according to the instructions in Preparing the cloud environment).

  5. Choose whether you want to Create Kentico CMS database objects.

    • Select this option if you are installing into an empty database.
    • Clear this option if the existing database already contains Kentico objects (tables, stored procedures, views).
  6. Click Next.

  7. Copy the second connection string value into the clipboard. 

    Copying the connection string for the ServiceConfiguration.cscfg file

Setting the connection strings

  1. Open the Azure Management Portal in another browser tab.

  2. Navigate to Cloud services -> select your service -> Configure.

  3. Paste the copied connection string value into the fields of the CMSConnectionString setting for the CMSApp role and also the SmartSearchWorker role if you are using it.

    Setting the connection string for service roles

  4. Click Save.

  5. Close the original window with the database installation.

You have configured the connection strings for your database.

Finishing the database installation

  1. Open the website of your project anew (<your cloud service name>
    • The database installation automatically resumes.
  2. Confirm the target database by clicking Next.
    • The installer now installs the database for your project.
  3. Enter a license key for the domain.
    • Staging deployments are automatically covered by any other valid license, so you do not have to request a separate license for staging deployments. However, this applies only if you use the recommended configuration, which is to use separate databases for live and staging environment.
  4. Click Next.
  5. Choose an initial website to install:
    • Choose a starter site – you can choose from the supplied sample sites to try out the functionalities of the system or use it as a base for custom development. We recommend the Corporate site or the E-commerce site.
    • Continue to the New site wizard – choose this option if you want to to develop a new site from scratch. See Creating new sites using the New site wizard for more information.
    • Import existing Kentico CMS website – choose this option if you have already created a website using Kentico and you want to import it to the new installation. See Importing a site or objects for more information.
  6. Click Next.

The installer creates your chosen website and finishes the installation.

If you continue to your new website, you can log in to the administration interface.

Login to our sample starter sites:

User name: administrator
Password: (blank password)