From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marquez Rankin
Sent: Thursday, November 09, 2006 10:32 AM
To: arslist@ARSLIST.ORG
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.
-SMR