So she did run the following script?
USE ARSystem GO sp_changedbowner ARAdmin, True GO _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Melanie Snayer Sent: Monday, February 19, 2007 10:12 AM To: [email protected] Subject: Re: FW: Cannot connect to sql via Remedy ** Hey Graham When she confirmed about the ARAdmin user being dbo I thought she may have changed this manually but she had used the sp_changedbowner command and still no luck. She's now decided to just drop the current db and then restore. Not sure how much of a difference that's going to make but it's worth a try. Anymore ideas would come in handy though. Regards Mel On 2/19/07, Melanie Snayer <[EMAIL PROTECTED]> wrote: Hey Graham Thanks so much. I will pass this on in the hope that it helps. Regards Mel On 2/19/07, Averell, Graham < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]> wrote: Hi Mel, The following link may help http://www.opensubscriber.com/message/[EMAIL PROTECTED]/1831526.html I also have to run SP_Changedbowner 'ARAdmin' from query analyser when restoring the database to other MS SQL servers. Good Luck, Graham _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Melanie Snayer Sent: 19 February 2007 13:49 To: [email protected] Subject: Cannot connect to sql via Remedy ** Hey Listeners I'm trying to help a friend... no, really it is a friend, not me in need of the help here :) She's restored the MS SQL DB while running a routine DR process check but now cannot seem to start the ARS Service. She can confirm that ARA dmin is dbo and user on the system and that she can connect to sql fine, but not via the remedy services. The arerror.log file shows the below errors, which all indicate that there are problems with the network connection to the DB that the ARS cannot see. Any ideas? Regards Mel arerror.log extract: Sun Feb 18 16:13:51 2007 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Sun Feb 18 16:13:51 2007 Sun Feb 18 16:13:51 2007 390600 : Cannot initialize contact with SQL database (ARERR 551) Sun Feb 18 16:13:51 2007 Stop server Sun Feb 18 16:13:51 2007 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Sun Feb 18 16:28:11 2007 390600 : Failure during SQL operation to the database (ARERR 552) Sun Feb 18 16:28:11 2007 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17) Sun Feb 18 16:28:11 2007 390600 : SQL database is not available -- will retry connection (ARNOTE 590) Mon Feb 19 09:08:50 2007 390600 : Failure during SQL operation to the database (ARERR 552) Mon Feb 19 09:08:50 2007 [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. (SQL Server 11) __20060125_______________________This posting was submitted with HTML in it___ Click here <https://www.mailcontrol.com/sr/4BE5D23QH6Pcohtw78djye89wTG0NZAYxqNjwKxxynRZ Guv68LxTRfz9pKcItbSMiKh7Tlu+fFDQz5exjdqrRw==> to report this email as spam. This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd. unless otherwise expressly stated. NTT Europe Limited is a company registered in England and Wales with company number 2307625. Registered Address: NTT Europe Ltd. 3rd Floor, Devon house, 58-60 St. Katharine's Way, London, E1W 1LB, UK. Telephone +44-20-7977-1000. Facsimile +44-20-7977-1001. Website Link: http://www.ntt.eu <http://www.ntt.eu/> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
