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
Big thanks, i've forgotten to add the user into the NAV database logins -.-
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...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (