What you could also try doing is if you have another test system, change the password on that system, and then copy the DB-Password: line from that configuration to your configuration and ask your DBA to set the password of the DB user to the same password that is on your test system..
Cheers Joe D'Souza -----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: [email protected] 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: [email protected] 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: [email protected] 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: [email protected] 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: [email protected] 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: [email protected] 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? No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.13.39/1044 - Release Date: 10/2/2007 11:10 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
