When we started using Adagio, we were still using ACCPAC Plus which was on a Novell server, and we installed Adagio on each workstation separately, which I have been gathered now is wrong.

We are now moving to a Windows Small Business Server 2003, we're not using ACCPAC Plus anymore. Can anyone advise me on how to properly install Adagio on our new server and fix the workstation installations. We have G/L, A/P and lanpak. Workstations are all running XP Pro now.

Some specific questions -
Do I install from a workstation to the server or install directly on the server?
Do I need to turn off the opportunistic locking on the server?
I believe once installed on the server I just run a workstation install from there(?) but on computers where I already have Adagio set up do I uninstall first?
Where is it best to have the data folder? Do I copy our data to the server before installing Adagio? Do I only have to copy the ASP/DATA folder?

Before answering your questions, I would like to recommend that you find an Adagio consultant in your area. These are the kind of questions that assume a pretty high level of knowledge about Adagio. A good consultant would be able to help not only with these installation issues, but with other similar issues that you didn't ask about but will probably experience.

quote:

---

Originally posted by bd:
Some specific questions -
Do I install from a workstation to the server or install directly on the server?

---

From a workstation

quote:

---

Originally posted by bd:
Do I need to turn off the opportunistic locking on the server?

---

I think the answer is you don't have to unless you are going to use the server as a workstation, but what harm can it do?

quote:

---

Originally posted by bd:
I believe once installed on the server I just run a workstation install from there(?) but on computers where I already have Adagio set up do I uninstall first?

---

You run a workstation install not from the server but from each workstation. There is no need to formally uninstall Adagio from the workstation - simply rename the \SOFTRAK folder to something \SOFTRAK_OLD, and then a month or a year later (after everything is working OK) delete the \SOFTRAK_OLD folder.

quote:

---

Originally posted by bd:
Where is it best to have the data folder? Do I copy our data to the server before installing Adagio? Do I only have to copy the ASP/DATA folder?

---

The data folder must be on the server. It doesn't matter when you copy the data. I wouldn't copy the folder, but rather the files within the folder - all the files that share the same extension.

Hello Steve Schwartz,

Oportunistic locking must be turned off on both the server and the workstation. CHKSYS and each Adagio module checks the settings in both locations.

Everything else was OK though - thanks.

Thanks, I appreciate your help. I expected someone to tell me to contact a consultant, but there is only 1 in our area I know of and we are a struggling charity.

However I am lucky that I am trying this out on a server that others are not yet using, so I can take some time and make some mistakes. I've installed ACCPAC Plus on a Novell Server before.

And actually with the advice you have given me I have installed Adagio on the server from 1 workstation. When I ran chksys on the server it detected opportunistic locking and turned it off.

When I run chksys from the workstation I get 0 errors and 0 warnings. When I run it from the server I get 4 errors because it can't find the report table files. Is this to be expected or is it a problem?

Also when I login as a different user and try to run Adagio it wants to do an install of some sort and says the user doesn't have administrative rights locally. Only the user does have administrator rights on the Windows XP Pro workstation, but does not on the Windows 2003 server. The user is set up to have full rights in the directory where Adagio is installed and the data is stored. Do all the users need administrator rights on the server, or is there a trick like I used with ACCPAC Plus on the Novell server where I mapped a root drive? Or is there a different problem here.

I'd appreciate any help here.

Hello bd,

All the workstations should "see" the data as residing on the same logical drive. You set these using Tools | Map Network Drive in Windows. Then the report tables drive will be in the same "place" for each user. Adagio users must be "Power Users" and have sufficient rights to update the registry.

Make sense?

Since Andrew's answer was unclear to me, just in case it was unclear to you too...

Users do not have to have administrative rights to the server. Only to their own workstation. The Adagio folder is on the server and is irrelevant for this issue (although obviously they have to have rights to it as well)

If you are not going to be using the server as a workstation, then don't worry about the report table errors when running chksys from the server.

Thank you both again - it does make sense and just in case, I added the same mapping to the server and chksys reports 0 errors and 0 warnings.

I still have this other user, who is a "Power User" on the server and looks like an "Administrator" locally, same as my login. However the Adagio workstation setup reports insufficient rights locally to install. I am checking further into setting up users in this "domain" environment Windows 2003 Server uses.

bd:

I have seen some cases, depending on Windows Security settings, Microsoft's update patches, and perhaps the phase of the moon where you have to use regedt32 to grant the power users the rights to modify registry settings on their local PC.