Skip to main content
RW_1068286012-Amethyst
12-Amethyst
July 27, 2023
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
avillanuevaAnswer
23-Emerald II
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

 

 

View in thread

2 replies

avillanueva
avillanueva23-Emerald IIAnswer
23-Emerald II
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

 

 

Translate
    TomU23-Emerald IV
    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.)

    Translate
    Terms & ConditionsAccessibility statement