So this line from the kms_config.xml: jdbc:microsoft:sqlserver://<SQL_server_name>:1433 Determines what sql server it connects to? Because of course the config guide just says that the URL should be " jdbc:microsoft:sqlserver://localhost:1433
If that controls the database it installs to, that would be a good note for BMC to include in the config guide (hint, hint David Easter-you might want to pass that along). Tim -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Thursday, May 08, 2008 1:54 PM To: [email protected] Subject: Re: Installing Remedy Knowledge Management Ron, I have a similar configuration. We have mid-tier and AR on the same server (quad-cpu with 8gb of RAM) and I run RKM on its own system. Both RKM and AR connect to a SQL cluster for their databases. With the right JDBC version remote database isn't an issue. In 7.2 you actually go through a web-based setup tool that helps you configre your connection string. Otherwise, the config file looks like this: <database driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" initial="0" max-active="75" max-idle="25" min-idle="0" password="<encrypted>" schema_name="RKM" type="sqlserver" url="jdbc:microsoft:sqlserver://<SQL_server_name>:1433" user="RKMAdmin"/> Cheers! Eli -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron Sent: Thursday, May 08, 2008 10:09 AM To: [email protected] Subject: Installing Remedy Knowledge Management HI all, I want to install the Remedy Knowledge Management Server 7.2 to have our Service Desk try it out, but I am a little confused with which one of my servers I need to install it on. Here is my Environment I have 3 servers: Application Server running AR Server 6.3 (Win 2k3) Database Server running SQL 2000 (Win 2k3) MidTier Server running MidTier 6.3 (Win 2K, Servlet Exec and IIS) Both Production and Development environments are the same configuration, but Dev is VMWare. I have all of the components with the exception of the SQL jdbc it talks about, but I can get that. Anyone set this up in this kind of environment? Let me know. Thanks, Ron Smith Remedy/Web Developer Providence Health & Services OR [EMAIL PROTECTED] 503-216-7866 DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
