Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Domain Users Rights

    I have a problem that im using Active Directory in Win2k Server, when domain users logon to workstations they can't open sql server databases, SQL server is local installed on Workstation and operating system is XP.

    When i give administrator rights to users the sql server works fine.

    Tell me is there is a way to use sql server without giving to the user administrative rights?


  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    You need to login as the account that the SQL Server is running in on their boxes (set up a SQL Server "account". You then need to go into SQL Server while logged in as this account and add Domain Users as a login in SQL Server and grant permissions. They can then login and do what they need to do.
    When life gives you a lemon, fire the DBA.

Posting Permissions

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