Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: simple question: users & roles

    SHORT VERSION
    i am setting up roles, do i also have to set up role-people as users?

    LONG VERSION
    my db has two owners. both of us run the Access front end happily - everything works perfectly.

    now i'm trying to add non-owner users.
    i have set up ten people as datareader/datawriter (primitive, but will refine this later).
    these people are not able to get into the db.
    at the registering DSN stage they can't see the server in the list of servers and if they manually type \\myserver they can't connect (doesn't exist or access denied).

    in Enterprise Manager,
    Users: shows only the two owners
    Roles:datareader shows the ten non-owners (ditto datawriter)

    am i supposed to setup my datareader/writers as users as well?
    should i see them in the Users: list?

    thanks for your time.

    izy
    currently using SS 2008R2

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My guess is that you want them to type myserver instead of \\myserver for the server name. Have you tried that yet?

    -PatP

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    thanks Pat, maybe what you say is true - i have no means of telling since meanwhile i discovered that i don't have rights to sp_grantlogin.

    methinks this could have a lot to do with my problem!

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •