1. Home
  2. Support
Article - CS197971

Windchill Rehosting Utility fails with error "java.sql.SQLException: No suitable driver found" for Microsoft SQL Server

Modified: 11-Oct-2022   


Applies To

  • Windchill PDMLink 10.2 to 12.0

Description

  • Windchill Rehosting Utility 2.0 fails with "Failed to validate db connection" for Microsoft SQL Server
  • Error in rehost.log
BUILD FAILED
...\conf\rehost.xml:63: com.ptc.wc.rehost.exception.RehostException: Failed to validate db connection 
Nested exception: java.sql.SQLException: No suitable driver found for jdbc:ptc:sqlserver://<server_name>:<port>; DatabaseName=
    at java.sql.DriverManager.getConnection(DriverManager.java:602)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at com.ptc.wc.rehost.validate.DBConnectionValidator.validateSqlServer(DBConnectionValidator.java:382)
    at com.ptc.wc.rehost.validate.DBConnectionValidator.validate(DBConnectionValidator.java:228)
    at com.ptc.wc.rehost.validate.Validator.execute(Validator.java:35)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

 
  • Rehost Utility fails with error as below in Windchill 12.0.2.x
Nested exception is: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://<Hostname>\\<InstanceName>:<Port>;DatabaseName=<DatabaseName>

 
This is a printer-friendly version of Article 197971 and may be out of date. For the latest version click CS197971