2009 R2 Windows AND Database Logins

We often have warehouse temps who might use NAV, but don’t need any other network access or applications. We use Windows authentication in NAV.  I was hoping we could set up a generic Active Directory login like Shipping for the supervisor to log onto the network and then assign Temp 1, Temp 2, Temp 3 database access to NAV. However, I don’t see passwords on Database login security except in SQL. Is there a way to combine both Windows and Database logins or are these mutually exclusive?  

Thank you!

——————————
Noreen Fujita-Sacco [Designation]
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
——————————

first setup sql server to “sql server and windows authentication”, then restart sql server. can be done in sql server properties. 

then create a new sql login, e.g. “sqluser”, in <sql-servername>securitylogins. there you can set a password. set there also the user mapping. select the database, there set the database role membership to db_owner.

in the nav 2009 development environment goto tools/security/database logins. add the above user sqluser and set the role e.g. to super.

after that try to login in the dev. env. with that new database login.

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
——————————
——————————————-

Hi Noreen,

We use Database Logins for a very similar purpose. Our Warehouse personnel login to NAV through their RF guns using their database login. All other users login with their Windows credentials.

Database login credentials and mapping are controlled at the SQL level. In NAV, you assign the Roles.

——————————
Stephen Marsh [Designation]
Enterprise Services Manager
Axxess Logistics
Vaughan
Canada
——————————
——————————————-

It should be noted that this only applies to Classic.  The RTC in 2009 R2 requires Windows authentication.  You can however change the ClientCredentialType on the Client to “UserName” to cause the Roletailored client to prompt for Windows credentials each time it loads which may give you a similar result.

——————————
Mark Miranda
Director of Information Technology
Western Computer
——————————
——————————————-