How to Install Windchill 10.2 M030 with SQL Server 2014 on Windows Server 2012 R2: SQL Server 2014 Installation Steps

Load the SQL disc and run the installation.

     1.  Click Installation

     2.  Click New SQL Server stand-alone installation or add features to an existing installation

     3.  Usually the product key is already entered for you.  If not, please enter it now to prevent license issues down the road.

     4.  Check the box next to I accept the license terms

     5.  Select SQL Server Feature Installation

     6.  Check the box next to all the features shown below.  These are the minimum required.  Don't worry about the installation directories at the bottom.  We'll tell you why later.

     7.  You can use a Named Instance if you would like but if Windchill is the only or first software being used with this SQL installation, the default instance is recommended.

     8.  Change all the accounts to use NT AUTHORITY\SYSTEM.  If this isn't listed by default in the drop down box, click << Browse... >>

     9.  Enter "system" and click Check Names

     10.  "SYSTEM" should now show up as below confirming it is a valid object.

     11.  Repeat for all other services that you can.  Change the Startup Type to Automatic.  Click Collation.

     12.  The default collation will not allow you to install Windchill.  You need to change the collation manually.  Click Customize...

     13.  Check the box next to Windows collation designator and sort order and set the collation as below to Latin1_General_100_CS_AS_SC.

     14.  Click Add Current User to add the Windows user you are logged in as an administrator.  Feel free to add other users as well with the Add... button.  Like in an earlier step, don't worry about the Data Directories in this section.  The Windchill install will allow you to specify where the active database files will go regardless of the settings here.

     15.  Select Mixed Mode (SQL Server authentication and Windows Authentication).  This will allow both the previously added windows users as well as a SQL account named "sa" to log in.  Depending on the password policy, it may take a few times to create a password that is accepted.  Be sure to make it a strong password as this account is used on almost all SQL installations.  You will be using the password in the Windchill install steps.

     16.  Click Install

     17.  Make sure everything shows a status of Succeeded and close the window.

     18.  Open up SQL Server Configuration Manager.  Expand SQL Server Network Configuration.  Select Protocols for MSSQLSERVER.  Right click on Named Pipes and click Enable.

     19.  Select SQL Server Services.  Right click and Restart all listed Services.

SQL Server is now installed and you are ready to install Windchill!

How to Install Windchill 10.2 M030 with SQL Server 2014 on Windows Server 2012 R2: Pre-Installation Steps

The following steps will ensure a smooth install.

     1.  Make sure to use a local Admin account

     2.  Disable Antivirus

     3.  Disable UAC

     4.  Disable Firewall (Two Tier Setup Only)

     5.  Disable IEES (Internet Explorer Enhanced Security)

     6.  Make sure to disable or uninstall IIS if it is active (Apache will be using the same port 80 for Windchill)

     7.  Install .Net Framework 3.5

     8.  Set appropriate server name and domain.
                a.  If you want to proceed without going through the DNS setup, you can add the host name and domain you want to the hosts file.  You must also add to each user's hosts file as well until you have the correct name setup in your DNS server.
                b.  Changing this later on will cause Windchill to not function and requires a Rehost.

     9.  Set static IPv4 address (Disable DHCP)

     10.  Download and extract the latest version of all Windchill software listed in your PTC downloads page
                 a.  Make sure to rename all the discs with their appropriate name as the default names have no meaning.  The install will always begin with the PTC Solution Installer.

Now you are ready to install SQL!