I am installing RKM 7.2 on a Windows 2003 server, MS SQL 2005 DB with Tomcat and IIS and Remedy Mid-tier 7.1 Patch 8 (although there appears to be remnants of a 7.0.x install). Mid-tier works. the .jar files are in the tomcat common lib folder.
I keep getting an error when trying to create the rkm database using the RKM Config Wizard: ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://<remote server>:1433' ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable driver I have a classpath that points to the sqljdbc.jar. It is the 1.2 version of the JDBC driver. I am not getting a login failure so I don't think that is the reason. I am stumped. I am about ready to wipe the whole server and start over, but I am not sure if that is the solution. Would hate to do all that and still get the same problem. Below is the details of the log file. Bruce Sisk 21-Jan-10 22:03:25 * ERROR: Diagnostics: Failed to create database connection: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver://xxx:1433' 21-Jan-10 22:03:25 INFO: Diagnostics: Code version: 7.2.00.1521 21-Jan-10 22:03:25 INFO: Diagnostics: Config version: 7.2.00.1521 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating SearchServer connection pool... 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer driver: jdbc.searchserver.SSDriver 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer URL: jdbc:searchserver:SearchServer_5.4 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer active: 1 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer max idle: 1 21-Jan-10 22:03:25 DEBUG: HomeFinder: SearchServer min idle: 0 21-Jan-10 22:03:25 INFO: HomeFinder: SearchServer properties file not specified, using defaults 21-Jan-10 22:03:25 INFO: AppConfig: Configuration settings successfully loaded. 21-Jan-10 22:03:25 DEBUG: HomeFinder: Creating raw database connection... 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database driver: com.microsoft.sqlserver.jdbc.SQLServerDriver 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database URL: jdbc:microsoft:sqlserver://xxx:1433 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database user: xxx 21-Jan-10 22:03:25 DEBUG: HomeFinder: Database password: ******** 21-Jan-10 22:03:25 * ERROR: kms.sql.SQLServer: Failed to create database objects: No suitable driver 21-Jan-10 22:03:31 DEBUG: AppConfig: kms.authentication.SystemConfigurationAuthenticator created. ________________________________________ PeoplePC Online A better way to Internet http://www.peoplepc.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"