Hi
We are currently running Navision with windows authentication but I want to also add users that don't have a Windows account and use database authentication. Is it possible to mix the two methods of authentication?
The reason I ask is that I have tried and and am still getting a "The combination of user ID and password entered is invalid. Try again." error.
Thanks
Neil
HI Neil,
of course, this is possible. First make sure that the SQL Server's Security settings (instance properties) are set to "Mixed Mode" (= Windows and DB logins).Then create the Logins in SQL Server, assign the appropriate Server-Roles, then map the User to the relevant DB (assigning required DB Roles).Finally you could create the DB Login in NAV. If you are using "Enhanced" Security Model (not recommended) then you have to "Synchronize" the Logins.
This is also described in the "Installation and System Management (SQL)" PDF.
Cheers,Jörg
Joerg A. StrykSTRYK System ImprovementNAV/SQL Performance Optimization
Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.
What permissions does the user have on the SQL Database? In other words wich server role?
(Select Database server | Security | Users | Properties | Server roles) try connecting to nav with the user having the "sysadmin" server role.
To which database have you mapped the user, i would recommend to map the user to the "master" database, this ensures the user will always have acces, even when your NAV database is renamed / deleted. Map with the "Public" database membership role to your NAV database.
<spam removed by moderator>
Of course you can. What database server are you running? SQL Server or Native (NAV) Server)?
Luc van Vugt, Imtech ICTNever stop learning
Luc van Vugt: Of course you can. What database server are you running? SQL Server or Native (NAV) Server)?
We're in the SQL forum here
Jörg, you are right
Great! Glad to hear that you can. So the next question is why doesn't it work?
We are running SQL Server 2005 Express.
I have created a database login and I can access the database using this without any problems.
I have created a database user with Navision and synchronised the security (not sure if that is necessary)
But when I try and login I get the "The combination of user ID and password entered is invalid. Try again." message. I have tried ensuring the case is the same but this makes no difference.
Not sure where else to look - any ideas?
Try creating the user in SQL without any password rules and password blank. Does that work?
You must create the Database user in SQL as well as in Navision.
We use database users for "system" access controlled by IT for batch processing and Windows Logins for users.
Is that working OK now?
Jonathan.
Hi Jonathan
That is exactly what I did - created the login in SQL first and tested that I could login via isql which was fine. We then created the login in Navision with the same name but when we try and login I get the message shown above.
Not tried with a blank password though not sure why that should make a difference.
N
Thank you all so much for your help. It was the server/database roles in the end.
It is now sorted.