Select the Server Name of your installed SQL Server. If your SQL Server is installed on a non-standard port, you may enter the port number in the Port Number field. Choose the correct Version of SQL Server you have installed.
The Database Name field defaults to Content Central, but you may change it if you desire.
- SQL Admin Login: Choose the method of authentication for accessing SQL with Admin rights. This security level is necessary to create the Content Central database.
- SQL User Login: Choose the method of authentication you would like Content Central to access SQL with during production. When using SQL Authentication, the username and password provided will be created, i.e., the user does not need to exist in SQL. When using Windows Authentication you will need to access the database and provide db_datareader/db_datawriter access to the system account being impersonated through ASP.NET. This will either be the ASPNET or Network Service account when Local Impersonation is disabled (default) or the system account provided when enabling impersonation as described in Section 4.2, “ASP.NET Impersonation”.
Complete the SQL Settings configuration by selecting each of the three buttons at the bottom of the SQL Settings tab. The Create/Edit Database button will create the database for Content Central, and the Test User Login button will create the user when using SQL Authentication.
