Article - CS266407
PSI fails with "Login failed for user 'sa' " to setup SQL Server in Windchill PLM
Modified: 13-Dec-2022
Applies To
- Windchill PDMLink 10.2 to 12.1
- Microsoft SQL Server
Description
- PTC Solutions Installer (PSI) of Windchill PDM Link fails to setup the Microsoft SQL Server database with "Login failed for user 'sa'"
- Error in C:\ptc\Windchill_11.0\SQLServer\installer\logs\SCU_PtcInstall.log
- Error in C:\ptc\Windchill_12.0\SQLServer\installer\logs\SCU_PtcInstall.log
MESSAGE: Login failed for user 'sa'. ClientConnectionId:c0c9fc4c-d418-4948-9f34-52514f46338e
ERROR MESSAGE: Login failed for user 'sa'. ClientConnectionId:c0c9fc4c-d418-4948-9f34-52514f46338e
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:c0c9fc4c-d418-4948-9f34-52514f46338e
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2926)
ERROR MESSAGE: Login failed for user 'sa'. ClientConnectionId:c0c9fc4c-d418-4948-9f34-52514f46338e
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:c0c9fc4c-d418-4948-9f34-52514f46338e
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2926)
This is a printer-friendly version of Article 266407 and may be out of date. For the latest version click CS266407