User unable to log in - No Error

SQL 2008
NAV 5
Security Model = Standard

Created a new windows user, with ALL role and additional required roles.
Synched All Logins

Database just doesn't open - no errors.

Did the same with a new database login.
Created the login in SQL
Created it in NAV
Synched
Confirmed that user was created in DB

Database doesn't open. No errors.
Also nothing in Windows or SQL Logs.

If I use the wrong password, at least I get an error that says wrong password.

I logged in as myself, switched on the debugger with Breakpoint on Triggers, try to login as that user, doesn't even hit CU1.

I cleared out old unused logins - both SQL and Win logins - didn't seem to help.

Any ideas?
Kind Regards,
Ewald Venter

Answers

  • krikikriki Member, Moderator Posts: 9,094
    Check the SQL Server logs to see if NAV even gets to the server but is then refused entry. If you don't find those login errors, then check the firewalls.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • eYeeYe Member Posts: 168
    edited 2018-02-09
    @kriki , thank you for the reply.

    As mentioned, there is nothing in the logs.

    And it doesn't seem to be machine dependent, rather user. I am testing with existing logins that can get in and new logins (db logins) that can't, from the same machine.
    Kind Regards,
    Ewald Venter
  • eYeeYe Member Posts: 168
    Also, testing on the actual server itself
    Kind Regards,
    Ewald Venter
Sign In or Register to comment.