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 <[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/4BE5D23QH6Pcohtw78djye89wTG0NZAYxqNjwKxxynRZGuv68LxTRfz9pKcItbSMiKh7Tlu+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 > [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 > >
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
