Steps to create a new login in sql

chandrurec

Hi all,

I want to create a new login in sql and then add that in Navision.

If any one know the steps involved in creating a new login in sql and then adding it in navision, Kindly let me know.

Thanks in advance.

Regards,
Chandru.

vijay_g

first create userid in SQL Logins in security(you can also select default database ).
then create same Userid in Navision database(you can also select particular Compnay in roles) after that synchronize to same.

chandrurec

Hi vijay_g ,

I tried to create a login named test in sql and then attach the same login in database login in navision and then assign it to super role but when I try to login using the new credentials, I am getting a error "Login failed when connecting to sql server RWS-0107".

If you know how resolve this error, Kindly let me know.

Thanks in advance.

Regards,
Chandru.

kine

See w1w1isql.pdf on the install DVD in DOC folder for detailed description what is needed... do not forget to synchronize permissions if you are using extended security model.