Install SQL Server Database
Install SQL Server onto the database system by launching setup.exe from the DVD or downloaded media.
In the SQL Server Installation Center, select New installation or add features to an existing installation to install the new server.
During the installer process, there are several pre-installation checks performed, including the System Configuration Checker and Setup Support Rules. Additional prerequisite components may be installed on the system as well during Setup Support Files if they are not previously installed.
Address any warnings or missing items using the detailed links provided by the Microsoft installer. Detailed instructions for installation can be found at this link:
After completing the preconfiguration steps, enter the product key and accept the license terms. In the Setup Role window, choose SQL Server Feature Selection in order to be able to select the specific features required by Windchill.
These are the minimum options needed to support a SQL Server database for Windchill.
• Database Engine Services
◦ Full-Text and Semantic Extractions for Search
• Client Tools Connectivity
• SQL Client Connectivity SDK
|
|
Depending on your utilization of the SQL Server instance that you are installing, you may include other components as well.
|
If you plan to install Microsoft SQL Server management studio on the same host then you will need to launch SQL Server installer again and select “Install SQL Server Management Tools” option from SQL Server Installation Center.
In the Instance Configuration window, choose either Default or Named instance. Windchill can be deployed using either option, but using a Named instance requires additional configuration of the tcp port. If there is any possibility that other instances would be added to this machine in the future, use a named instance such as WINDCHILL for clarity.
SQL Server using the Default
Service Accounts instance will listen to tcp 1433 by default. However, a Named instance uses a dynamic port configuration instead, so you will have to configure it with port 1433 using the SQL Server Configuration Manager (see
http://msdn.microsoft.com/en-us/library/ms177440.aspx) before running the Windchill Solution Installer.
Review and approve the disk space requirements or relocate as necessary.
The Service Accounts tab is used to configure the Services. These can all be configured simply by selecting nd using NT AUTHORITY\SYSTEM as the account.
For better security instead, use the detailed recommendations for different accounts listed at this link:
In the Database Engine Configuration window, Account Provisioning tab, select Mixed Mode (SQL Server authentication and Windows authentication). This is required because the system administrator (sa) account is used by the PTC Solution Installer during the database initialization process. Other administrators from the host machine or domain can be added at this time as well, but be sure to enter and remember a password for the sa account at this time.
In this dialog, Windows will enforce the rules for passwords set in the Local Security Policy tool under Account Policies/Password Policy.
Error reporting is not required. Select Installto complete the installation.
At the completion of the installation process, the SQL Server installer provides you with a Setup Progress dialog.
The following configuration step is required. Select Start/All Programs/Microsoft SQL Server /Configuration Tools/SQL Server Configuration Manager. In this tool, expand the node SQL Server Network Configuration and highlight Protocols for <Instance Name>. In the right-hand window, right-click on TCP/IP and choose Properties.
TCP/IP should be enabled by default for all IP addresses, but port 1433 must be set as the communication port for the IPALL category. To do this, select the IP Addresses tab, scroll down to the IPALL listing, then in the set a blank value for TCP Dynamic Ports and the value 1433 for TCP Port.
|
|
You will need to restart the instance for the changes to take effect.
|
After the installation of SQL Server has successfully completed open a new query window from SQL Server management studio, login as database admin user sa, and execute the following statements to activate contained DB support:
use master
GO
sp_configure 'contained database authentication', 1;
GO
RECONFIGURE
GO
|
|
Windchill supports SQL Server contained database and contained database authentication. A contained database can authenticate users without requiring them to login at the Database Engine level. However, database level authentication has some restrictions compared to SQL Server login. Database authenticated users are only allowed to access and modify objects contained within the database, and restricted from performing database top-level tasks like backup, restore, modify, and shrink. Database top-level tasks must be performed by a database instance administrator (i.e. sa). For more information about SQL Server contained databases and the contained database authentication Server Configuration Option, see the Microsoft online documentation at the following URsL:
|
