Additional database installation

If you chose not to install the database during the installation process, you can install it later. To trigger the database installation, access any page of your web project in a browser. The system will redirect you to the database installation wizard.

Step 1 - SQL Server and Authentication Mode

Specify the SQL Server and authentication mode used to access the server:

• SQL Server name or IP address - enter the name of the server. You will typically use one of these:
  • the name of the server (such as DBSERVER1)
  • the IP address of the server (such as 192.168.1.105)
  • (local)<SERVERNAME>\sqlexpress (if you're using Microsoft SQL Server Express Edition)
• Use SQL Server account - use this option if your server is configured for SQL Server Authentication with SQL logins.
• Use integrated Windows authentication (ASP.NET account) - use this option if your SQL Server is configured for Windows integrated authentication. In this case, you need to use SQL Server Management Studio to create a new login for user account under which you currently run the web application (for example, the NT AUTHORITY\NETWORK SERVICE for Windows 7 - the actual ASP.NET account name is displayed on the screen).

Click Next.

Step 2 - Database Instance

Now you can decide if you want to use an existing database or create a new database. In both cases, you need to enter the name of the database into the appropriate field.

In case you are using an existing database, you can choose if you want to Create Kentico database objects.

• If the existing database already contains Kentico objects (tables, stored procedures, views), then clear the check box.
• If the database does not contain these objects (typically when you are installing into an empty database), leave the check box enabled.

Database Collation

When using an existing database, you may also come across the Database Collation dialog. It is displayed if the database collation is different from . The dialog lets you choose if you want to change the collation or leave the original one.