+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 53
MIS Systems Thread, SQL migration "Login failed: Reason 0" in Technical; The_Windy_Miller > Tried that, same problems.... Phoned our sims team, asked for instructions on how to do it , their ...
  1. #16

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The_Windy_Miller >
    Tried that, same problems....

    Phoned our sims team, asked for instructions on how to do it , their answer -- We don't have any.. you can pay us 25(or 50 can not remember)/hour for us to do it for you....
    Seems to be very little info online as well

  2. #17

    Join Date
    Aug 2008
    Posts
    40
    Thank Post
    0
    Thanked 7 Times in 7 Posts
    Rep Power
    14
    Make sure your SQL Server is configured to allow TCP/IP connections in configuration manager, and add SQL Server to the firewall exceptions list.

  3. Thanks to scebe427 from:

    broyles (3rd March 2009)

  4. #18

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    What's your LEA?

  5. #19


    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,317
    Thank Post
    131
    Thanked 355 Times in 293 Posts
    Blog Entries
    4
    Rep Power
    142
    Do you have SQL Management Studio available, or Studio Express?

    If so, try picking a user through that and reset their password, then try and login as them.

  6. #20

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    In answer to the questions.

    Will try reseting a users password now (prays)

    got tcip+named pipes opened in SQL Server Surface Area Configuration

    turned off all firewalls (its in a nice safe vlan)

    Sheffield LEA.

    Thanks for all this help by the way.. really appricated

  7. #21

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    reset a users password, still getting error 0... but the strange thing is if I put a incorrect password.. I get an invalid user/password message so I think its connecting to the db.....

  8. #22
    BigWheels's Avatar
    Join Date
    Feb 2009
    Posts
    9
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Something to try that might help diagnose the problem would be running the copy of dbupgrade that sits in the SIMS.net folder.

    If the SQL Server details are being read in correctly from the connect.ini then they'll be filled in on the login screen so they can be checked.

    DBUpgrade will also let you enter your sa user name and password so you can check if its just a problem with the SIMS logins as well.

    It might help take a few other things out of the equation.

  9. Thanks to BigWheels from:

    broyles (3rd March 2009)

  10. #23

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by BigWheels View Post
    If the SQL Server details are being read in correctly from the connect.ini then they'll be filled in on the login screen so they can be checked.
    The Details where blank

    Quote Originally Posted by BigWheels View Post
    DBUpgrade will also let you enter your sa user name and password so you can check if its just a problem with the SIMS logins as well.
    Tried as my user , and got login failed for the user sims_itsupport


    going to try a 2003 install just incase its somthing to do with 2008...

    Will get back to you all,

    again thanks for this.

    Brett

  11. #24
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    31
    Is this when you're logging onto SIMS at the server itself? Or just client PC's..?

  12. #25

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    both.

    (had to be dragged onto webfiltering for a bit.. still installing 03)

  13. #26
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,427
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    I have fixed this in the past with the following. Then again we have a weird setup too:

    On the client machine with SIMS client installed:
    1) Check the network drive for the SIMS network share is mapped properly.
    2) Check the connect.ini file in C:\Program Files\Sims\Sims .net\ is pointing to the SIMS network share. We have to modify it manually as the default one throws up errors.
    3) Also try editing the connect.ini file so it just has the bit in brackets and below it a line saying Redirect= followed by the path to your SIMS network share (using mapped drives, not networking UNC). MIS told us to do this, I don't know what it does but back up the original connect.ini in Program Files!
    4) Check C:\Windows\sims.ini is also pointing to the network share (again, use the path via the mapped drive not netowrking UNC).

    Not sure what it fixes but it works for me when people ask for help with this error.

  14. Thanks to CAM from:

    broyles (3rd March 2009)

  15. #27

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by CAM View Post
    I have fixed this in the past with the following. Then again we have a weird setup too:

    On the client machine with SIMS client installed:
    1) Check the network drive for the SIMS network share is mapped properly.
    2) Check the connect.ini file in C:\Program Files\Sims\Sims .net\ is pointing to the SIMS network share. We have to modify it manually as the default one throws up errors.
    3) Also try editing the connect.ini file so it just has the bit in brackets and below it a line saying Redirect= followed by the path to your SIMS network share (using mapped drives, not networking UNC). MIS told us to do this, I don't know what it does but back up the original connect.ini in Program Files!
    4) Check C:\Windows\sims.ini is also pointing to the network share (again, use the path via the mapped drive not netowrking UNC).

    Not sure what it fixes but it works for me when people ask for help with this error.
    Tried this no joy :/

    Still getting error 0 on 2003 so I am at a real loss..

    We are now considering getting our LEA in to do this...

    Is it me or does sims seem really clunky at the backend..........

  16. #28

    Join Date
    Aug 2008
    Posts
    40
    Thank Post
    0
    Thanked 7 Times in 7 Posts
    Rep Power
    14
    make sure the sql server service is running under the localsystem account.

  17. Thanks to scebe427 from:

    broyles (3rd March 2009)

  18. #29

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    yep services are running under localsystem...

    but our "live" server is running under a network user

  19. #30

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Could be file\share permissions.



SHARE:
+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. [SIMS] SIMS Connection failed for Login USERNAME reason: 0
    By tech_guy in forum MIS Systems
    Replies: 43
    Last Post: 11th November 2014, 03:22 PM
  2. SQL memory issues and Reason 0
    By leonard.powers in forum MIS Systems
    Replies: 23
    Last Post: 1st October 2009, 01:58 PM
  3. SQL Server 2005 - Terminating without reason!
    By googlemad in forum Windows
    Replies: 13
    Last Post: 28th April 2009, 12:53 PM
  4. SIMS Connection failed - Reason 2
    By mortstar in forum MIS Systems
    Replies: 23
    Last Post: 5th June 2008, 01:48 PM
  5. Replies: 2
    Last Post: 25th October 2007, 09: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
  •