Hi Ben The default password is ar#admin
If you have previously changed the password from the default there will be a line in your ar.conf/ar.cfg file that shows the encrypted password (Db-password: xxxxx). Remove this line and reset the SQL account password to the default value. 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 2:03 PM To: [email protected] Subject: Re: ARServer fails to connect to new database server What if we can't remember the password that Remedy expects it to be? Is there anywhere we can look to see which password Remedy is attempting to use to login as this SQL account? 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 7:31 AM To: [email protected] Subject: Re: ARServer fails to connect to new database server You can just open Enterprise Manager and set the password for the account in there to what Remedy expects it to be. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Watson, Benjamin A. Sent: Monday, October 01, 2007 5:02 PM To: [email protected] Subject: Re: ARServer fails to connect to new database server Yes, the db owner is the appropriate account (the same name annotated in the logs where AR Server states that it cannot connect to the database as this individual). I'm curious as to whether or not the problem is the result of connecting to a new SQL 2005 server whereas our old method was connecting to a 2005 server that was upgraded from 2000. Further, because passwords are masked all over the place, I cannot be certain that the password for this database owner is the same as it was previously. We use the same password for pretty much everything in our development environment. Is there anywhere (either config files or Windows Registry) where I can check: - The name of the account ARS is attempting to use to connect to SQL - The password being used for said account - The SQL client/drivers being used to connect - etc. I've checked various *.cfg files in \CONF\ to no avail. Thanks, Ben ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
