To set the database driver for MS-SQL 2005 Open the kms_config.xml file . The kms_config.xml file is located in the following deffault folder: \BMC Remedy Knowledge Management\data\kms_conf Locate the <database driver> element. It is similar to the following statement: <database driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" initial="0" max-active="75" max-idle="25" min-idle="0" password="password" url="jdbc:microsoft:sqlserver://<server>:1433" user="RKM_Admin"/> Make the following changes: Change the driver attribute to the following value: database driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" Change the url attribute to the following value: url="jdbc:sqlserver://<server>:1433" The <database driver> element should be similar to the following statement: <database driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" initial="0" max-active="75" max-idle="25" min-idle="0" password="password" url="jdbc:sqlserver://<server>:1433" user="RKM_Admin"/> Save the kms_config.xml file. Restart web services. For Apache Tomcat, stop and start the Apache Tomcat service. Thanks & Regards, Mahendra Mahalkar
On Fri, Jan 22, 2010 at 12:04 PM, Joe D'Souza <jdso...@shyle.net> wrote: > Bruce, > > Have you installed the 2005 SQL client? It's not a thick client as it used > to be in the past but just a few dll files etc that get installed. > > If so, can you resolve / ping the SQL server by the remote server name you > have provided? Maybe it requires a FQDN in case you are supplying just the > machine name. Also the default port that you are using 1433, is that what > the SQL server is configured to use or have the defaults been changed? > > I know you said you aren't getting a login failure so if any of the above > didn't check correctly, that is what you would be getting. But I just > thought you could check that anyways just in case the error reporting was > faulty. > > Does the system and application event log throw anything more that may be > of > interest to you? > > Joe > > -----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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"