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)" <arslist@ARSLIST.ORG> 11/09/2006 01:04 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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)" <arslist@ARSLIST.ORG> 11/09/2006 10:31 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
