Can´t log into navision after restoring a client database

txeriff

Hi,

After restoring a client database i realize i dont have any user on it, just sys and dbo called users.

Usually i log with a know user adding db_owner permissions and then i can add more into navision permissions but now, as i cant log on, i cant do anything.

So can any1 tell me how to set navision permissions to log on?

creating a new user and setting it to db_owner doesnt work.

mohana_cse06

Search the forum you will get lot of posts on this topic
http://www.mibuso.com/forum/viewtopic.php?f=32&t=47074

txeriff

i dont get it. i dont get how to solve it.


edit:

solved doing:

delete from XXXX.[dbo].[User]


thanks a lot

mohana_cse06

did you check the link? is it not helpful to you?
if no, search the forum.

kine

In most cases it is because the accounts in the database (database level "accounts") are not connected to the accounts in the master DB (the server level "accounts"). Look for "orphaned SQL Server users" and how to fix them... ;-)

It is mainly when you create SQL backup on one SQL and restore it on another. Because the users have different SIDs in the SQLs, the users will not be connected correctly...