yesterday i encountered a strange behavior between sql and nav. I admit i am not a sql expert, i know only the base of the base....of the base
First things first: sql 2005, nav 4sp3, sql authentication.
There is a database on server X with three users, let's call them A,B,C (creative, huh?).
i've just restored a backup from server x from witin nav to a newly created database on server Y, the original backup contained A,B,C users. I log on with A user (dbo) and i tried to synch all.
ERROR: user B does not exist in the sql database (I don't remember the exact message).
i checked user logins and i noticed that the users actually exists...I deleted and recreated user B from SSMS and then i deleted user B from within NAV.
i tried to reinsert user B and i got the same error as before while validating the field...what the?!?!
Anyway, i tried to sync nav w/o user B and i got:
ERROR: user C does not exist in the sql database (I don't remember the exact message).
Damn it! user c, too?!?!I tried to sync single login....surprise!success!!then i tried to resync all, but i got the usual error.
After this, i tried to log into nav with C user...success!...And then why nav says that this user does not exist in sql...no way!
Last chance: user A became a sysadmin, and everything went well. Then i toggled sysadmin flag from user rights...
In my opinon, the problem is now solved :whistle: :whistle: but what is the real problem?isn't this really strange?
"Never memorize what you can easily find in a book".....Or MibusoMy Blog