Article - CS282281
Error "Login failed for user 'sa'" while running Collation Conversion Utility in Windchill using Microsoft SQL Server
Modified: 12-Mar-2024
Applies To
- Windchill PDMLink 11.0 to 12.0
- PTC RV&S (formerly Integrity Lifecycle Manager) 10.4 to 13.2
Description
- Collation Conversion Utility fails with error :
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed for user 'sa'..
- Command sqlcmd.exe -S ServerName\InstanceName,Portnumber -U sa -P <sa password> -d Database in CS372889 can succeed.
- Installing Windchill with SQL Server Data Base via PSI fails with error
- Installing SQL Server Configuration Utility (SCU) failed with error in %UserProfile%\AppData\Local\Temp\SCU_PtcInstall.log
DEBUG 2021-03-25 09:44:04 - SQL STATE: S0001 DEBUG 2021-03-25 09:44:04 - CODE: 18456 DEBUG 2021-03-25 09:44:04 - MESSAGE: Login failed for user 'sa'。 ClientConnectionId:6b1931d0-5ed6-4cda-8f40-769c93ceaea8 DEBUG 2021-03-25 09:44:04 - ERROR MESSAGE: Login failed for user 'sa'。 ClientConnectionId:6b1931d0-5ed6-4cda-8f40-769c93ceaea8 DEBUG 2021-03-25 09:44:04 - com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'。 ClientConnectionId:6b1931d0-5ed6-4cda-8f40-769c93ceaea8
This is a printer-friendly version of Article 282281 and may be out of date. For the latest version click CS282281