+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 53
MIS Systems Thread, SQL migration "Login failed: Reason 0" in Technical; my user owns and has full control of ALL files in the simsroot share.....
  1. #31

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    my user owns and has full control of ALL files in the simsroot share..


  2. #32
    BigWheels's Avatar
    Join Date
    Feb 2009
    Posts
    9
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Hi Brett,

    Strange - If when you ran dbupgrade and the server and database names weren't populated it means it hasn't been able to get the details from your 'central' connect.ini. (even on a re-direct it should pick them up).

    But then again it must be finding something when you run sims.net or you'd get a 'incorrect connect.ini error' rather than a reason 0. (just tried it out)

    Might be worth trying to take the 'connects' out the equation and copying the [SIMSCONNECTION] details out of the central connect.ini so that the copy local to SIMS .net contains the 'ServerName' and 'DatabaseName' values.

    Then try juggling round with IP/machine names in the connection details.

  3. Thanks to BigWheels from:

    broyles (3rd March 2009)

  4. #33

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

    with vs-sims\SIMS2005 get error 0

    with 172.16.1.4\SIMS2005 get invaild user name/password

    (and I have set the user in the sql management studio)

    Will try a deattach/reattach

  5. #34

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    but vs-sims\SIMS2005 does work in dbattach.....

  6. #35

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    ok done the deattach/reattach and still getting invaild pw... (at least the error as changed)

    one thing I have noticed

    Compairing my user (in the security of the sims database part of sql studio manager) I see on the new server my Default schema is dbo, but on the exisiting server its sims_itsupport ..


    Wonder if thats any revelance..... could any one check what your settings are there?

    Ta

    Brett
    Last edited by broyles; 3rd March 2009 at 11:13 AM.

  7. #36

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    I smell a DNS problem.

    Check your DNS settings (reserve DNS as well?)
    Try ipconfig /flushdns
    Failing that add the record to C:\windows\system32\drivers\etc\hosts or just give up and use the IP address.

  8. #37

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by matt40k View Post
    I smell a DNS problem.

    Check your DNS settings (reserve DNS as well?)
    Try ipconfig /flushdns
    Failing that add the record to C:\windows\system32\drivers\etc\hosts or just give up and use the IP address.
    Well..


    Its a brand new system... Tested dns and all seems good

    I can

    A) ping vs-sims
    b) ping vs-sims.domain.local
    c) nslookup vs-sims

    all resolve to the right ips (tested from 3 machines)

  9. #38
    BigWheels's Avatar
    Join Date
    Feb 2009
    Posts
    9
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Checked a couple of users in my trianing dataset and thier default schema is set to dbo.

  10. Thanks to BigWheels from:

    broyles (3rd March 2009)

  11. #39

    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
    Checked a couple of users in my trianing dataset and thier default schema is set to dbo.

    Ok thanks for that wonder if thats just a hangover from the 2000-2005 upgrade on the old system.


  12. #40

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I know i am replying to my self.. but

    I am starting to wonder if its the DPM DB that we have restored.... so tonight I am going to connect to my sims server, detatch the DB copy it, then re-attach it..

    couple of ?'s

    A) is that safe
    B) would it be a better option to stop the sql server, then just copy the db?

    Thanks

    Brett

  13. #41
    BigWheels's Avatar
    Join Date
    Feb 2009
    Posts
    9
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    I tend to take backups and restore them when testing on other boxes, but from those 2 i'd probably say detaching and attaching would be "cleaner".

  14. #42

    Join Date
    May 2007
    Posts
    24
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    do u mean a sims backup within system manager and use that?

  15. #43
    BigWheels's Avatar
    Join Date
    Feb 2009
    Posts
    9
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Usually use dbattach for the backups, but its all the same thing.

  16. #44
    ravens's Avatar
    Join Date
    Oct 2007
    Location
    Barnet
    Posts
    39
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Did it work?

    Hi,

    Just built a Windows 2008 server and having the same problems. Did attaching the latest database work for you?

  17. #45

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    We are getting reports of Reason 0 on SQL Express. There is something odd with memory allocation that we are getting assistance on from MS. Please log a support call so that we get your case recorded.

SHARE:
+ Post New Thread
Page 3 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: 42
    Last Post: 17th July 2014, 01:25 PM
  2. SQL memory issues and Reason 0
    By leonard.powers in forum MIS Systems
    Replies: 23
    Last Post: 1st October 2009, 12:58 PM
  3. SQL Server 2005 - Terminating without reason!
    By googlemad in forum Windows
    Replies: 13
    Last Post: 28th April 2009, 11:53 AM
  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
  •