Microsoft SQL Server 2012 Express Edition (supplied with WebCenter) is a free version of Microsoft SQL Server 2012 that can
serve as the database engine for WebCenter.
To install it, use the Install the SQL Server 2012
Express Edition database engine for WebCenter link on the WebCenter installation media.
Following steps describe how to install the MSSQL Server 2012 Express database on a
clean system:
- When the SQL Server Installation Center launches,
select the option New SQL Server stand-alone installation or add
features to an existing installation.
- If prompted, accept the License Terms and click
Next.
- A quick check will be done and the installation will be prepared.
- Select the Features you wish to install. If unsure,
enable all except LocalDB.
- On the Instance Configuration screen, select
Named Instance and name your instance
WEBCENTER. You can also change the instance root
directory if you want.
- On the Server Configuration screen, you can define
separate accounts for each service, leave as default.
- You can also specify your Database Engine Collation,
leave as default.
- On the Database Engine Configuration screen, choose
the Mixed Mode authentication type.
- On the same screen, specify the SQL Server system administrator
(sa) password. The default password is (XXXXXX), but you can
enter a different one if desired.
- On the Reporting Services Configuration screen,
select Install and Configure and click
Next.
- The system will now continue with the installation. The last screen shows
that the installation process was completed successfully. You may be asked
to restart the computer.
- If you now inspect your Programs, you should see Microsoft SQL
Server 2012 listed, along with other tools like
SQL Server Management Studio.
- Launch the SQL Server Management Studio to check the
connection to the Database Engine.
- In case it has not been created yet, add a new database named
WebCenter4_0.
- Launch the SQL Server Configuration Manager to check
the TCP/IP and SQL Server service statuses.
- Choose , make sure TCP/IP is set to
Enabled for
WEBCENTER.
- In the SQL Server Services section, restart the
SQL Server service. Also, make sure the
SQL Server Browser service is running.