+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, SIMS 'ExecuteNonQuery' error - Help! in Technical; In need of some advice please guys and gals. Secondary school with a new server running Windows Server 2012 and ...
  1. #1
    MrMat's Avatar
    Join Date
    Jul 2013
    Location
    Solihull
    Posts
    181
    Thank Post
    20
    Thanked 40 Times in 30 Posts
    Rep Power
    28

    SIMS 'ExecuteNonQuery' error - Help!

    In need of some advice please guys and gals.

    Secondary school with a new server running Windows Server 2012 and SQL 2008 R2 is getting the following error when some users try to log in:

    Untitled.jpg

    Restarting the server seems to fix the error temporarily however after a few hours it seems to start rearing it's ugly head again. Both TCP/IP and Named Pipes are enabled. Server has plenty of RAM etc.

    Any ideas on this one? I'm stumped.

    Thank you.

  2. #2
    pleach85's Avatar
    Join Date
    Jan 2011
    Posts
    24
    Thank Post
    3
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    you could try adding commandtimeout = 10000 to your connect.ini if its not already there

    seemed to help in this similar post upgrade to SQL2005 express error "ExecuteReader requires an open and available... (see 2nd post)



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims RDP error
    By WebbA in forum MIS Systems
    Replies: 11
    Last Post: 4th October 2012, 01:22 PM
  2. [SIMS] SQL2008 Attaching+Restoring Sims Database ERROR
    By ev32 in forum MIS Systems
    Replies: 14
    Last Post: 9th February 2012, 12:50 PM
  3. [SIMS] SIMs Profile errors when generating reports
    By willkeddie in forum MIS Systems
    Replies: 1
    Last Post: 18th January 2012, 01:48 PM
  4. [SIMS] SIMS Homepage error message
    By lynne_pattison in forum MIS Systems
    Replies: 49
    Last Post: 15th September 2011, 02:56 PM
  5. [SIMS] NOVA T4 error - Help [Solved]
    By timbo343 in forum MIS Systems
    Replies: 1
    Last Post: 7th June 2010, 10:58 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
  •