+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Accessing multiple FMS Servers from a single machine in Technical; We've got a Terminal Server (Windows 2003 based) which is running on a network with several servers running SIMS for ...
  1. #1

    Join Date
    Feb 2006
    Location
    Isle of Wight, UK
    Posts
    149
    Thank Post
    28
    Thanked 28 Times in 25 Posts
    Rep Power
    22

    Accessing multiple FMS Servers from a single machine

    We've got a Terminal Server (Windows 2003 based) which is running on a network with several servers running SIMS for a number of local schools. We're having a few problems persuading the Terminal Server to connect to different FMS servers depending on the user logged in.

    The FMS servers themselves are all running without a hitch (we've disabled broadcasting, and have changed the SQL Anywhere server names so they no longer clash).

    I can change the FMS server accessed by the Terminal server as a whole by editing the ODBC configuraion for the SIMS32 System DSN, but if I create other System DSNs for the other servers (and update each user's sims_db.ini accordingly) everything still uses the SIMS32 one.

    Does anyone know if the SIMS32 DSN is hard-coded into FMS, or can it be overridden?

    Stephen

  2. #2
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: Accessing multiple FMS Servers from a single machine

    You need to install multiple fms clients each in it's own directory and linked to a specific FMS server.

    Wes

  3. #3

    Join Date
    Feb 2006
    Location
    Isle of Wight, UK
    Posts
    149
    Thank Post
    28
    Thanked 28 Times in 25 Posts
    Rep Power
    22

    Re: Accessing multiple FMS Servers from a single machine

    Quote Originally Posted by wesleyw
    You need to install multiple fms clients each in it's own directory and linked to a specific FMS server.
    Ok, I've got two FMS folders now, but I can't see where to link them to different servers? - any pointers?

    Cheers,

    Stephen

  4. #4
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: Accessing multiple FMS Servers from a single machine

    Each one should have been installed and told which FMS server they would run from. All that is needed then is for the shortcut to be renamed to show which FMS system it connects to.


    Wes

  5. #5

    Join Date
    Feb 2006
    Location
    Isle of Wight, UK
    Posts
    149
    Thank Post
    28
    Thanked 28 Times in 25 Posts
    Rep Power
    22

    Re: Accessing multiple FMS Servers from a single machine

    Quote Originally Posted by wesleyw
    Each one should have been installed and told which FMS server they would run from. All that is needed then is for the shortcut to be renamed to show which FMS system it connects to.
    Hmm. I'm obviously missing something here

    I've run the FMS setup (for version 6.78) twice, and installed to two different folders (let's call them 'FMSSch1' and 'FMSSch2'). For each install, I specified the correct (remote) drive path for the SQL files (each school has a separate physical server, but the drive paths for the FMS SQL are the same on each).

    There is only one ODBC System DSN created, called SIMS32, and that seems to be the problem, as it always points to the last school's FMS installed. I can create other DSNs, and even tweak sims_db.ini files, but all installations of FMS still use the SIMS32 DSN.

    All I can say is roll-on FMS .NET (although I'll probably be regretting that!)

    Cheers

    Stephen

  6. #6
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,050
    Thank Post
    68
    Thanked 75 Times in 59 Posts
    Rep Power
    34

    Re: Accessing multiple FMS Servers from a single machine

    Can you not just use the FMS Database selector tool? Maybe this doesn't work if the databases are located on different servers but it works fine for us where two versions are on the same server.

    HBJB

  7. #7

    Join Date
    Feb 2006
    Location
    Isle of Wight, UK
    Posts
    149
    Thank Post
    28
    Thanked 28 Times in 25 Posts
    Rep Power
    22

    Re: Accessing multiple FMS Servers from a single machine

    Just a quick update - I've got FMS working now, with the following configuration:

    1 x Server 2003 Terminal Server, with a single client install of FMS
    2 x Server 2003 Std, with server installs of FMS

    On the TS, I have configured the SIMS32 System DSN, in the 'Startup Options' to have a 'Start command' of:

    Code:
    c:\progra~1\sqlany50\win32\dbclient.exe @S:\fmsconf.txt
    The file 'fmsconf.txt' on the S: drive contains the following:

    Code:
    -ta 600 
    -x TCPIP{host=172.31.255.14;ServerPort=1501}
    The host IP is changed for each server, and I'm running the servers on different ports too (avoiding the startup problems). The port is configured in the registry on each FMS server machine, at:

    Code:
    HKLM\System\CurrentControlSet\Services\SQLANYs_SIMS_SQL_DB_Server\Parameters
    And the value of the 'parameters' is:

    Code:
    -n SIMS_Database -c 8192 -tl 1500 -x NamedPipes,TCPIP{BROADCAST=FALSE;ServerPort=1501}
    With that set, it's all running without any problems.

    I've just got the old Personnel via SIMS launcher to do now, but that's another thread

    Stephen

SHARE:
+ Post New Thread

Similar Threads

  1. Pupils accessing servers and shared folders
    By faza in forum Wireless Networks
    Replies: 22
    Last Post: 6th July 2009, 07:16 PM
  2. Replies: 2
    Last Post: 17th May 2007, 09:54 AM
  3. Installing WSUS on multiple servers?
    By tosca925 in forum Windows
    Replies: 1
    Last Post: 15th November 2006, 09:11 PM
  4. Multiple People Accessing single file
    By Nij.UK in forum Windows
    Replies: 6
    Last Post: 5th June 2006, 08:52 PM
  5. Students accessing the Servers through Word
    By ninjabeaver in forum Windows
    Replies: 33
    Last Post: 3rd February 2006, 04:43 PM

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
  •