I have a problem logging into Navision Financials with Database Authentication. I receive a TCP/IP Network Error 10093. I can logon with Windows Authentication without any problems. The Database is running as a service on a W2K Server. The clients are a mixture of XP and W2K Pro. I get the same Network Error from every pc. I have check the services & hosts file and everything appears to be correct. I do not understand why I can successfully logon with Windows Authentication if there really is a TCP/IP Network Error.
Hello Gary, I too have found the “Windows Login” functionality lacking a lot. a) You have to define user roles separately for database and windows login, which seems really silly. b) If not running Active directory, the way you have to set up Windows authentication is not very intuitive. But having set up the user (Domain\userID), and having defined her/his roles, I have not encountered any real problems. Maybe it is dependent of the domain/server/client configuration. Please describe your configuration, and we might be able to help you out. Pelle
Gary, We have SQL2000, Nav 2.60f…here’s what we did: My guys setup user groups under NT. Then added the same name of the user group to Navision with applicable roles/permissions. When the user logs in, they are authenticated and Navision grants them permission under the NT group, however, their user name is recorded on all transactions. Establishing the roles was our problem as it is not intuitive and we finally got there through a lot of code pecking and trie/error. Works great and very low maintenance. If you have SQL, have you installed the Navision extended stored procedure and copied the dll to the SQL server binn directory? Bill