I have an occasional issue that I am having problems diagnosing.
Basically I have cases where I create a SQL backup from a clients server then restore it to my local machine, I can not use DB logins to connect to that database. I am trying to narrow this down, but its not easy. basically it seems that I only get the issue if:
a/ The clients system was originally Native and had been converted to SQL. (Well more correctly stated, I have never had the problem with a Database that started life as SQL).
b/ The case of the USER id is different from. By that I mean that if you create a lowercase I in Native, it automatically converts to Uppercase in Navision, but SQL will allow you to create a user id in upper or lower case.
What I am guessing is that somewhere the password that was stored in the Native database, and that should no longer exist in the Converted SQL database, is actually still there, but I assume does not matter. But maybe somehow there is some "memory" of the case issue.
I had the issue last week, and went into SQL, deleted the original user (eg: johnsmith) and recreated a new user (JOHNSMITH) and then was able to log in. Of course it might just be revalidation of the password, but I had tried numerous times to change the password and that did not help.
Anyway its not a major issue, since its pretty easy to just create a new user, but its been niggling at me or months now and I feel I need to resolve this.