Nav 4SP3 SQL Server 2005 Logins not working

Methos
Methos Member Posts: 46
edited 2007-05-22 in SQL General
Hi.

I have a Navision 4 SP3 database running on SQL server 2005.

I was able to get one user , me ,to log into the database.
Now none of the new users I create in SQL can open the navision database. I Added the users to the Navision Logins and Syncronizing but navision says the users does not exist SQL.

Anny help please?

Answers

  • DenSter
    DenSter Member Posts: 8,307
    After adding the users you need to synchronize security
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kine
    kine Member Posts: 12,562
    1) Read the documentation
    2) If you are using DB logins, you need to create the users on SQL first and add them PUBLIC rights to the DB. After that you can add them in NAV.
    3) If you are using Windows auth. you do not have this problem, it means see point 2... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Methos
    Methos Member Posts: 46
    Hi, Thanks I got it working.

    Not sure if it was that i did not grant the public rights on the DB, pritty sure I did.
    Started over, made logins on server, and seperately added users to the DB. added the users to NAV and it syncronized.

    Could it maybe have been that I used the mapping from the server logins to add the database to a login?

    Thanks for the help.

Categories