+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, FMS general SQL error after server move in Technical; Morning all... Have just moved SIMS and FMS to a new server. Now have FMS running successfully on 2 machines, ...
  1. #1
    yjb
    yjb is offline
    yjb's Avatar
    Join Date
    Jan 2010
    Location
    North Wales
    Posts
    8
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    FMS general SQL error after server move

    Morning all...

    Have just moved SIMS and FMS to a new server. Now have FMS running successfully on 2 machines, but I get an error when logging on with a 3rd:

    General SQL Error.
    [Microsoft][SQL Native Client]SQL Network Interfaces: Server doesn't support requested protocol[xFFFFFF]

    I thought it was an FMSconnect.ini issue, but have used the same .ini file from the other working machines to no avail.

    Logging on as the admin on the same PC I get no errors, FMS works fine, suggesting a permissions issue, but user has same permissions as other users.

    I did notice that when I ran odbcad32, in the native client configuration, the SQL server in the drop down box seems to switch back to the old SQL instance (ADMIN_YJB\SIMS2008) after I have selected the new instance (YJB-MIS\2008) and saved.

    Any ideas how I can fix this - do you thing an uninstall/install of FMS on the machine to start fresh would be the answer?

    TIA! Dave.

  2. #2

    Join Date
    Nov 2009
    Location
    Manchester
    Posts
    1,064
    Thank Post
    6
    Thanked 207 Times in 187 Posts
    Rep Power
    53
    Want my advice, reinstall FMS normally to make sure all the bits get installed.

    Then if you still have a problem (this is my favorite solution for FMS) copy the whole folder from a working FMS installation and replace the one on the broken machine. This fixes more FMS bugs then any other fix, I usually use the admin c$ share to grab a working installation.

  3. Thanks to Achandler from:

    yjb (2nd November 2012)

  4. #3
    yjb
    yjb is offline
    yjb's Avatar
    Join Date
    Jan 2010
    Location
    North Wales
    Posts
    8
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Achandler View Post
    ...reinstall FMS normally to make sure all the bits get installed...
    Seems silly to ask but what is the best way to do this, there is no KB on Support Net.

    I'm assuming it's a bit of a task to do a 'leave no trace' uninstallation of FMS.

  5. #4

    Join Date
    Nov 2009
    Location
    Manchester
    Posts
    1,064
    Thank Post
    6
    Thanked 207 Times in 187 Posts
    Rep Power
    53
    I find most Capita installers are a bit meh.

    I would re-run the original installer over the top, this will check for parts of FMS missing, such as the infrastructure or the BDE module etc. Once you know these bits are installed , then try copying a working FMS folder in the place of the "none-working" current one and test.

  6. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 490 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by yjb View Post
    Seems silly to ask but what is the best way to do this, there is no KB on Support Net.

    I'm assuming it's a bit of a task to do a 'leave no trace' uninstallation of FMS.
    FMSInst.exe in the Setups\FMS folder.

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    Is it Win7 machine?

  8. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,942
    Thank Post
    1,199
    Thanked 1,069 Times in 760 Posts
    Rep Power
    330
    @yjb:

    It could be the lockdir permissions, as you have stated it works for the admin user, it will probably be the BDE config that requires changing on each workstation that has FMS running on it.

    This requires a central folder to which the users have the appropriate permissions creating on the Sims server called "lockdir" then, on each workstation which you intend to run FMS from, go on as local admin and configure the BDE from the administration console, you will find this at C:\Program Files\Common Files\Borland Shared\Bde\bdeadmin.exe

    This will open up the console window, in here under the configuration tab click the plus next to Drivers then again for he Native and then click on the Paradox, in the right hand side you will see NET DIR, point this to the folder called lockdir on the server which you created earlier.

    Then click the plus next to System and click INIT, in the right hand side you shouldsee LOCAL SHARE and a value of False, change this to true and then close the window, save config if asked and then try FMS.

    Good luck and don't forget also that FMS requires a default printer attached to each machine it is run from.

  9. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    Quote Originally Posted by bossman View Post
    This requires a central folder to which the users have the appropriate permissions creating on the Sims server called "lockdir" then, on each workstation which you intend to run FMS from, go on as local admin and configure the BDE from the administration console, you will find this at C:\Program Files\Common Files\Borland Shared\Bde\bdeadmin.exe
    NO, NO, NO!!! This should be pointing to local C:\ProgramData\FMS folder, go wash your mouth out with soap!

  10. #9

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,942
    Thank Post
    1,199
    Thanked 1,069 Times in 760 Posts
    Rep Power
    330
    @matt40k:

    I have ran it like this for as long as I can remember and have had no problems whatsoever, this was the information given to me by Capita through our LA MIS team to which I have the original documentation.

    This has been commented on before and as far as I am aware quite a few people use this config.

    Unless someone from Capita tells me otherwise then I will carry on using this config.

  11. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    Quote Originally Posted by bossman View Post
    @matt40k:

    I have ran it like this for as long as I can remember and have had no problems whatsoever, this was the information given to me by Capita through our LA MIS team to which I have the original documentation.

    This has been commented on before and as far as I am aware quite a few people use this config.

    Unless someone from Capita tells me otherwise then I will carry on using this config.
    By your logic, my original documentation about moving SIMS tells me to install MSDE (SQL 2000), and I should be install MSDE onto my shinny server, shall I install that onto my shinny new server? I don't think so. It's time you ask for more update documentation which will say run FMSINST or use SOLUS3 rather then do this, the change that and hammer this until it fits.

  12. #11

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,942
    Thank Post
    1,199
    Thanked 1,069 Times in 760 Posts
    Rep Power
    330
    @matt40k:

    Here is the original document from my MIS team: FMSBDEconfig.jpg

    This is what I have worked from for the past 8 years and have had no problems whatsoever.

  13. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,428
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    That's got references to when it was SQL Anywhere!!

    To quote the Capita release notes - which personally isn't great...

    Moving the NET DIR Location
    In the BDE, sharing of data between more than one workstation is controlled by the Pdoxusrs.net file. All workstations operating on the
    same data should not point to the same file.

  14. #13
    yjb
    yjb is offline
    yjb's Avatar
    Join Date
    Jan 2010
    Location
    North Wales
    Posts
    8
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Achandler View Post
    ...copy the whole folder from a working FMS installation and replace the one on the broken machine. This fixes more FMS bugs then any other fix, I usually use the admin c$ share to grab a working installation.
    This was a while ago now, but just wanted to say that Achandlers suggestion worked a treat, thanks!

SHARE:
+ Post New Thread

Similar Threads

  1. FMS SQL Error
    By Rawns in forum Educational Software
    Replies: 6
    Last Post: 3rd June 2014, 03:18 PM
  2. Replies: 7
    Last Post: 1st December 2011, 09:26 PM
  3. [SIMS] General SQL Error aftering upgrading to FMS 6.136
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 22nd December 2010, 11:24 AM
  4. Content does not display after web server move.
    By Apokeylips in forum EduGeek Joomla 1.0 Package
    Replies: 1
    Last Post: 30th June 2010, 12:20 AM
  5. Replies: 1
    Last Post: 10th November 2009, 10:37 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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