SQL Server connection

amarnath
amarnath Member Posts: 51
edited 2008-12-18 in SQL General
Hi guy can u actually tell me how to hold a SQL server for many user from different network system to access the database and to work on some database alone.

Cirteria:- sql server with 15 connecting system to it and the sql server must have 3 database one can be accessed by all the user and the others can be accessed by admin.
AMARNATH SRINATH

Comments

  • kine
    kine Member Posts: 12,562
    Please, be more specific, what you want to know. I didn't catch the main problem you have and what is the design of your system.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garak
    garak Member Posts: 3,263
    Please give us more informations.

    To allow / deny users to connect to a database you can set in Nav or / and in the SQL Management Studio.

    regards
    Do you make it right, it works too!
  • amarnath
    amarnath Member Posts: 51
    Detailed description of what i need.


    I have a sql express in my system which has network connectivity and will act as a server for the other 15 systems. This part is solved as of now. But the problem is i have created sql user authentication for all these users but these users are not able to create a table /form/report in navision. I believe there is some user privilege setting that has been the problem . Can you please let me know how to solve this issue.
    AMARNATH SRINATH

Categories