Can't run Office 97 macros on FR2 amongst other things

[DarrenH]

Hi

I'm currently running NT4/Metaframe 1.0. I set up a test W2K/MetaFrame XPS server several months back and it worked a treat. Flushed with success, I decided to start rolling it out across the company. The original server uses the Access file method of managing the farm. I couldn't get it to use SQL2000 to manage the farm. My new disks contain FR2 and setting up a new farm on SQL2000 was a breeze - I assume updated ODBC stuff. So I have two servers in two different farms. I intend to go back and reinstall the original once the new one works.

However, my new server will not run Office 97 macros unless the user is a domain admin. They get a "could not open macro storage" message. Clearly an access rights issue, but I can't seem to pick it up using FILEMON. The original MetaFrame server is fine. To add to the confusion, the macros are stored on a Netware 4.11 volume. I installed the latest Novell Client (4.8.3) as a precaution - the original server has 4.8.1 on it.

I've seen similar posts to this on this forum, but I'm still struggling. Has anyone got an idea where Office is trying to create files. I don't want to start giving read-write access to directories unnecessarily.

On a different note, I considered adding my new server into the farm managed by the original server. I tried and failed. I thought that the server should accept connections on port 2512. When I port-scanned this machine, I found that this port is not open. If I could solve this one, I could use my original Metaframe disk to install on the new server, hopefully avoiding the Office 97 macro problem in the first place. Admittedly, I'd much rather have the farm managed by my SQL 2000 server.

TIA

 

[Highland]

A couple of documents on MS Kb......

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224338

http://support.microsoft.com/default.aspx?scid=kb;en-us;q220681

....not sure if they're what ur looking for....???

 

[DarrenH]

What I should have also mentioned is that I remapped the drives using the utility on the CD before installing Metaframe. The novell client and Office 97 were installed after Metaframe.

I've found that there is still a lot of stuff in the registry pointing at c: almost as if the installers had c: hardcoded in rather than using %systemroot% or similar.

Is there a best time to remap drives, other than never ;-)

I wouldn't bother normally, but we use zenworks with the existing Metaframe 1.0 and I'm expected to slot the new servers into the company structure.

Reinstalling from scratch is no problem, so I might do that and put Office 97 on without remapping drives.

 

[Adenne]

Try using REGMON. I had a similar problem and ended up giving permission for USERS in HKLM\software\microsoft\office and allowed 'Set Value' and 'Create Subkey'

I set it at this level to hope that it would sort out any other problems.

 

[DarrenH]

Thanks, I'll take a look. This might be useful for other things

I've managed to sort it anyway

<looks sheepish>
helps if you run the Office97 compatibility script :~/
</looks sheepish>