Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Joe D'Souza 
That is your arerror.log file.. Check the SQL server log file on the DB 
server.. You need to know what happens there when the ARS is trying to connect..

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:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored


Error.log file includes

Mon Jul 05 18:10:30 2010  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:30 2010 0xc005
Mon Jul 05 18:10:30 2010  390600 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Mon Jul 05 18:10:35 2010  390620 : Failure during SQL operation to the database 
(ARERR 552)
Mon Jul 05 18:10:35 2010 [DBNETLIB][ConnectionWrite (send()).]General 
network error. Check your network documentation. (SQL Server 11)
Mon Jul 05 18:10:36 2010  390635 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 
   Timestamp: Mon Jul 05 2010 18:10:37.5460 
   Thread Id: 360
   Version: 7.1.00 Build 200708221849 Aug 22 2007 19:56:34
   ServerName: remedytest 
   Database: SQL -- SQL Server
   Hardware: Intel Pentium
   OS: Windows NT 5.2
   RPC Id: 100
   RPC Call: 61 (EXEC)
   RPC Queue: 390635
   Client: User Remedy Application Service from Unidentified Client (protocol 
12) at IP address 10.0.4.39
   Form: 
   Logging On:
   Code: c005
   Operation: read
   Access Addr: 0x1758
   Stack Begin: 
  Addr: 4E25218A
  Addr: 4E252A91
  Addr: 4E255F6C
  Addr: 4E25603C
  Addr: 4E2560EC
  Addr: 0052DE22
  Addr: 0052F36F
  Addr: 0053E96D
  Addr: 00531811
  Addr: 2DF8AEE4
   Stack End 

Mon Jul 05 18:10:36 2010  390635 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 0xc005
Mon Jul 05 18:10:36 2010  390635 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Mon Jul 05 18:10:41 2010  390603 : Failure during SQL operation to the database 
(ARERR 552)

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: Wednesday, July 07, 2010 2:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

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

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Danny Kellett 
Try this

To resolve this issue, turn off this new functionality by adding the 
SynAttackProtect entry to the following registry key on the computer that is 
running Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Set the SynAttackProtect entry to a DWORD value of . To do this, follow 
these steps:

   1. Click Start, click Run, type regedit, and then click OK.
   2. Locate and then click the following registry key:
  HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
   3. On the Edit menu, point to New, and then click DWORD Value.
   4. Type SynAttackProtect, and then press ENTER.
   5. On the Edit menu, click Modify.
   6. In the Value data box, type . Click OK.
   7. Quit Registry Editor.

Kind regards
Danny

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ram Rudra
Sent: 06 July 2010 22:16
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

Error.log file includes

Mon Jul 05 18:10:30 2010  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:30 2010 0xc005
Mon Jul 05 18:10:30 2010  390600 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Mon Jul 05 18:10:35 2010  390620 : Failure during SQL operation to the database 
(ARERR 552)
Mon Jul 05 18:10:35 2010 [DBNETLIB][ConnectionWrite (send()).]General 
network error. Check your network documentation. (SQL Server 11)
Mon Jul 05 18:10:36 2010  390635 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 
   Timestamp: Mon Jul 05 2010 18:10:37.5460 
   Thread Id: 360
   Version: 7.1.00 Build 200708221849 Aug 22 2007 19:56:34
   ServerName: remedytest 
   Database: SQL -- SQL Server
   Hardware: Intel Pentium
   OS: Windows NT 5.2
   RPC Id: 100
   RPC Call: 61 (EXEC)
   RPC Queue: 390635
   Client: User Remedy Application Service from Unidentified Client (protocol 
12) at IP address 10.0.4.39
   Form: 
   Logging On:
   Code: c005
   Operation: read
   Access Addr: 0x1758
   Stack Begin: 
  Addr: 4E25218A
  Addr: 4E252A91
  Addr: 4E255F6C
  Addr: 4E25603C
  Addr: 4E2560EC
  Addr: 0052DE22
  Addr: 0052F36F
  Addr: 0053E96D
  Addr: 00531811
  Addr: 2DF8AEE4
   Stack End 

Mon Jul 05 18:10:36 2010  390635 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 0xc005
Mon Jul 05 18:10:36 2010  390635 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Mon Jul 05 18:10:41 2010  390603 : Failure during SQL operation to the database 
(ARERR 552)

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: Wednesday, July 07, 2010 2:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

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 Servic

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Ram Rudra 
Error.log file includes

Mon Jul 05 18:10:30 2010  390600 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:30 2010 0xc005
Mon Jul 05 18:10:30 2010  390600 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Mon Jul 05 18:10:35 2010  390620 : Failure during SQL operation to the database 
(ARERR 552)
Mon Jul 05 18:10:35 2010 [DBNETLIB][ConnectionWrite (send()).]General 
network error. Check your network documentation. (SQL Server 11)
Mon Jul 05 18:10:36 2010  390635 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 
   Timestamp: Mon Jul 05 2010 18:10:37.5460 
   Thread Id: 360
   Version: 7.1.00 Build 200708221849 Aug 22 2007 19:56:34
   ServerName: remedytest 
   Database: SQL -- SQL Server
   Hardware: Intel Pentium
   OS: Windows NT 5.2
   RPC Id: 100
   RPC Call: 61 (EXEC)
   RPC Queue: 390635
   Client: User Remedy Application Service from Unidentified Client (protocol 
12) at IP address 10.0.4.39
   Form: 
   Logging On:
   Code: c005
   Operation: read
   Access Addr: 0x1758
   Stack Begin: 
  Addr: 4E25218A
  Addr: 4E252A91
  Addr: 4E255F6C
  Addr: 4E25603C
  Addr: 4E2560EC
  Addr: 0052DE22
  Addr: 0052F36F
  Addr: 0053E96D
  Addr: 00531811
  Addr: 2DF8AEE4
   Stack End 

Mon Jul 05 18:10:36 2010  390635 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 0xc005
Mon Jul 05 18:10:36 2010  390635 : AR System server terminated -- fatal error 
encountered (ARNOTE 21)
Mon Jul 05 18:10:41 2010  390603 : Failure during SQL operation to the database 
(ARERR 552)

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: Wednesday, July 07, 2010 2:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

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

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Joe D'Souza 
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" 
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 yo

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Ram Rudra 
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" 
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 A

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Joe D'Souza 
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" 
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.
>>
>>

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-06 Thread Ram Rudra 
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" 
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&q

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Joe D'Souza 
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" 
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 durin

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Rudra Rambabu 
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" 
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"

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Joe D'Souza 
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"

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Ram Rudra 
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"

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Ram Rudra 
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"

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Matt Worsdell 
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"

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Ram Rudra 
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"

Re: ARSystem Service Unable to Start after ARSystem DB Mirrored

2010-07-05 Thread Matt Worsdell 
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: *  
> rambabu.ru...@gssamerica.com
>
> Web:   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"