Method server fails to start with FATAL [main] wt.server.manager.shutdown - ServerManager stopped.

[MK_225]

2023-06-19 11:36:08,590 FATAL [main] wt.server.manager - ServerManagerMain abort com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'wc'. ClientConnectionId:a7ebdb5b-4d75-41e5-858b-4753b6892a4c

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:283)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:129)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5067)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3731)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3675)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2488)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2142)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1993)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1164)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:760)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)

at wt.pds.StandardDataSource$1.getConnection(StandardDataSource.java:115)

at wt.pds.StandardDataSource$ConnectionRetry.execute(StandardDataSource.java:411)

at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:118)

at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:84)

at wt.manager.CacheMasterNegotiator.getNewConnection(CacheMasterNegotiator.java:875)

at wt.manager.CacheMasterNegotiator.start(CacheMasterNegotiator.java:2375)

at wt.manager.ServerManagerMain.startServerManager_internal(ServerManagerMain.java:390)

at wt.manager.ServerManagerMain.run(ServerManagerMain.java:298)

at wt.manager.ServerManagerMain.main(ServerManagerMain.java:228)

2023-06-19 11:36:08,593 FATAL [main] wt.server.manager.shutdown - ServerManager stopped.

[HelesicPetr]

Hi @MK_225 

Check the login user and password if they are correct. your database name is wc I usually do not see that database user name for wch installation.  

error in method server is clear Login failed

Also check if the database user is not orphan user - it happens after restoring database from backup.

PetrH

[MK_225]

Hey @HelesicPetr , 

Got your point , I tried resolving this login issue as per

 Article - CS117247

but still the issue remains unresolved on restarting windchill from shell.

[buenosroas]

Is this a rehosted application or a clean install? By the looks of your hostname you're running this on a laptop. Is the SQLServer installed locally? I presume that this is a test environment.

Are you able to log in to the database using the wc credentials that is propagated to db.properties?

Check out https://www.ptc.com/en/support/article/CS40620 as suggested by @HelesicPetr 

It could also be a good idea to validate your db.properties settings: https://www.ptc.com/en/support/article/CS64778 

This could also be a good source for troubleshooting: https://www.ptc.com/en/support/article/CS194412