+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, Major SIMS.net Problem (HELP!) in Technical; Staff can't logon, and the error message says "Reason: 0". Has anybody come across this before? A County engineer says ...
  1. #1
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Major SIMS.net Problem (HELP!)

    Staff can't logon, and the error message says "Reason: 0".

    Has anybody come across this before? A County engineer says we need to re-install it all all client machines, but that's not practicle as we have 200+ machines with it on!

    Please help!

  2. #2
    SC-UK's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    569
    Thank Post
    36
    Thanked 85 Times in 71 Posts
    Rep Power
    29
    Restart the SIMS Server - should solve the problem.

    Tom

  3. #3
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by SC-UK View Post
    Restart the SIMS Server - should solve the problem.

    Tom
    We've tried that, and it hasn't done a thing!

    The odd thing is my Boss can log in with his credentials (Admin) and so can some one in GA.

  4. #4
    SC-UK's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    569
    Thank Post
    36
    Thanked 85 Times in 71 Posts
    Rep Power
    29
    Have you just applied a patch/upgrade/changed anything or has the problem suddenly started occurring on it's own?

  5. #5
    maark's Avatar
    Join Date
    Feb 2006
    Location
    leicester
    Posts
    470
    Thank Post
    90
    Thanked 73 Times in 65 Posts
    Rep Power
    38
    Check sims.net version number - latest is 7.114 - had problems upgrading to this with some stuck on 7.112.
    Had to run simsapplicationsetup on some to install.

  6. #6
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by SC-UK View Post
    Have you just applied a patch/upgrade/changed anything or has the problem suddenly started occurring on it's own?
    Just happened on it's own!

  7. #7
    SC-UK's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    569
    Thank Post
    36
    Thanked 85 Times in 71 Posts
    Rep Power
    29
    Try what Maark has suggested, or failing that see here http://support.capitaes.co.uk/websup...from=HotTopics

  8. #8
    Messa's Avatar
    Join Date
    Dec 2006
    Location
    Wolverhampton
    Posts
    301
    Thank Post
    67
    Thanked 29 Times in 25 Posts
    Rep Power
    21
    Isn't reason 0 something to do with the user not having permission to install software?

    have you tried it logged on as admin to the machine?

  9. #9
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by Messa View Post
    Isn't reason 0 something to do with the user not having permission to install software?

    have you tried it logged on as admin?
    Yep, done it logged as admin - and it does the same thing!

  10. #10
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by maark View Post
    Check sims.net version number - latest is 7.114 - had problems upgrading to this with some stuck on 7.112.
    Had to run simsapplicationsetup on some to install.
    Were on 7.112

  11. #11

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,524
    Thank Post
    513
    Thanked 2,399 Times in 1,859 Posts
    Blog Entries
    24
    Rep Power
    821
    Reason zero is down to not being able to connect to the server, ie. check firewall settings and check connect.ini files.

  12. #12
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by localzuk View Post
    Reason zero is down to not being able to connect to the server, ie. check firewall settings and check connect.ini files.
    But I can logon with admin on my machine and it works fine - then as a teacher (that's had the same problem elsewhere in the school) and it doesn't work!

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,338
    Thank Post
    367
    Thanked 622 Times in 508 Posts
    Rep Power
    155
    Try on one of those machines

    Logon as administrator
    Start | Run
    s:\setups\simsperm.bat everyone
    Runs sims (does it work?)
    Logoff, logon as staff
    Does sims work

  14. #14
    dannyjay's Avatar
    Join Date
    Jan 2009
    Location
    Worksop, Nottinghamshire
    Posts
    86
    Thank Post
    14
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Well so far, a fix in MS SQL Server Management Studio were you have to enforce password policy per user.

    Worked on one so far, going to see if it works on all with the issue!

  15. #15

    Join Date
    Sep 2005
    Location
    Lowestoft
    Posts
    49
    Thank Post
    8
    Thanked 7 Times in 7 Posts
    Rep Power
    19
    We had this exact same problem recently. We had to detach the database and then re-attach it before everything would work again.

    Here is what our county helpdesk sent us to resolve this issue:

    Open dbAttach

    Backup the "SIMS" database, close the error message and click on backup at the right.

    Close and re-open dbAttach.

    Detach the "SIMS" database.

    Close dbattach.

    Cut and paste the "SIMS.MDF" and "SIMS.LDF" files to another location.

    Run dbAttach.

    Browse to this new location for the "SIMS" file, type "SIMS" as your database and re-attach.

    Try loggig into "SIMS .net" on the server.

    ---------------------

    Also they sent me this Capita Doc:

    KB72254 - SIMS Connection failed for Login USERNAME reason: 0 - When logging into SIMS .net
    ________________________________________
    Created 07/08/2007
    Last Updated 07/01/2009

    ________________________________________
    Affected Products SIMS .net Setup & Permissions
    SIMS .net Installation & Upgrade
    ________________________________________
    Notes When logging into SIMS .net
    SIMS Connection failed for Login USERNAME reason: 0
    This will only occur if you are on August 2007 or later version of SIMS .net
    ________________________________________
    Advice PLEASE NOTE : FIX 1 IS ONLY RELEVANT IF THE USER'S PASSWORD HAS BEEN RESET

    Fix 1
    This may be due to the 'Enforce Password Policy' settings within SQL 2005

    To change this, log into SQL Server Management Studio and expand the Security tree and then the Logins tree.
    Find the user that is getting the error, right click on their name and select properties.
    In the Login Properties window, remove the tick from the 'Enforce Password Policy' tick box and then click OK. Close SQL Server Management Studio.

    Fix 2
    The machine may be pointing to a incorrect networked Connect.ini file and therefore cannot see any SQL Server or Database. Delete the Connect.ini from e.g. C:\Program files\SIMS\SIMS .net and then run SIMS .net and select the correct Connect.ini from e.g. S:\SIMS or alternatively create a local connect.ini and enter the correct SQL Server and Database name. Also check that the connect.ini in the S:\SIMS folder is pointing to the correct server\instance and the database

    Fix 3
    The error can also be an indication that the upgrade has been run, but has been unsuccessful.

    Please check that the version of SIMSSQLApplicationsetup.exe in the setups folder is 1.574.12.0 (for August 2008 release). Then run this to upgrade to version of DBupgrade

    Run Dbupgrade.exe manually from e.g. D:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn (This should be version 2.20.3.0). The list of upgrade files will be shown or there may be a message about a User already logged in. If Users are detected, a Force All will need to be run to exit the Users out of SIMS to allow the upgrade to commence (requiring the SA logon credentials). This Force All option will appear automatically if Users are detected as being logged in.

    Once this has completed run SIMSApplicationsetup.exe on the machine that is generating the error

    Fix 4
    If the error still occurs and you installed SQL Server 2005, but did not use our installer then please follow KB71936

    Fix 5
    Check there is sufficient space on the partition where SQL is installed. Also check the system partition has sufficient space as temporary files can be created during the backup.
    Check the size of the SQL Log file eg SIMS.LDF. If excessively large use SHRINKDBLOG.BAT to shrink the log file.
    Fix 6
    Please ensure that SQL connections are allowed through the Firewall.
    For information on how to do this, see the Microsoft article relating to How to: Configure a Windows Firewall for Database Engine Access

    Fix 7
    Please also ensure that TCP/IP and Named Pipes are enabled.
    To Enable TCP/IP and Named Pipes, please see KB79978

    ----------------------------------------

    Hope this is helpful!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Problem with batch backup or SIMS.net using DBAttach
    By GreenICT in forum MIS Systems
    Replies: 5
    Last Post: 18th August 2009, 08:48 AM
  2. Major network problem
    By Andyhall in forum Wireless Networks
    Replies: 5
    Last Post: 6th September 2008, 01:20 PM
  3. SIMS.net report problem
    By localzuk in forum MIS Systems
    Replies: 6
    Last Post: 20th May 2008, 03:22 PM
  4. SIMS.net RTF Report Problem
    By MARKR in forum MIS Systems
    Replies: 3
    Last Post: 21st February 2008, 09:54 AM
  5. SIMS.Net - problem importing new reports [SOLVED]
    By Irazmus in forum MIS Systems
    Replies: 31
    Last Post: 12th October 2006, 02: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
  •