Can't get database users to log in

michaelm
michaelm Member Posts: 20
edited 2008-10-02 in SQL General
Hi

we had a hardware failure and have had to move the navision db to a new server. Whilst we are up an running we can not get our database log-ins to work. I have created a new user in SQL and a new user in nav and sync'd...but to no avail. We get a message "18488,"42000",[mICROSOFT][odbc sql server driver] Login failed. The password must be re-set.

Any ideas ?

thanks

Comments

  • bbrown
    bbrown Member Posts: 3,268
    1. Make a list of your NAV database logins

    2. Make a full SQL backup of the NAV database

    3. Delete the NAV database

    4. Create a SQL Server login for each of the NAV users. Set their password.

    5. Restore the SQL backup

    6. Login and sync.
    There are no bugs - only undocumented features.
  • michaelm
    michaelm Member Posts: 20
    Ok panic over !!

    I managed to work out a series of things that make it work. If I'm honest I thought I did exactly the same before, but it did not work. In the end the solution seemed to be....

    Change password in SQL
    Sync in Nav
    Change password again in SQL
    Sync in Nav
    Now I can get in.... Strange but true

    On to the next problem !
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories