I had the same issue - Terminal Server, SIMS.net and FMS
I've just moved our SIMS server over to a virtualised one, but in addition to this we have moved our admin machines over to thin clients (Ncomputing on Multipoint 2011). SIMS works fine, but FMS reports that Crystal reports are not installed. When in FMS, reports can be run, but I'm expecting a bararge of calls on Monday morning that I've broken FMS. All the DLLs and Windows folder have been replicated to the users profiles and checked the crystal reports registry settings to ensure that they are pointing at relevant places. Any ideas?
dhicks (24th June 2011)
I saw that, just wondered if anyone had come up with a fix in the last 3 years. It works, but its annoying me!
SIMS under terminal services
One thing I notice from that thread was the line "If you also will be using FMS ensure that Crystal Reports is installed via the simsapplications.exe file, else printing will not work."
Currently, our client machines run SIMS locally. SIMS, FMS and SchoolComms are installed via a batch file:
I've ran that same install script on our Server 2008 R2 machine, in "install" mode from the command line, and all install procedures seemed to complete. Time to start testing...Code:@echo off echo Installing SIMS... net use s: \\kssims\SimsShare /PERSISTENT:no \\ks-nas1\Software\SIMS\install.exe copy "\\ks-nas1\Software\Sims\connect.ini" "C:\Program Files\SIMS\SIMS .net" echo ...with FMS... S:\SIMS\Setups\FMSApplicationSetup.exe mkdir "C:\Program Files\SIMS\Finance" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "C:\Program Files\SIMS\Finance" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "c:\WINDOWS\system32" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "c:\Program Files\SIMS\SIMS .net" echo Sims Directory=C:\Program Files\SIMS\FMSSQL>>C:\WINDOWS\sims.ini copy "\\ks-nas1\Software\FMS\PDOXUSRS.NET" "C:\" echo ...and SchoolComms... \\ks-nas1\Software\dotNet\4.0\dotNetFx40_Full_x86_x64.exe /passive /norestart msiexec /i \\ks-nas1\Software\SchoolComms\7.2\Schoolcomms72H.msi /qb- s: cd S:\SIMS\Setups call simsperm.bat CAMELOT\KS-SEC-ADMIN call simsperm.bat CAMELOT\KS-SEC-SIMS call simsperm.bat CAMELOT\KS-SEC-SMT call simsperm.bat CAMELOT\KS-SEC-TEACH SubInAcl /FILE "C:\PDOXUSRS.NET" /GRANT=CAMELOT\KS-SEC-ADMIN=F c:
Edit: This thread might also come in handy:
SIMS via TS RemoteApp in server 2008R2
Last edited by dhicks; 24th June 2011 at 04:25 PM.
do you mean maintenance mode in MPS. FMS runs and prints fine from what I can tell, just an annoying box at start up saying its not installed, whichi i know the bursar will pick up on first thing monday morning and think there is a problem..
Run CMD as administrator
change user /install [enter]s:\
Above should sort it. Below is to make sure it runs as the user without any extra permissions (I just need to add to it)
Change the FMS shortcut to "run in" c:\programdata\all users\app data\capita
Change BDE PDOXUSR.NET to c:\programdata\all users\app data\capita
fantastic, that seems to of worked, can you explain the second bit of ur post?
Sorry, was rushing that day... not sure about the paths, I'm still suck on XP here, so have to find a W7 to check it's correct.
FMS will write files to the "Run In" path, default is the program files\sims\fmssql folder. Change it to somewhere the users does have read\write access then they only need read to the folder - assuming your doing the upgrades\using SOLUS3Change the FMS shortcut to "run in" c:\programdata\all users\app data\capita
By default BDE config file is located in the root of C:, you need to put it in a folder that all users have read\write too... and is local.Change BDE PDOXUSR.NET to c:\programdata\all users\app data\capita
Tip: You may need to switch to Control Panel to Classic View
- Open BDE Administrator from Control Panel
- Select Configuration tab
- Expand Configuration > Drivers > Native
- Select PARADOX
- Change the NET DIR to [NEW PATH]
- Click Object > Apply
- Click OK to confirm saving changes.
- And OK to confirm message.
- Close BDE Administrator
dhicks (4th July 2011)
Create User DSN has failed
However, trying the solutions in that thread has not, so far, given a succesful result. I've tried installing the SQL Native Client driver and manually creating a User DSN called "SIMS_FMS_DATABASE", but I still get the same error message. Is there some other fix I can try, or am I missing some part of FMS' setup? In particular, I don't get how manually creating a User DSN is going to help - surely that's what FMS tries (and, currently, fails) to do when it starts? Isn't FMS trying to create SIMS_FMS_DATABASE for the current user on startup and finding it can't for some reason?
dhicks (5th July 2011)
Is this when you login? Did you set it to install mode? Do you have a default printer?
dhicks (6th July 2011)
> Did you set it to install mode?
Oh bother. I did originally, but I've just done a resinstall and forgot that step. Theorectially, Server 2008 R2 is meant to be able to spot install operations and react accordingly, I guess we'll see how well that actually works...
No, but it's a good point, I'll set one up.Do you have a default printer?
I've now got SIMS, FMS and SchoolComms reinstalled from scratch, this time making sure everything installs in "C:\Program Files (x86)" instead of half in "C:\Program Files". I've kept PDOXUSRS.NET in a separate folder, not the root of C drive, and made sure the BDE Administrator knows where it is. FMS now seems to be working - I'll just nip down and get the accountancy staff to see if they can run it.
Edit: Yes, all seems fine. Hooray!
Last edited by dhicks; 6th July 2011 at 05:06 PM.
I think they might be fixing the printer issue -
Description: If a default printer is not present FMS fails to login
[31/05/2011] Progress Update: The case is under investigation.
[21/06/2011] Progress Update: The application build has been prepared and is now under review with a senior developer.
Roll on the Autumn 11 release?
dhicks (7th July 2011)
There are currently 1 users browsing this thread. (0 members and 1 guests)