+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, new sims server setup in Technical; hi guys I have hit a stumbling block while setting up a new sims server, I have copied the databases ...
  1. #1
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    534
    Thank Post
    104
    Thanked 23 Times in 21 Posts
    Rep Power
    17

    new sims server setup

    hi guys

    I have hit a stumbling block while setting up a new sims server, I have copied the databases across to the new sims servers and the docstorge as well. I can login to the new system and get all of our data.

    however when i try to run a report it get the error its not on the docuement server. I have point the new sims setup at the new docstore in sims.

    also does any one know how to mirgate fms data from a old server to a new 2008 server?

    thanks

    Mark

  2. #2

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,493
    Thank Post
    1,184
    Thanked 745 Times in 647 Posts
    Rep Power
    228
    Quote Originally Posted by ful56_uk View Post
    however when i try to run a report it get the error its not on the docuement server. I have point the new sims setup at the new docstore in sims.
    Make sure your new server has a firewall exception to allow port 8080, which is where the SIMS document server listens out on.

    --
    David Hicks

  3. Thanks to dhicks from:

    ful56_uk (18th June 2009)

  4. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    You need change the server name on the docstorage folder structure.

    IE:
    C:\docstorage\SERVER NAME\SQL INSTANCE\DATABASE

    EG:
    c:\docstorage\server\sims2005\sims

  5. Thanks to matt40k from:

    ful56_uk (18th June 2009)

  6. #4

    Join Date
    May 2007
    Location
    Suffolk
    Posts
    145
    Thank Post
    2
    Thanked 19 Times in 17 Posts
    Rep Power
    18
    Have you renamed the "Docstorage" sub-folder to reflect the new server name?

    (Stop and re-start the service after the change)



    Have you changed the "Document Server" setting in SIMS .net?

  7. Thanks to Polski from:

    ful56_uk (18th June 2009)

  8. #5
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    534
    Thank Post
    104
    Thanked 23 Times in 21 Posts
    Rep Power
    17
    right sorted that thanks guys. its all pointing to the right place now.

    does any know how to do the fms bit?

  9. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Migrate FMS to new Server.

    This assumes:

    You are running FMS in SQL 2005 on your old server,
    That SQL Server 2005 has already been installed on the new SIMS Server
    You have an up to date sims\setups directory including FMSInst.exe - if you haven't ask you LA to send you a new clean setups directory on CD.


    Run the transfer login command in a cmd window - shown below where FMS is the name of your FMS database.

    osql -S%computername%\sims2005 -E -n -Q"exec [COLOR="rgb(46, 139, 87)"]FMS[/COLOR].sims.db_p_transfer_login"


    Log into FMS on Old Server - make a "Transactions Backup" from Tools | Transaction Backup

    Now log into DBAttach (Really should be called DBManage Capita ) and make another backup of the database from there.


    Stop and disable the SQL Server on the old Box.
    Sideways copy the MDF and LDF of your FMS Database as well as the backups you made to the new server or a network location/USB etc that you can easily get to them on from the new server.


    Run FMSInst:

    At the Install Options dialog, select both checkboxes, to configure the server as both an FMS workstation as well as an FMS SQL Server.

    At the FMS Setups Directory dialog, ensure that the path is set to S:\SIMS\Setups (if you use S: as a mapped drive for SIMS) or the UNC path.


    At the FMS Workstation Settings dialog, set the FMS Applications Directory to *\Program Files\SIMS\FMSSQL.


    At the FMS SQL Server Settings dialog, from the dropdown box select the same SQL instance as for SIMS and leave the database name as FMS.


    Depending on your server configuration you may get several security warning dialog boxes as the installer launches its helper programs. Click ‘Run’ on each of them. FMSInst will launch dbattach in order that the transferred FMS database can be attached to the new SQL Server.


    First log in to the utility:


    • Check that the Server Name is correct. It should be the machine name, then a backslash, then the SQL server instance name.
    • Enter sa as the username and your ‘sa password’ for the password.
    • Click Connect.


    Next attach the database:

    • In the section Attach a Detached Database click the button with three dots on to bring up an Open dialog.
    • Navigate to the folder containing the detached database files from the old server. Select the FMS.mdf file.
    • Enter FMS in the Database Name field.
    • Click Attach.


    You should get a message saying The database FMS has been successfully attached to <servername>\mis.

    On closing dbattach you will get a dialog informing you that the installation has completed, click Finish to close the dialog.


    Setting up the FMSConnect.ini


    The ‘FMSConnect.ini’ file tells FMS which database it should connect to. This step will explain how to make a global or master FMSConnect.ini file that resides in the shared adsoft\sims directory and then how to make sure FMS Client machines use the connection information contained within that file.


    In Windows Explorer, navigate to S:\SIMS. If it does not already exist, create a text file called FMSConnect.ini.


    NB - (You may need to uncheck the ‘Hide extensions for known file types’ in ‘View Options’ in order for the file extension to be editable).


    Enter the following:

    [FMSConnection]
    Server=<insert server name here>\<and instance name here>
    Database=FMS
    Trusted_Connection=No


    Save and close the file.


    To create a local FMSConnect.ini which redirects to the global or master FMSConnect.ini

    • Launch FMS (go to Start All Programs SIMS Applications FMSSQL SIMS FMS Module).
    • At the Locate FMS on your System dialog, ensure the I can access an FMSConnect.ini file at another location radio box is selected.
    • Click on the magnifying glass button, and select the S:\SIMS folder.
    • Choose OK


    The FMS login dialog will appear.

    In order for the local FMSConnect.ini which redirects to the central FMSConnect.ini to actually be created, a successful log in to FMS is required. Otherwise you will be asked to locate the ‘FMSConnect.ini’ again the next time FMS is launched.


    Client machines need to have a connect.ini that points at the new Server and Database.

  10. 3 Thanks to superfletch:

    ful56_uk (18th June 2009), SeanVin (12th November 2009), SpuffMonkey (19th June 2009)

  11. #7

    SpuffMonkey's Avatar
    Join Date
    Jul 2005
    Posts
    2,192
    Thank Post
    52
    Thanked 270 Times in 178 Posts
    Rep Power
    131
    God like description superfletch! You haven't got another for doing a fresh client install have you - it would be MUCH appreciated. Cheers

  12. #8
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Thanks :-) - I'll try:

    Fresh Client install of FMS:

    There must be at least one printer installed, (for cheques an approved cheque printer should exist),
    The SQL Native Client must have been installed,
    Dot Net framework v2 + sp1 must be installed, (I'd have 3.5 on there too)
    Main user of the PC needs Full access to the Program Files\SIMS directories and all subdir's.**

    **Consider using setups\simsperm.bat

    Map network drive to the sims root share:

    If SIMS is not on the machine I'd recommend running SIMS\WSSetup\Setup1.exe to install the BDE, although you could probably run SIMSInfrastructure.exe
    (When installing the BDE, ALWAYS choose to install a Fresh Copy)

    Now run:

    \Setups\FMSApplicationSetup.exe
    (no need for FMSSQLApplicationSetup.exe here as it is only required on the SQL Server).

    Install to:

    Program Files\SIMS\Finance



    Once it is installed run it.

    When it opens you will have to login successfully before an FMSConnect.ini will be created. *

    You either need to point it at an existing FMSConnect.ini which you know to be good, or you can tell it to connect direct to the SQL Server using a local FMSConnect.ini, in which case you'll need to tell it

    Servername\instancename
    databasename


    *See the previous post about fmsconnect.ini
    Last edited by superfletch; 20th June 2009 at 09:53 PM.

  13. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Hi all,

    I thought this might be of help, it is not always necessary but if you have machines which won't connect to your FMS database and you've met all the other requirements then try this on your SIMS SQL server:


    Optimising SQL Server

    1) Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager
    2) Select SQL Server 2005 Network Configuration > Protocols for INSTANCE
    3) Ensure Named Pipes is Enabled

    Close the |Surface area config manager

    1) Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
    2) Select Surface Area Configuration for Services and Connections
    3) Expand the SQL Instance that hosts FMS from the left hand side and then expand the Database Engine node
    4) Select Remote Connections
    5) Ensure that Local and Remote connections are enabled for both TCP/IP and Named Pipes
    6) Click Apply
    7) Reboot the server

  14. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    The Capita SQL installer will configure all that, that's only for full SQL installs.

    As for FMS, the new install will install BDE, SQL native client. Please ensure you have the latest version, the new one (from the installable CD) includes fmsinst. Same idea as simsinst.

    (Currently waiting for Capita to provide a FMS infrastruture via Solus)

    You also need to run FMS so it create PDOXUSRS.NET, this is by default, located in the root of C:, you can change the location using the BDE Administrator, all FMS users will need full access rights, otherwise you'll get errors when you try using the reports.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS Learning Gateway Setup
    By IT_Man_Dan in forum MIS Systems
    Replies: 18
    Last Post: 10th June 2009, 03:30 PM
  2. SIMS Setup Folder
    By mattpant in forum MIS Systems
    Replies: 3
    Last Post: 3rd April 2009, 12:05 PM
  3. New Server Setup
    By Maximus in forum Wireless Networks
    Replies: 10
    Last Post: 2nd June 2008, 10:29 PM
  4. SIMS setup directory
    By tony8991 in forum MIS Systems
    Replies: 3
    Last Post: 20th January 2007, 04:35 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
  •