+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Create User DSN has failed in Technical; Trying to install FMS on a workstation. After running the FMSApplicationSetup.exe and connecting to the FMSConnect.ini file I can't access ...
  1. #1
    button_ripple's Avatar
    Join Date
    Dec 2007
    Location
    Luton
    Posts
    346
    Thank Post
    93
    Thanked 20 Times in 18 Posts
    Rep Power
    17

    Create User DSN has failed

    Trying to install FMS on a workstation. After running the FMSApplicationSetup.exe and connecting to the FMSConnect.ini file I can't access FMS, I just receive "Create user DSN failed".

    What does this mean and how can I fix it??

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Either need to install SQL Native Client (get it from microsoft website) or BDE (it's on the old FMS CD).

    PM me if you want links

  3. Thanks to matt40k from:

    button_ripple (29th January 2009)

  4. #3

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    From Capita site, should help

    This is due to the SIMS_FMS_DATABASE entry with SQL Native Client not being installed, and is caused by the BDE not being installed correctly on the workstation


    FIX 1
    This can be added manually in Start | Run | type odbcad32.


    In User DSN tab, Add Driver name as SQL Native Client
    The name is SIMS_FMS_DATABASE


    If SQL Native Client does not appear in the list to select then please download and install SQL Server Native Client from Download details: Feature Pack for SQL Server 2005 Feb 2007


    (If for any reason you are unable to install the Native Client, please ensure Windows Installer 4.5 has been installed first)


    FIX 2
    Browse any of the FMS Installation disks, and run Setup1.exe from the DISK 1 folder under BDE. If you do not have a disk, please contact the Service Desk for the BDE settings. Once received, extract to a folder on C:\ and run the Setup1.exe from the DISK1 folder


    FIX 3
    This error can occur when the minimum hardware/software specifications have not been met on the machine being installed. In one case, this was due to the fact the Windows XP Service Pack 2 had not been installed on the machine. Also apply all windows updates and then re-running the client installation.


    For full details of the installation requirements for SQL Server 2005 Express Edition, visit the following Microsoft website:


    Microsoft SQL Server 2005: System Requirements


    FIX 4
    Remove SIMS Infrastructure and then re-install by running SIMSinst.exe

  5. 11 Thanks to Greg:

    adurrant (23rd March 2009), button_ripple (31st January 2009), docboggle (27th September 2010), eejit (14th March 2013), IT_Man_Dan (3rd June 2010), mtdmitchell (12th February 2009), RavehDaveh (20th March 2009), reggiep (14th July 2010), RobFrain (29th June 2010), Sam_Brown (1st September 2010), TechMonkey (29th August 2012)

  6. #4
    kcymer's Avatar
    Join Date
    Nov 2007
    Posts
    149
    Thank Post
    4
    Thanked 9 Times in 8 Posts
    Rep Power
    15
    Sorry to update such an old post, but hopefully it will help some people.

    Since we upgraded to SQL 2008R2 we always have trouble running FMS - the problem is if you install SQL native client for 2008 it will not work. You need SQL native client for sql 2005, than it work al fine.

  7. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by kcymer View Post
    Sorry to update such an old post, but hopefully it will help some people.

    Since we upgraded to SQL 2008R2 we always have trouble running FMS - the problem is if you install SQL native client for 2008 it will not work. You need SQL native client for sql 2005, than it work al fine.
    If you just install FMS with the FMSInst.exe installer, it will install all the required prerequisites by itself including the SQL 2005 Native Client.

SHARE:
+ Post New Thread

Similar Threads

  1. Create New user groups in joomla
    By PEO in forum EduGeek Joomla 1.0 Package
    Replies: 6
    Last Post: 17th April 2008, 10:31 PM
  2. Replies: 0
    Last Post: 17th February 2007, 04:43 PM
  3. Replies: 4
    Last Post: 27th September 2006, 02:31 PM
  4. Replies: 4
    Last Post: 12th July 2006, 09:59 AM
  5. Script to create a local user on a XP box.
    By tosca925 in forum Scripts
    Replies: 3
    Last Post: 12th October 2005, 12:04 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
  •