Can't get database users to log in

michaelm

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

bbrown

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.

michaelm

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

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]