SQL DB Connection Error

tooo

I've attached a backup of the SQL DB into SQL and i've added the same DB user to the database but m problem is that when i try to map the DB user to the NAV DB in SQL it wont let me as it says that the user or group already exists in the NAV DB, any ideas how i can map this DB user to the NAV DB?

Tomas

tooo wrote:

I've attached a backup of the SQL DB into SQL and i've added the same DB user to the database but m problem is that when i try to map the DB user to the NAV DB in SQL it wont let me as it says that the user or group already exists in the NAV DB, any ideas how i can map this DB user to the NAV DB?

delete user from:
- security -> logins
- databases -> your database -> security -> users

Then add user.

tooo

I get this error when i try to delete the user from the NAV DB!??
http://img233.imageshack.us/img233/2687 ... rordc7.jpg

kine

you need to delete the schema in the database for the selected user too...

kriki

[Topic moved from Navision forum to SQL General forum]

tooo

Thanks fo rthe help, got it connected.