web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) SQL Server rights (Cla...

Microsoft Dynamics NAV (Archived)

SQL Server rights (Classic Client) for Classic Client User

(0) Share

Report

Report

Posted on by Florian Steckler

25

Hello,

I have to create some user-accounts in SQL Server 08 to log in to the demo database (CRONUS) to work on it (for a lecture).

which rights are necessary on the database to log in (no Windows authentification, the students work on the Classic Client)?

I have tried it with "public" and "db_owner", but after the first log in there appears an erroe that the username/password is incorrect...

Thanks!

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Kine_ 2,053 on at

Like (0)

Report

You need only to create the account on SQL. Rest is on NAV. Just add the user into Database logins in NAV and assign the roles. But! If you are using Extended security, you need to synchronize the logins. I recommend to use standard security. Than you do not need this.

DO not forget to have at least one login in NAV with SUPER rights, else you can lock the database...

Was this reply helpful? Yes No
Florian Steckler 25 on at

Like (0)

Report

Big thanks, i've forgotten to add the user into the NAV database logins -.-

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans