why i cannot login navision nav 3.6 ?
first i restore database from .fbk file
and the i could automatically login (after i finished restore the database)
after that i cannot login, although i create a new user(in sql server)
stan,
Drop your DB. Restore it again. When you login first automatically you can go and delete all the users (both Windows and Database) and security will be off your database. i.e. no login needed.
But if you want to use the same security as from the backup you need to make sure that SQL Backend is setup.
If you backup a Nav DB from one SQL instance and restore it to another it will not restore the SQL Security you had setup, just the Nav Security tables.
how about if i have a backup data is .mdf, .ldf,. log file?
may i delete user direct from sql server??
unfortunedly i don’t have back up file from navision (.fbk)
In this case, you can create the users in SQL and this should fix it.
Another way is to delete the users in the Navision-security tables directly from SQL.
You need to delete the records in tables “Member Of”, User, “Windows Access Control”, “Windows Login”.
Was worried about giving this advice out. Though I have used it a few times [;)]