Add RTC Users and they are not Development Users? (2013)

Joe_Mathis

Added some RTC users that are Windows Auth in the RTC and can successfully login to the RTC with them.

Start up the Development Environment and use database login with SA and no issue.

Start up the Development Environment and try to use Windows Auth results in error:

---

Microsoft Dynamics NAV Development Environment

---

The following SQL Server error or errors occurred:

18456,"28000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'theDomain\JoeMathis'.

---

OK

---

](*,)

Couldn't find any mention of synchronization of users.

Not opposed to manually adding development users, but if anyone knows a better way... \:D/

ThomasHej_MSFT

There is "no better way" :-)

In 2013 we changed the NST (Nav server) to use a single account to login to the SQL server and at the same time removed all "sync" between NAV users and SQL users.

The reason was that in a true 3-tier (with 3 physical boxes) the setup to do delegation of the client credentials through the NST and further on to the SQL server was utterly complex.

Also, in 2013 we allow alternernative ways of authenticating (e.g. ACS and NAV User/Password), none of which are authenticated on the SQL server. They also need a "seperate" account to use to access SQL server.

With all that removed, the NAV Developent Environment no longer tries to sync any windowsuser to the SQL server - instead you can login using any SQL user account.


Thomas

Joe_Mathis

Well...

I guess it is what it is. It's not a whole lot of extra work

Thank you for the quick answer and explanation.

The reason was that in a true 3-tier (with 3 physical boxes) the setup to do delegation of the client credentials through the NST and further on to the SQL server was utterly complex.

Yes... yes it was!
Adding development users is much easier to keep straight.

Thanks!