mibuso.com
Home› SQL General
Options

SQL DB Connection Error

toootooo Member Posts: 138
edited 2008-08-01 in SQL General
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?

Answers

  • Options
    TomasTomas Member Posts: 420
    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.
    Tomas,
    Dynamics NAV Enthusiast
  • Options
    toootooo Member Posts: 138
    I get this error when i try to delete the user from the NAV DB!??
    http://img233.imageshack.us/img233/2687 ... rordc7.jpg
  • Options
    kinekine Member Posts: 12,562
    you need to delete the schema in the database for the selected user too...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    krikikriki Member, Moderator Posts: 9,096
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    toootooo Member Posts: 138
    Thanks fo rthe help, got it connected.
Sign In or Register to comment.