i've the following problem:
we have a production 'navision 5.0/sql server' server on the domain Xxxx.
I take a backup of the nav database and i restore it on a different sql
server on a different domain Yyyy. sql server has no problem to restore
db. but in navision it doesn't work ? I have the following error: 'the
combination of user id and password entered is invalid. try again'
i can adapt credentials in the sql server but i can't change the
credentials in Navision because i can't connect.
any hint ?
thank you in advance,
Ele.
"Eric Lecocq" <lec...@nospam.be> schrieb im Newsbeitrag
news:op.uodey...@6710b-lecocqe.psbe.site...
"Volker Strähle" <vol...@straehle.com> wrote in message
news:OtzjP58f...@TK2MSFTNGP03.phx.gbl...
If you are out of other options you can try and delete the content of the
User table in the database (from some SQL tool), You will loose all
information related to this table, but will be able to log in.
Best regards
/Jesper
"RedFox" <redfo...@ukr.net> wrote in message
news:1F79A505-F30F-4DF5...@microsoft.com...
"Eric Lecocq" <lec...@nospam.be> wrote in message
news:op.uodey...@6710b-lecocqe.psbe.site...
Volker
"Daniel Rimmelzwaan" <newsgroup@rispluspointcom> schrieb im Newsbeitrag
news:5DD3ABED-D05B-40F1...@microsoft.com...
"Volker Strähle" <vol...@straehle.com> wrote in message
news:urbumoqg...@TK2MSFTNGP03.phx.gbl...
Volker
"Daniel Rimmelzwaan" <newsgroup@rispluspointcom> schrieb im Newsbeitrag
news:3269FD62-EF4E-4136...@microsoft.com...
What I just don't understand is why you're insisting that you should be able
to access a NAV database (or any database for that matter) with an
unidentified domain user, that just doesn't make any sense to me. It
wouldn't be a very secure application if you could just connect to the
database with a user that is not defined within the database's permissions.
Might as well allow anonymous access.
As I mentioned earlier, you can use the SA account, or create a separate
database login on SQL Server, define that as a database login inside the NAV
client, and be able to get in using that account when restoring the database
to a different domain. You'd have to recreate the windows users from there,
but at least you can get in.
"Volker Strähle" <vol...@straehle.com> wrote in message
news:Otg9L0tg...@TK2MSFTNGP02.phx.gbl...
I just though he was restoring a DB in SSMS and then try to enter in DB.
Sorry but when I think in NAV and SQL, I only use SSMS to performe NAV.
"RedFox" <redfo...@ukr.net> wrote in message
news:D6932DD5-1BF0-40C8...@microsoft.com...