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

Windchill 11.2 and SQL Server Issue

  • November 5, 2019
  • 1 reply
  • 3995 views

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

Best answer by mmeadows-3

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.

1 reply

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

    B
    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

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

    It enables the SQL Server installation to create/use partially contained databases.  This must be set before the PSI can create the Windchill database.

     

    Note: tempDB is heavily used with partially contained databases.  In previous releases we could install the tempDB in the default location (C drive) and ignore it.  Now it will grow and can potentially fill the C drive.  That is why we highly recommend moving the tempDB to a very fast, dedicated partition.  For small to medium installations, it usually doesn't grow over 50GB.  However, during upgrades I've seen it grow to over 120GB.

    Terms & ConditionsCookie settingsAccessibility statement