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

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

    Terms & ConditionsCookie settingsAccessibility statement