+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, General SQL Error aftering upgrading to FMS 6.136 in Technical; Hi, We've upgraded on SIMS/FMS server to 7.136/6.136 and set about upgrading our clients. On most machines after upgrading FMS ...
  1. #1

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    493
    Thank Post
    18
    Thanked 30 Times in 29 Posts
    Rep Power
    20

    Exclamation General SQL Error aftering upgrading to FMS 6.136

    Hi,

    We've upgraded on SIMS/FMS server to 7.136/6.136 and set about upgrading our clients. On most machines after upgrading FMS we are now getting a General SQL Error:

    General SQL error.
    [Microsoft][SQL Native Client] SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
    [Microsoft][SQL Native Client] An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
    [Microsoft][SQL Native Client] Login timeout expired
    Alias: dbCheckLogin

    I've checked everything I can think of, firewalls are off on both server and client, fmsconnect.ini is correct, sever is accessible from the clients experencing the problem, checked the entry for the SIMS_FMS_DATABASE User DSN under ODBC which is correct and even rebooted the affected client as suggested in one KB article on SupportNet.

    When trying to login to SIMS after upgrading on these clients we are getting reason 0 errors. I've worked through the various fixes and nothing appears to make a difference

    The server is running SQL 2008 SP2 and yesterday I upgraded the OS from Windows Server 2008 SP2 x64 to Windows Server 2008 R2 as it is supported from the Autumn 2010 release - I'd upgraded to Autumn 2010 prior to the OS upgrade.


    My gut feeling is that the upgrade as done somthing to SQL and that the reason it no longer works, but what?

  2. #2

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    493
    Thank Post
    18
    Thanked 30 Times in 29 Posts
    Rep Power
    20
    Panic over! I'd also installed Culumative Update 2 for SQL 2008 SP" and this caused the problems. After uninstalling it all now works.

SHARE:
+ Post New Thread

Similar Threads

  1. FMS SQL 2008 Upgrade
    By rh91uk in forum MIS Systems
    Replies: 2
    Last Post: 17th April 2010, 08:40 AM
  2. SIMS/FMS SQL on VMWare?
    By Johan in forum MIS Systems
    Replies: 21
    Last Post: 16th March 2010, 08:25 PM
  3. FMS SQL Error
    By Rawns in forum Educational Software
    Replies: 5
    Last Post: 13th August 2009, 04:37 PM
  4. Epson R300... general error
    By Joanne in forum Hardware
    Replies: 11
    Last Post: 15th May 2008, 11:23 AM
  5. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 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
  •