If I say in an appropriate way, "One ARServer has to point with two DB mirrored servers with a Unique DB name".
For Unique DB Name I have configured already the DB Aliasing name in the Database configuration . Thanks & Regards, Rambabu Rudra System Administrator -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell Sent: Monday, July 05, 2010 6:46 PM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored Sorry Ram just re-read your original question and incorrectly thought you had restored a database. Are you attempting to point your arserver to two completely seperate databases without a load balancer? > Thanks for the reply Matt, > > Can you tell me how to do that? > > Thanks & Regards, > Rambabu Rudra > System Administrator > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell > Sent: Monday, July 05, 2010 6:26 PM > To: arslist@ARSLIST.ORG > Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored > > Have you reset the database owner? > > sp_dbowner 'aradmin' > > Matt > >> Hi All, >> >> >> >> I have mirrored my ARSystem Database with Server 'A' (Principle & >> Primary >> DB >> server) and Server 'B' (Mirrored & synchronized server). Both server 'A' >> and >> Server 'B' has configured to DB Alias name which is pointing in the >> ar.cfg >> file to talk with Remedy APP server. >> >> >> >> Now the error is when I restart my ARServer service, it is unable to >> start >> >> >> >> I am not sure how can I point both the Server 'A' and Server 'B' >> Database >> mirrored servers in the ar.cfg file. >> >> >> >> My Server details:- >> >> Windows 2003 enterprise with sp2 loaded with Remedy application >> >> SQL server 2005 enterprise with sp2 configured with ARSystem DB (Server >> 'A' >> and Server 'B' with ARSystem Database mirrored). >> >> >> >> The below is the available arerror.log file comments:- >> >> >> >> Mon Jul 05 16:03:59 2010 390600 : Failure during SQL operation to the >> database (ARERR 552) >> >> Mon Jul 05 16:03:59 2010 Cannot open database "ARSystem" requested >> by >> the login. The login failed. (SQL Server 4060) >> >> Mon Jul 05 16:04:03 2010 BRIE : Cannot establish a network connection >> to >> the AR System server (Remedytest (0) : RPC: Program not registered) >> ARERR >> - >> 90 >> >> Mon Jul 05 16:04:03 2010 BRIE : AR System Application server terminated >> -- >> fatal error encountered (ARAPPNOTE 4501) >> >> Mon Jul 05 16:04:14 2010 390600 : Failure during SQL operation to the >> database (ARERR 552) >> >> Mon Jul 05 16:04:14 2010 Cannot open database "ARSystem" requested >> by >> the login. The login failed. (SQL Server 4060) >> >> >> >> Please help me in this regard and let me know if you need any more >> information about the issue. >> >> >> >> Thanks & Regards, >> >> Rambabu Rudra >> >> System Administrator - Windows, Remedy >> >> >> >> GSS America InfoTech Ltd., (A SEI-CMMI Level 3 company) >> >> India Phone - 91 40 44556600 (Ext: 351) >> >> VOIP Phone - 1 847 879 4995 (Ext: 351) >> >> Mobile (C) +91 90520 42826 >> Email: * <mailto:rambabu.ru...@gssamerica.com> >> rambabu.ru...@gssamerica.com >> >> Web: <http://www.gssamerica.com/> http://www.gssamerica.com >> >> >> > ____________________________________________________________________________ > ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"