Do not forget to copy the DB-Password configuration line. If it works let us know. Might save some of us a few miles of work someday if we know it works..
Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Watson, Benjamin A. Sent: Tuesday, October 02, 2007 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server When we initially created our AR Servers and associated databases, we already had the DB logins created. Therefore, when running the AR System installer, we told it to use a specific SQL login rather than the default. Having done that and never changing the password for these logins in the past, I can assume that's why I don't see the Db-password: line in my ar.cfg file. So it is probably forging ahead using that DB login and whatever password was used at initial installation. Therefore the ar.cfg "hack" won't work. I kind of like Joe's idea. 1. I'll power down the current "new" DB server, then power up the "old" one. 2. Start up Remedy (I know this works as I tested it this morning). 3. Change the password in Remedy (and RECORD it!). 4. Stop Remedy 5. Power down the "old" DB server and power up the "new" one. 6. Change the corresponding SQL login's password in SQL 7. Start Remedy It feels like a dirty hack, but sometimes that is all we have. As a last resort, I think I can copy the entire Database Virtual Machine from one box to the other. But the thought of FTP'ing 170GB over our crappy network is painful. Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Tuesday, October 02, 2007 11:59 AM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server If the line is in the config file then the connection is probably using AR#ADMIN#. Try logging into the database with that id and password through another process. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Watson, Benjamin A. Sent: Tuesday, October 02, 2007 12:39 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server I fail to see a line starting with Db-password: anywhere in my ar.cfg file. I'm currently reinstalling the SQL 2005 tools on the AR System server to test connectivity via that vehicle. Further, I think I've written some java SQL 2005 jdbc connectivity apps that I might try as well. Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Tuesday, October 02, 2007 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server If the password was changed you would see something like Db-password: xse34%43 This is the line that defines the password to connect to the database. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Watson, Benjamin A. Sent: Tuesday, October 02, 2007 12:24 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server Just to be sure, in ar.cfg, is the password being used to access SQL entitled: Remedy-App-Service-Password In terms of passwords in the config file, I see only this and two others: DSO and MidTier. Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Tuesday, October 02, 2007 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server Benjamin You can probably still use the macBase user as dbo, just reset its password to ar#admin# and remove the password line from the ar.cfg file. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Watson, Benjamin A. Sent: Tuesday, October 02, 2007 5:03 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server Yes, the SQL logs show: "Login failed for user 'mscBase'. [CLIENT: <IP address of AR Server>] where mscBase is the SQL login being used for this AR Server instance. This is where I came to question the password. I can reset the password for the mscBase SQL login all day long. But I don't know what password Remedy is trying to use for this SQL Login. It was specified during the initial AR Server installation many moons ago, and I'm not 100% certain that when I created the SQL login, I specified the correct password. SQL logs don't tell me why the login failed, just that it did. Perhaps I'll look into a previous post about deleting a line in ar.conf to force Remedy to use the old ARAdmin account and create said SQL login on the server. Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, October 02, 2007 10:39 AM To: arslist@ARSLIST.ORG Subject: Re: ARServer fails to connect to new database server Have you tried attempting to start the ARS Server service and then examining the SQL logs in Enterprise Manager to see if the logon attempt succeeded or was even attempted? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"