Try the last thing is that install mid-tier with the tomcat on separate box & RKM with the tomcat on the separate box.
Cheers, Mahendra Mahalkar On Tue, Jan 26, 2010 at 7:38 AM, bruce sisk <siskbr...@peoplepc.com> wrote: > 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:arsl...@arslist.org]on Behalf Of bruce sisk > >Sent: Thursday, January 21, 2010 10:16 PM > >To: arslist@ARSLIST.ORG > >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:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>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:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
