Skip to main content
12-Amethyst
July 27, 2023
Solved

sql server install

  • July 27, 2023
  • 2 replies
  • 1077 views

Prior to installing windchill pdmlink 12.1.x do we need to have sql server installed?

 

or does PSI install the software and create DB, Installation user, and application user?

 

Best answer by avillanueva

You need to have SQL Server installed for sure but there are options depending on what you want the PSI to do.  With Oracle, I could provide the main system login and PSI will build everything. Since I am not authorized for that, my DBA built an empty DB and provided my with the creds to build the tablespaces.

 

Here are some related links you should read:

https://www.ptc.com/en/support/article/CS383998?source=search

https://www.ptc.com/en/support/article/CS306935?source=search

https://www.ptc.com/support/-/media/support/refdocs/Windchill_PDMLink/12,-d-,1/WCInstallConfigGuide_12_1_2_0.pdf?sc_lang=en&source=search

https://www.ptc.com/support/-/media/support/refdocs/Windchill_PDMLink/12,-d-,0/WindchillSoftwareMatrices_12_0_2_0.pdf?sc_lang=en&source=search

 

 

2 replies

avillanueva
23-Emerald I
July 28, 2023

You need to have SQL Server installed for sure but there are options depending on what you want the PSI to do.  With Oracle, I could provide the main system login and PSI will build everything. Since I am not authorized for that, my DBA built an empty DB and provided my with the creds to build the tablespaces.

 

Here are some related links you should read:

https://www.ptc.com/en/support/article/CS383998?source=search

https://www.ptc.com/en/support/article/CS306935?source=search

https://www.ptc.com/support/-/media/support/refdocs/Windchill_PDMLink/12,-d-,1/WCInstallConfigGuide_12_1_2_0.pdf?sc_lang=en&source=search

https://www.ptc.com/support/-/media/support/refdocs/Windchill_PDMLink/12,-d-,0/WindchillSoftwareMatrices_12_0_2_0.pdf?sc_lang=en&source=search

 

 

23-Emerald IV
August 23, 2023

As @avillanueva stated, you need to have SQL Server installed first.  The installation guide will walk you through how to install it and what options to select.  After SQL Server is installed, a new, empty database must be created.  The Windchill installer can do this for you, or you can create it manually.  (See https://www.ptc.com/en/support/article/CS28197 for the manual process.)