User unable to log in - No Error

eYe

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?

kriki

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.

eYe

@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.

eYe

Also, testing on the actual server itself