No Matt, I have two database servers (SQL 2005) configured with Mirroring concept. Think Server 'A' and Server 'B' are the database server and Server 'A' is having ARSystem Database. Server 'B' is like a copy of ARSystem Database which will synchronized from Server 'A'. when I say failover from my Server 'B' , It will become active for ARSystem database. The concept is just like 2 node Active/Passive clusters. But the database is same in both the servers.
Now I would like point these two DB Servers in ar.cfg file. How? 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"
