Re: Upgrading to SQL 2005

[Jason]

**

Check to make sure the DBA's didn't change SQL to Windows only authentication. If they did, you need to change the dbo to the windows account that you use to start the remedy application service.

---

From: "Rodriguez, Rafael J x23718" <rafael.rodrig...@broadridge.com>
To: arslist@ARSLIST.ORG
Sent: Saturday, April 11, 2009 1:25:21 AM
Subject: Re: Upgrading to SQL 2005

**

FYI, the DBAs ran the upgrade this past week and now we get the following error when starting Remedy

 

Fri Apr 10 18:11:41 2009  390695 : Unable to extract minor version from Java VM version string: 10.0-b23 (ARERR 9130)
Fri Apr 10 18:11:41 2009  390600 : Failure during SQL operation to the database (ARERR 552)
Fri Apr 10 18:11:41 2009     Login failed for user 'ARAdmin'. (SQL Server 18456)
Fri Apr 10 18:11:41 2009  390600 : Failure while trying to connect to the SQL database.
Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550)
Fri Apr 10 18:11:41 2009     Login failed for user 'ARAdmin'. (SQL Server 18456)
Fri Apr 10 18:11:41 2009  390600 : Cannot initialize contact with SQL database (ARERR 551)
Fri Apr 10 18:11:41 2009     Stop server
Fri Apr 10 18:11:41 2009  390600 : AR System server terminated -- fatal error encountered (ARNOTE 21)

Any idea why?

 

Thanks

---

From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Monday, April 06, 2009 9:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Upgrading to SQL 2005

**

Rafael,

We are actually undergoing that upgrade at the moment without issue.  Remedy doesn't seem to notice a change at all...

---

From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718
Sent: Saturday, April 04, 2009 9:27 AM
To: arslist@ARSLIST.ORG
Subject: Upgrading to SQL 2005

**

Hello, just wanted to see if any has encountered any issues upgrading the backend SQL server from SQL 2000 to SQL 2005?

 

My environment is:

ARS 7.0.1 Patch 6 in a server group environment.

WIN 2003 Server

Remote SQL 2000 Clustered Servers

 

Also, does remedy need to be re-installed after the upgrade?

 

Thanks in advance!

 

Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions

2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p

 

This message and any attachments are intended only for the use of the addressee and
may contain information that is privileged and confidential. If the reader of the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.


__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
This message and any attachments are intended only for the use of the addressee and
may contain information that is privileged and confidential. If the reader of the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_