Eric, Is SQL 2005 supported for 6.03? I didn't think it was.
However, I just went through several upgrades with a customer from 5.1.2 to 6.03 on several boxes, but this was under SQL 2000. But, I did do the same steps listed below when I took them from 6.0.3 to 7.0.1 with SQL 2005. I'm not sure of the order that everything was installed in your environment, but the procedure listed below has worked successfully for me, time and time again. Based on not knowing the steps that you have taken to get to this point, this would be my recommendation to follow if the ARSystem DB will even run on SQL 2005. 1) Start with SQL 2000 on the Dev Box. 2) Restore a good 5.1.2 2000 backup to it - Run the scripts "tfserver" etc. to remove server references, the command to change ownership of all forms / views to dbo, and then change the dbowner to ARAdmin. 3) Run the 6.0.3 (NO PATCH) Server install against the SQL 2000 DB. 4) Validate successful implementation by logging into the User Tool. 5) Backup ARSystem DB. 6) Uninstall SQL 2000 7) Install SQL 2005 8) Change dbowner back to ARAdmin - You might have to add that login first in the SQL 2005 Manager (I did). 9) Make sure you reboot your App Server before continuing - (There is a problem with the installer that I have been able to repeat. If you keep running the installers, something gets jacked up with the Portmap.exe. It is almost as though too many registry entries get created (not uninstalled / re-installed). If I reboot after running the installer twice, I will get an Explorer message upon reboot about the Portmap.exe dying. This will cause the Server to go out to lunch because it can't find the correct port mapper entry to use. Just FYI! - I have been able to reproduce this problem numerous times). 10) Run the 6.0.3 Patch 21 Server Install against the SQL 2005 DB 11) Validate successful implementation by logging into the User Tool. Thanks, G. Rogers ----- Original Message ----- From: Dunn, Eric Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, April 03, 2007 11:52 AM Subject: Re: Upgrade Failure - 5.01.02 to 6.03 ** Yes, the ARAdmin is still the database owner. Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265 ------------------------------------------------------------------------------ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Tuesday, April 03, 2007 12:24 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrade Failure - 5.01.02 to 6.03 ** Does the ARAdmin account still own the ARSystem database? ------------------------------------------------------------------------------ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric Sent: Tuesday, April 03, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Upgrade Failure - 5.01.02 to 6.03 I have just completed a dry run on my development/test server of the server upgrade 5.01.02 to 6.03. I did not receive any error messages during the upgrade and the server was rebooted after the upgrade. I am running Windows 2003 server with SQL 2005. I am not able to connect to the server via the admin tool or the client tool. ARERR [90] Cannot establish a network connection to the AR System server What did I forget? Tue Apr 03 09:47:28 2007 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) Tue Apr 03 09:47:28 2007 Cannot open database "ARSystem" requested by the login. The login failed. (SQL Server 4060) Are the errors in the error log. Eric W. Dunn Programmer Analyst III - Remedy/Collaboration McLeod USA, Inc. - Network Engineering 8665 New Trails Dr. The Woodlands, TX 77381 (281)465-1265 (281)465-1951 fax NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
