Run manual SQL scripts to install the UGC database if you are installing a Microsoft SQL Server database in a Microsoft Azure SQL Database Cloud hosting environment.
Procedure
- Close all connections to your Microsoft SQL Server database server.
- Access your SDL Tridion Sites installation media.
- Navigate to the folder Database\Scripts\MSSQL\Create\.
- Create the database by running the script called UGC_CREATE.sql as a database administrator user (
sa). By default, the script creates a database called UgcDbName. To change this, edit the script to use a different name.
- If you changed the name of the database that the script created, edit the following scripts, changing the name
UgcDbName to your chosen name throughout:
- UGC_TABLES.sql
- UGC_CONSTRAINTS.sql
- UGC_INDEXES.sql
- UGC_CREATE_LOGIN.sql
- UGC_ALTER_LOGIN.sql
- UGC_CREATE_USER.sql
- Run these scripts as a database administrator user (
sa):
- UGC_TABLES.sql
- UGC_CONSTRAINTS.sql
- UGC_INDEXES.sql
- UGC_CREATE_LOGIN.sql
- UGC_ALTER_LOGIN.sql (skip this script if you use the Microsoft Azure SQL Database hosting service).
- UGC_CREATE_USER.sql
- Navigate to the the folder Database\Scripts\MSSQL\Shared\110\ and run the following script as a database administrator user (
sa), again changing the database name if needed: