+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 43
MIS Systems Thread, SIMS Connection failed for Login USERNAME reason: 0 in Technical; Hi, The problem is with all users, and some depending on the wether. Capita have now suggested i re apply ...
  1. #16

    Join Date
    Feb 2007
    Posts
    73
    Thank Post
    3
    Thanked 4 Times in 2 Posts
    Rep Power
    16
    Hi,

    The problem is with all users, and some depending on the wether. Capita have now suggested i re apply the patch using the sysman account.

    Andy

  2. #17

    Join Date
    Dec 2007
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by atfnet View Post
    Hi tech_guy,

    Had this problem last week every time I reset a password or changed permissions in system manager. As a temporary fix dismount and remount the database.

    Capita have a password reset patch but it corrupted our database and I had to restore from a backup.
    I am awaiting a new patch.

    Hope this helps

    Andy

    when I got this problem ( Connection Failed Reason 0) after some investigation and experimentation the following worked

    1. If logging on remotely using a script to map the drives so you get a S:\sims drive mapped >> change the names of the servers to their internal IP addresses in the logon script

    2. on the local machine go to the sims installation in c:\program files or where-ever

    >> DELETE the Connect.ini file ( make sure you are on the LOCAL Machine NOT server !) Then try to run SIMS or Pulsar.exe - it will give 'can't find connect.ini' error

    >> BROWSE to the Connect.ini file on S: Drive Sims folder

    >> connection became established

  3. #18
    amvc's Avatar
    Join Date
    Oct 2007
    Posts
    136
    Thank Post
    39
    Thanked 14 Times in 12 Posts
    Rep Power
    19
    Had this too, cured by changing the local connect.ini to point directly to the server instead of to the servers connect.ini.

    So, changed from

    [SIMSConnection]
    Redirect=S:\sims

    to

    [SIMSConnection]
    Servername=mis-sr-sims
    DatabaseName=SIMS_220807


    Jon

  4. #19

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by amvc View Post
    Had this too, cured by changing the local connect.ini to point directly to the server instead of to the servers connect.ini.

    So, changed from

    [SIMSConnection]
    Redirect=S:\sims

    to

    [SIMSConnection]
    Servername=mis-sr-sims
    DatabaseName=SIMS_220807


    Jon
    We never use redirect but had massive problem, which now seem to have settled down. Fingers crossed and touching anything wooden.

  5. #20

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,897
    Thank Post
    3,420
    Thanked 1,081 Times in 997 Posts
    Rep Power
    369
    Not sure if this is still relevant but in the sims setup directory somewhere is there a simsperm.bat file ?

    If so run that and that should correct the permissions for sims

  6. #21

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    17
    Moved SIMS from an old server to a brand new one today..sims runs fine on this server but same issue Reason 0 on workstations. Tried all of the KB suggestions...plus the ones on here, anybody got any more advice...

    Cheers

  7. #22

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Firewall on the server? Is TCP\IP enabled?
    Last edited by matt40k; 10th August 2009 at 04:04 PM.

  8. #23

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,683
    Thank Post
    1,268
    Thanked 788 Times in 685 Posts
    Rep Power
    237
    Quote Originally Posted by ndavies View Post
    sims runs fine on this server but same issue Reason 0 on workstations.
    Remember that each SIMS client needs to connect to your SQL server, so you have to let whatever port SQL Server uses through your firewall and ensure that SQL Server knows multiple clients will be connecting (and you have to buy SQL Server CALs for the appropriate number of clients). Same goes for the SIMS document server - it runs on port 8080 by default (I think), so make sure that can get through your firewall too.

    --
    David Hicks

  9. #24

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    17

    mapped drives

    Grrr...it was a mapped drive thing...set the new one up as S when the old one was G....changed the S to G (like Chain Letters) and it's fine...I did re-run simsinst with S instead but it didn't like it...

  10. #25

    Join Date
    Jan 2011
    Location
    Ceredigion
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Had this several times and this seens to do it for me.

    Connect.ini
    [SIMSConnection]
    Redirect=S:\sims

    changed to
    [SIMSConnection]
    Redirect=\\[Server Name]\[Sims Share]\sims

    Like a charm.
    Mike

  11. #26

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    Quote Originally Posted by dolly3900 View Post
    Had this several times and this seens to do it for me.

    Connect.ini
    [SIMSConnection]
    Redirect=S:\sims

    changed to
    [SIMSConnection]
    Redirect=\\[Server Name]\[Sims Share]\sims

    Like a charm.
    Mike
    That kind of implies that the S: drive wasn't mapping correctly, though if that's the case, it's not usually a reason 0, that occurs.

  12. #27

    Join Date
    Jan 2011
    Location
    Ceredigion
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The reason 0 is apparrently due to not connecting to the database, so an incomplete mapping or redirection would cause this error.

    The problem (with mine) seems to be that despite the mapping being correct and being able to browse the drive, the connect.ini was not pickingup the mapped drive for some reason (probably reason 0 {sorry}).

    When the local connect.ini was modified to look at the path rather than the drive, it sorted this problem out for me.

    One thing I will say is that to make sure of the correct server being pointed to, I modified the Hosts file to make sure the local machine was loing at the correct IP address for the server, rather than relying on the DNS to pick it up.

    Hope this helps someone

    Mike

  13. #28

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    Maybe S was in conflict with something else, USB key, we've had that, or they didn't have permission to see the local connect.ini, though i don't think either of those would result in a reason 0.

  14. #29

    Join Date
    Feb 2010
    Posts
    8
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    The tech at one of our schools had this yesterday after uninstalling SQL2005 (he had upgraded to 2008 the week before). He reported that he got it working again after reinstalling SQL Server Native client.

  15. #30
    saihaynes's Avatar
    Join Date
    Nov 2007
    Posts
    22
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    14
    Quote Originally Posted by dolly3900 View Post
    Had this several times and this seens to do it for me.

    Connect.ini
    [SIMSConnection]
    Redirect=S:\sims

    changed to
    [SIMSConnection]
    Redirect=\\[Server Name]\[Sims Share]\sims

    Like a charm.
    Mike
    +1 for this resolving the issue

    Sai

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. [SIMS] SQL migration "Login failed: Reason 0"
    By zag in forum MIS Systems
    Replies: 52
    Last Post: 16th January 2011, 03:15 PM
  2. [Fog] FTP connection to Storage Server has failed!
    By Batman in forum O/S Deployment
    Replies: 14
    Last Post: 26th May 2010, 10:11 PM
  3. vista login failed :-S
    By browolf in forum Windows Vista
    Replies: 5
    Last Post: 20th January 2009, 08:19 PM
  4. SIMS Connection failed - Reason 2
    By mortstar in forum MIS Systems
    Replies: 23
    Last Post: 5th June 2008, 12:48 PM
  5. Replies: 2
    Last Post: 25th October 2007, 08:37 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
  •