I'm now part of the way there .... I've installed the SQL 2K clients onto the relevant machine, and its got a step or two further. However, we only have three SQL servers currently available - a SQL2K box for running our live ARS 5.1.2. 2x SQL2K5 boxes for running our live/dev ARS 7 install. The idea was to install ARS 5.1.2 onto a vmware session on our ARS 7 dev box, and connect it to the SQL2K5 server. I had setup a relevant (blank) database on SQL2K5, set the compatibility level, but ARS 5.1.2 displays a "Error Invlaid object name 'sysxlogins'". So what I'll have to do is install the 5.1.2 dev environment onto the 5.1.2 live database, take a backup. Restore that to the SQL2K5 dev system, and re-install, or something along those lines?
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 11 September 2007 18:03 To: [email protected] Subject: Re: 5.1.2 install problems ** Have you tried installing 5.1.2 on SQL 2K server, and then later upgrade that to MS-SQL 2K5 and drop the compatibility level to 2K?? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Barber, Dave Sent: Tuesday, September 11, 2007 5:03 AM To: [email protected] Subject: Re: 5.1.2 install problems ** Frustration .... I've updated Win2k3 to SP2, so I could install the SQL2k5 client components. So the SQL Manager is up and running fine, it connects to either our SQL2005 or SQL2k servers. But upon attempting to install the 5.1.2 AR server, I still get the "Cannot load database connection DLL." ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 10 September 2007 17:43 To: [email protected] Subject: Re: 5.1.2 install problems ** If you have the MS-SQL 2K5 server disk, just install the client component. It will not create any folder or anything but install a dll file that the ARS installation will use to connect to SQL 2K5 servers on your network. So when you give the installation the necessary information to connect to the SQL server, it will be channeled through this client. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Barber, Dave Sent: Monday, September 10, 2007 11:44 AM To: [email protected] Subject: Re: 5.1.2 install problems ** Its just the raw Win2k3 install at the moment, no SQL clients at all. Could be right, ta for that! ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 10 September 2007 16:45 To: [email protected] Subject: Re: 5.1.2 install problems ** Have you installed the MS-SQL client?? It looks like maybe you are missing the MS-SQL 25 client. The SQL client for 2K5 is just a dll file that gets installed and registered (I remember pulling some of my hair over this). You will not see anything in your Start Programs folder after the installation of the MS-SQL 2K5 client.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Barber, Dave Sent: Monday, September 10, 2007 11:25 AM To: [email protected] Subject: Re: 5.1.2 install problems ** Getting to the point of selecting the database type (SQL Server, oracle, etc.), click on that and get "Cannot load database connection DLL". All the SQL servers are on other boxes, so its not a local SQL 2K5 thats halting progress. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 10 September 2007 16:14 To: [email protected] Subject: Re: 5.1.2 install problems ** ARS 5.1.2 should have no problems with SQL 2K5. What is the error you get on trying to connect? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Barber, Dave Sent: Monday, September 10, 2007 11:05 AM To: [email protected] Subject: Re: 5.1.2 install problems ** We've got a few SQL databases (512 running on SQL 2k, 7 running on SQL 2k5), so I could be wanting to install it onto a SQL 2000 database, but its not even getting to that point. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: 10 September 2007 16:05 To: [email protected] Subject: Re: 5.1.2 install problems ** It should be the other way round. Install your system on 2000, upgrade that to 2005 after shutting down the Remedy services, and then change the compatibility level of the SQL database to 2000. That should work. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Barber, Dave Sent: Monday, September 10, 2007 10:53 AM To: [email protected] Subject: 5.1.2 install problems ** All, I'm attempting to install 5.1.2 onto a Win2k3 VMWare session as our development system. Ideally it should be connecting up to a SQL 2005 server. After reading through the archives, I've set the sp_dbcmptlevel for SQL 2000 (as per our 5.1.2 live system). However, it doesn't even get to the point of asking the server to install to - I get the "Cannot load database connection DLL" error pop up regardless of what I do. Any suggestions? Ta Dave __20060125_______________________This posting was submitted with HTML in it___ Please consider the environment before printing this e-mail or its attachments. -------------------------------------------------------- This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [EMAIL PROTECTED] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd. unless otherwise expressly stated. NTT Europe Limited is a company registered in England and Wales with company number 2307625. Registered Address: NTT Europe Ltd. 3rd Floor, Devon house, 58-60 St. Katharine's Way, London, E1W 1LB, UK. Telephone +44-20-7977-1000. Facsimile +44-20-7977-1001. Website Link: http://www.ntteurope.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
