+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
MIS Systems Thread, FMS & Thin Clients - Crystal Reports not installed in Technical; I've just moved our SIMS server over to a virtualised one, but in addition to this we have moved our ...
  1. #1

    Join Date
    Aug 2008
    Location
    Medway, Kent
    Posts
    196
    Thank Post
    4
    Thanked 26 Times in 23 Posts
    Rep Power
    17

    FMS & Thin Clients - Crystal Reports not installed

    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?

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,941
    Thank Post
    519
    Thanked 2,499 Times in 1,940 Posts
    Blog Entries
    24
    Rep Power
    840
    I had the same issue - Terminal Server, SIMS.net and FMS

  3. Thanks to localzuk from:

    dhicks (24th June 2011)

  4. #3

    Join Date
    Aug 2008
    Location
    Medway, Kent
    Posts
    196
    Thank Post
    4
    Thanked 26 Times in 23 Posts
    Rep Power
    17
    I saw that, just wondered if anyone had come up with a fix in the last 3 years. It works, but its annoying me!

  5. #4

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,663
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by jamesmay View Post
    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.
    I'm just doing the same thing, installing the SIMS and FMS clients to a Windows Server 2008 R2 machine for Remote Desktop Services access. I've done this before on a Windows Server 2003 machine, as noted here:

    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:

    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:
    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...

    Edit: This thread might also come in handy:

    SIMS via TS RemoteApp in server 2008R2
    Last edited by dhicks; 24th June 2011 at 03:25 PM.

  6. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Quote Originally Posted by jamesmay View Post
    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?
    You haven't set Windows to install mode.

  7. #6

    Join Date
    Aug 2008
    Location
    Medway, Kent
    Posts
    196
    Thank Post
    4
    Thanked 26 Times in 23 Posts
    Rep Power
    17
    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..

  8. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Run CMD as administrator
    change user /install [enter]s:\
    s:\setups\fms\fmsapplicationsetup.exe [enter]

    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

  9. #8

    Join Date
    Aug 2008
    Location
    Medway, Kent
    Posts
    196
    Thank Post
    4
    Thanked 26 Times in 23 Posts
    Rep Power
    17
    fantastic, that seems to of worked, can you explain the second bit of ur post?

  10. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    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.

    Change the FMS shortcut to "run in" c:\programdata\all users\app data\capita
    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 SOLUS3

    Change BDE PDOXUSR.NET to 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.
    • Open BDE Administrator from Control Panel
    Tip: You may need to switch to Control Panel to Classic View

    • 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

  11. Thanks to matt40k from:

    dhicks (4th July 2011)

  12. #10

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,663
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by dhicks View Post
    Code:
    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:\"
    Right: so I'm no getting the "Create User DSN Has Failed" error message whenever I try and start FMS. I've searched Google and these forums, and have of course come accross this post:

    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?

  13. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160

  14. Thanks to matt40k from:

    dhicks (5th July 2011)

  15. #12

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,663
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by matt40k View Post
    Many thanks. Unfortunatly, I've already moved the PDOXUSRS.NET file to C:\Paradox and manually changed the settings via the BDE Administrator in the Control Panel appropriatly - still no luck. I think I'm going to try a complete reinstall of SIMS and FMS from scratch - I seem to have SIMS install folders split over "Program Files" and "Program Files (x86)" which is probably causing some confusion.

  16. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Is this when you login? Did you set it to install mode? Do you have a default printer?

  17. Thanks to matt40k from:

    dhicks (6th July 2011)

  18. #14

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,663
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by matt40k View Post
    Is this when you login?
    Login? You mean as a particular user (in my case, of course, with admin rights, which might cause some confusion)? I've logged in to the server as myself, the network administrator account and I've had one of the accountancy staff log in to test FMS. All login accounts get the same result when they start FMS, an eror message reading "Could not create user DSN".

    > 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...

    Do you have a default printer?
    No, but it's a good point, I'll set one up.

    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 04:06 PM.

  19. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    I think they might be fixing the printer issue -

    1105-******
    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?

  20. Thanks to matt40k from:

    dhicks (7th July 2011)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 3
    Last Post: 14th September 2010, 03:12 PM
  2. SSRS VS Crystal Reports
    By hermiod in forum MIS Systems
    Replies: 0
    Last Post: 15th January 2010, 11:25 PM
  3. Crystal Reports report design
    By localzuk in forum Coding
    Replies: 3
    Last Post: 9th November 2009, 02:06 PM
  4. 'Back saving' with Crystal Reports
    By Ric_ in forum MIS Systems
    Replies: 1
    Last Post: 16th January 2009, 09:42 AM
  5. Sims.Net FMS and Thin clients
    By richard in forum MIS Systems
    Replies: 9
    Last Post: 13th December 2006, 09:10 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •