On 11/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> wrote:
I'll have to defer to MSSQL experts on the list for that one. :-) I'm an
Oracle guy...
--
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
Marquez Rankin <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
11/09/2006 01:04 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with
clients)
** Thanks Tony,
I was thinking along the same lines. However, ARS 5.x isn't compatible
with SQL 2005 as far as I know. The actual database restore is backwards
compatible but will this cause an issue with the SQL Server itself?
On 11/9/06, Tony Worthington <[EMAIL PROTECTED]> wrote:
Install ARS 5x on upgrade system
Do database restore from current -> upgrade
Do sp_changedbowner
Start ARS 5.x on upgrade.
Try clients. If everything works identical to current system proceed.
Run 7.0 installer on upgrade, and choose the upgrade option
Try your v7 clients on upgrade.
hth,
tony
--
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
Marquez Rankin < [EMAIL PROTECTED] >
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
11/09/2006 10:31 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with
clients)
**
Current Production System: Windows 2000 Server SP4 / SQL 2000 / ARS
5.01.02
Upgrade Production System: Windows 2003 Server SP1 / SQL 2005 / ARS
7.01.02
Installed ARS 7.01.02 on 'Upgrade System' with defaults.
Logged onto 'Upgrade System' Demo account with both User & Admin clients.
Shutdown ARS 7.01.02 processes on 'Upradge System'
Restored SQL 2000 backup from 'Current System' with corrected paths for
'Upgrade System' database & log file.
Ran query against restored database EXEC sp_changedbowner 'ARAdmin',
'true' to restore ARAdmin as dbo.
Started ARS 7.01.02 processes on 'Upgrade System'
User and Admin client cannot access ARS on 'Upgrade System'
Ran ARS 7.01.02 install again selecting upgrade.
Recieved the following:
****->[ERROR]: AR System Server Database upgrade error. Changes to the
original database may have been commited during this process which would
result in the need to recover data from your database backup. Resolve the
problem that caused the error (Check the installation logfile and contact
Technical Support if necessary).
****->[ERROR]: Failed to complete AR Server installation.
Any ideas?
-SMR
__20060125_______________________This posting was submitted with HTML in
it___
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves
the right to retrieve and read any message created, sent and received.
Kohl's reserves the right to monitor messages to or from authorized Kohl's
Associates at any time
without any further consent.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
__20060125_______________________This posting was submitted with HTML in
it___
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time
without any further consent.
__20060125_______________________This posting was submitted with HTML in it___
