Skip to main content
12-Amethyst
Jul 27, 2023 9:11 PM UTC
Solved

sql server install

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?

 

avillanueva
23-Emerald II
Jul 28, 2023 11:34 AM UTC

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 II
Jul 28, 2023 11:34 AM UTC

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

 

 

Translate
TomU
23-Emerald IV
Aug 23, 2023 10:52 PM UTC

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.)

Translate