Skip to main content
BrianToussaint19-Tanzanite
19-Tanzanite
November 5, 2019
Solved

Windchill 11.2 and SQL Server Issue

I'm trying to install Windchill 11.2 on my Windows Server 2019 with SQL Server 2017 (yes it is in the matrices), but am having issues.  I can get everything to install and connect to Windchill but I cannot login to SQL Server as the database user.  The user that I create during Windchill SQL setup is not listed in the local users like it was in 11.0.  Has anyone else had issue?  Has anyone had a successful installation and be able to connect to the database with the database user?

 

Thank you,

Brian

mmeadows-3Answer
16-Pearl
November 5, 2019

You can connect to partially contained databases.  Use the DB user credentials used during installation.  Then expand options >> and set Connect to database: to the database name.

View in thread

7 replies

mmeadows-316-PearlAnswer
16-Pearl
November 5, 2019

You can connect to partially contained databases.  Use the DB user credentials used during installation.  Then expand options >> and set Connect to database: to the database name.

Translate
    BrianToussaint19-TanzaniteAuthor
    19-Tanzanite
    November 5, 2019

    So what does this do when installing SQL Server?  It is part of the instructions...

     

    GO

    sp_configure ‘contained database authentication’, 1;

    GO

    RECONFIGURE

    GO

    Translate
    BrianToussaint19-TanzaniteAuthor
    19-Tanzanite
    December 3, 2019

    @mmeadows-3 - I've now run through the upgrade process to 11.2 many times and have not seen the SQL tempDB grow at any noticeable rate.  I do remember it growing quite large when I went from 10.2 to 11.0.

    Translate
    Terms & ConditionsAccessibility statement