+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 24
MIS Systems Thread, SIMS Connection failed - Reason 2 in Technical; Hi I've got a laptop here that was having some strange .NET framework issues and was throwing up common language ...
  1. #1
    mortstar's Avatar
    Join Date
    Jan 2007
    Location
    Oxford
    Posts
    341
    Thank Post
    13
    Thanked 29 Times in 18 Posts
    Rep Power
    22

    SIMS Connection failed - Reason 2

    Hi

    I've got a laptop here that was having some strange .NET framework issues and was throwing up common language runtime debugging services errors, which scuppered SIMS .Net.

    I uninstalled/reinstalled all the .NET Framworks and SIMS .Net itself. I can now get to the login box and the SIMS .Net splash box comes up showing version 7.96. However, before SIMS loads I get "SIMS Connection failed for Login <username>, reason: 2". The connect.ini file is present and correct and the S: drive is mapped to the correct network share.

    Does anybody know what this error means and what I need to fix the problem? Any help greatly appreciated - as always!

    Sam

  2. #2
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30

    Re: SIMS Connection failed - Reason 2

    The reason and solution is documented on the Captia SupportNet - KB72234

    But basically could be:

    Excessive network traffic.
    Incorrect connect.ini configuration.
    Firewall problems
    General network problems with this machine.

    Instead of reinstalling, delete the Sims.NET folder under program files and run the install again.

    Hope this helps.

    Skunk

  3. #3
    mortstar's Avatar
    Join Date
    Jan 2007
    Location
    Oxford
    Posts
    341
    Thank Post
    13
    Thanked 29 Times in 18 Posts
    Rep Power
    22

    Re: SIMS Connection failed - Reason 2

    Unfortunately we are supported by an LEA team and I don't have access to SupportNet.

    Excessive Network Traffic - This problem only seems specific to this laptop. Network traffic is normal

    Connect.ini file - Checked and re-checked - definitely the correct details.

    Firewall problems - The laptop is on a range that is allowed through the firewall to see the admin network - can ping the SIMS server.

    General Network problems - DHCP works fine, Reserved address working fine, DNS working fine - anything else I should be looking for here??

    I did delete the SIMS folder and reinstalled from SIMSInst. Having exactly the same problem, splash screen shows with correct version details, and then Reason code 2 appears and goes back to login screen.

    I'm stumped.

  4. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: SIMS Connection failed - Reason 2

    Does it happen with every user? if it doesnt then try this:

    Uninstall Simsinfrastucture
    Reboot
    Delete Sims .net Folder
    Run Simsinst.exe
    It should now install simsinfracture, simsapps and simsmanuals.
    Reboot
    Run sims
    It should install ampark

    Try to log it. Thats how i sorted my problem out. Also check your sims.ini in windir is correct and try changing your connect.ini file to point directly to the sql server.

    If it doesnt happen with every user and just certain one then its to do with the settings on your slq 2005.

  5. #5

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,820
    Thank Post
    883
    Thanked 685 Times in 454 Posts
    Rep Power
    505

    Re: SIMS Connection failed - Reason 2

    the "Reason 2" error is def the local copy of connect.ini

    Check it and ensure that it is one of 2 settings:
    Code:
    [SIMS Connection]
    ServerName=SERVER\SIMS-INSTANCE
    DatabaseName=SIMS_MORS
    CommandTimeout=100000
    Change SERVER to your SQL Server
    and SIMS-INSTANCE to the appropriate Instance name for the SIMS Database

    or
    Code:
    [SIMS Connection]
    redirect=S:\SIMS
    Change S:\ to the drive letter of your SIMS Shared Drive.

  6. #6
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63

    Re: SIMS Connection failed - Reason 2

    I am getting this exact error too. It happens on any user, but on only one particular machine. I have checked the Connect.ini and it is all fine (identical to the PC next to it, which works) i've done some test to check that the SQL server can be pinged by both its IP and resolve its name, and i still cant find anything wrong with the PC.

    My LEA have no idea what it is either.

    Andrew

  7. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    4,035
    Thank Post
    1,262
    Thanked 1,107 Times in 785 Posts
    Rep Power
    338

    Re: SIMS Connection failed - Reason 2

    Where on the laptop is the local connect.ini file stored?

  8. #8

    Join Date
    Jan 2007
    Location
    Midlands
    Posts
    45
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    17

    Re: SIMS Connection failed - Reason 2

    Quote Originally Posted by mortstar
    Unfortunately we are supported by an LEA team and I don't have access to SupportNet.

    .
    Morstar - Supportnet is available to all SIMS users and is extremely helpful - most peoples second port of call after EduGeek. ops:

  9. #9

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    64
    Thank Post
    6
    Thanked 18 Times in 13 Posts
    Rep Power
    18

    Re: SIMS Connection failed - Reason 2

    Is the local connect.ini set to re-direct to a network one. This causes us problems on the odd machine here and there in various schools. Deleting the connect.ini and running SIMS .net to recreate it, pointing it directly at the database usually sorts the problem.

  10. #10
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30

    Re: SIMS Connection failed - Reason 2

    Try putting the SIMS server ip address and hostname in the hosts file. I recall this is how I stopped this error in the past.

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367

    Re: SIMS Connection failed - Reason 2

    Just sticking my oar in because i can and it's a shiny new one.

    It's nothing to do with the fact that the system is being geared up to do single sign on is it.

    there's some command to do with trusted which i guess is local to the machine, not sure how it all works, as i haven't finished reading the August release notes let alone September!

    i got some strange login issues and noticed a whole host of new user accounts set up in enterprise manager and found it was linked to the move towards login using network credentials.

    just a thought....

  12. #12

    Join Date
    Jun 2007
    Posts
    19
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS Connection failed - Reason 2

    Probably not the cause of your problem, but this is worth mentioning as it is related.

    By default, SQL Express is installed with TCP/IP disabled, resulting in no connections working apart from direct from the server.

  13. #13

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,556
    Thank Post
    112
    Thanked 178 Times in 145 Posts
    Rep Power
    72

    Re: SIMS Connection failed - Reason 2

    We had this - local support centre logged into server for an hour and reckoned everything was fine - their response "must be your clients - let us know how you go on"

    Just noticed the service SQL Browser wasn't running - started the service and now all is fine! Go figure!

    SIMS - Sometimes It Might Stop!

  14. #14

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: SIMS Connection failed - Reason 2

    i'm getting connection failed to sims.net with connection 0 having tried to upgrade via solus to september version i'm screwed no one can access sims.net and even during working hours sims helpdesk only log the calls and noone calls back.

  15. #15

    Join Date
    Jun 2007
    Posts
    19
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS Connection failed - Reason 2

    Can you run SIMS from the server?



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

Similar Threads

  1. [SIMS] SQL migration "Login failed: Reason 0"
    By zag in forum MIS Systems
    Replies: 52
    Last Post: 16th January 2011, 04:15 PM
  2. I've fixed my "reason 2" error - Sims.naff
    By michael_mc in forum MIS Systems
    Replies: 6
    Last Post: 21st November 2007, 11:30 AM
  3. Replies: 2
    Last Post: 25th October 2007, 09:37 AM
  4. Sims error - Reason 5???
    By cophighschool in forum MIS Systems
    Replies: 12
    Last Post: 4th October 2007, 02:22 PM
  5. SIMS .net MSDE connection limit
    By localzuk in forum MIS Systems
    Replies: 3
    Last Post: 20th December 2006, 04:23 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
  •