In that case the ARS Server should be able to connect to the database server.
Do you see anything in the SQL Server logs at the time you start up the ARS Server? Maybe a bad DB password or connection parameters specified in the ar.conf file? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Ram Rudra Sent: Tuesday, July 06, 2010 4:30 PM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored Using my SQL Management Studio I can able to access my database from the ARServer. Port is 1433. 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 11:35 PM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored Telnet is not a DB client.. Use the SQL Server client such as the query analyzer. I know that 2005 onwards installs only the dll's, but if you install the SQL Management Studio you will get the thick SQL Server client installed along with it (and not just the libraries). Use this client to connect to the DB and see if that works. I understand that you can telnet to the DB server, that only establishes the network connectivity. You still cannot say with 100% certainty that the DB client can successfully connect to the DB unless you check its connectivity. Just out of curiosity, what port are you using when checking with Telnet? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Ram Rudra Sent: Tuesday, July 06, 2010 5:13 AM To: arslist@ARSLIST.ORG Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored 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"