Problem to access Nav4 SQL DB

Comments

• Options

  ara3n Member Posts: 9,256

  2005-09-26

  Are the users Db logins or windows logins in Navision ?
  Did you click on tools security, windows login?
  
  You mentioned windows authentification. that's why I'm asking.
  Also did you run synchronize?
  In Nav 4 you have to synchronize every time after a security change.

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0
• Options

  DenSter Member Posts: 8,304

  2005-09-26

  The windows user account must be set up with access in SQL Server as well.

  Daniel Rimmelzwaan
  RIS Plus, LLC
  MVP - Business Apps

  0
• Options

  ovicash Member Posts: 141

  2005-09-27

  tatiana wrote:

  Hi !
  I have a user who has roles: SUPER & ALL. W're working in Nav4 SQL using windows authentification.
  
  That user is already created in Navision. Ex: User ID: BOB; Password : 1234
  
  I try to enter in Navision by choosing the DB but i cant. What could be the problem???
  I did the same with another User ID ( ADMIN ) with same roles ( SUPER and ALL)
  
  Thanks for help me out.

  
  What the error says? I don't think matters here but as far as I know Super and All should not be chosen together.

  ovidiu
  
  Best Regards

  0
• Options

  mkessler Member Posts: 6

  2005-09-27

  Did u choose the right Networkprotokoll?
  As i did start to work with NAV 4.0 i did often step into the trap that the Networkprotokoll sometimes (i don't know why until know) switches to TCPS instead of TCP we use. This also did close me the acces to our DB.

  0
• Options

  tatiana Member Posts: 37

  2005-09-28

  Hi Guys!
  
  I just forgot to do the synchronisation.
  
  Thanks for help

  0