I have run the telnet and port query from ARServer to DB servers. I am able to access them without any errors.
Also, Can you tell me if any otherways to perform testing from ARServer to DB servers. Thanks & Regards, Rambabu Rudra System Administrator -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Tuesday, July 06, 2010 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored If you try to connect to the DB from the SQL client on the DB server, it is obviously going to connect if the DB is up and running. What's the point in testing that? Try connecting from the SQL client on the ARS Server.. Your connectivity between the ARS Server to the DB server is in question so that is what you need to test if it works or not.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rudra Rambabu Sent: Tuesday, July 06, 2010 12:07 AM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored All the 3 Mirrored DB servers in the SQL Mirroring with an instance of 'ARSystem' and with the login ID of 'ARAdmin' are able to login and access the database successfully from all teh DB Servers. if it is something related to ARS app, how can we shot it. Thanks Ram Rudra ----- Original Message ----- From: "Joe D'Souza" <jdso...@shyle.net> To: arslist@ARSLIST.ORG Sent: Tuesday, July 6, 2010 2:41:17 AM Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored Something that I always try when I have a DB connect issue.. Try logging into the DB using the DB client from the ARS Server machine.. If that fails too then you have a bigger issue. If that does not fail, then the issue could be assumed to be ARS related. Give that a shot and see if you can connect to the DB from the ARS Server using the DB client. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Ram Rudra Sent: Monday, July 05, 2010 9:29 AM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored 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"
