We also are running SQL2005 in 2000 compat mode for our ARSystem DB. No problems what-so-ever (at this point :-) )
When you installed SQL 2005, it probably defaulted to a named instance... Did you try to specify SERVERNAME\INSTANCENAME?? I've installed clean installations to 2005 without any issues... HTH Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Thursday, September 06, 2007 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 5.1.2 using SQL 2005 I have ARS 6.01 and CSS 5.0 and was able to upgrade SQL from 2000 to 2005, but the 2005 is run in 2000 mode. Now I am trying to fresh install ARS 6.01 with a DB already with SQL 2005 for Disaster Recovery and it will not even find the SQL Server. I am going to have to uninstall SQL 2005 and replace it with 2000 then upgrade after the Apps are installed. Haven't finished this second part yet though. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Worley Mark A Ctr 2 SOS/SYOS Sent: Thursday, September 06, 2007 12:53 PM To: arslist@ARSLIST.ORG Subject: ARS 5.1.2 using SQL 2005 The powers that be are going to let me upgrade my database server to a clustered SQL 2005 environment. Currently, I have a single SQL 2000 server as a backend for my ARS 5.1.2 server. Has anyone tried to run 5.1.2 with a similar backend (success stories or failures appreciated)? I know it isn't in the compatibility matrix, but I also know there are some of you out there who try things like this (as I will need to). If this isn't possible, what are the bit "gottchas" for going from 5.1.2 to a 7.x version? I know about the licensing changes, but other than that? All of our applications are custom, so the headache of upgrading the Remedy apps won't be needed... Thanks Mark //SIGNED// MARK A. WORLEY, Contractor, 2 SOS/SYOS Remedy ARS Support, SAIC Commercial: (402) 294-8226 DSN: 271-8226 mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"