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"
