proper procedure of creating a user accessing Navision

simone

my navision always login to SQL server but I fail to create user myself. my procedure below:

user SQL ent. mgr. to create a user, assign password and DB access, giving role "public" and "DB_owner" for all DB.

afterward goto navision, click security|synchronize.

open MSSQL option for Navision

Click open | database and type in new username/pwd

receive error "the combination of userID and pwd invalid. Try again"

I test it by changing my current user password for many times and it works fine. really no idea of how to create new user.

please advise

kriki

2 possible ways:
1)
-create user in SQL
-assign public and dbowner roles in SQL
-create user in Navision
-because user is dbowner => no need to synchronize. BUT if the user can access the SQL-server in an other way than Navision, he can do everything with your Navision-DB

2)
-create user in SQL
-assign public role in SQL
-create user in Navision
-synchronize.

simone

thanks kirki

bbrown

General users do not require DB_Owner rights. This is only required by users that will be changing table definitions. (developers or fob import)