So...I spent the weekend wiping this server and reinstalling: Java 1.6 P18 MS SQL 2005 JDBC drivers 1.2 Mid-tier 7.1 P8 including Tomcat RKM 7.2
Mid-tier is working and fully able to communicate with the DB. RKM installed with no issues. I am unable to complete the Configuration wizard. I get to the screen where it asks for the info to create the DB objects and I get the error in the log shown below...Failed to create database objects. No suitable driver. I have the JDBC on the same server as the RKM install. I have read and followed ALL of the KB articles that apply or may apply to this. I added a classpath to the environment varibales...is that correct?? Should it be in a Tomcat config somewhere?? Is the 1.2 version the correct one to use?? I am sure there are many installations of this out there. I would appreciate any help. Thanks, Bruce Sisk >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[email protected]]on Behalf Of bruce sisk >Sent: Thursday, January 21, 2010 10:16 PM >To: [email protected] >Subject: RKM No Suitable Driver > > >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:[email protected] ARSlist: "Where the Answers Are" ________________________________________ PeoplePC Online A better way to Internet http://www.peoplepc.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
