Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    30

    Exclamation Unanswered: Access restriction

    I want to access mssql2000 server only by 'sa' & database login ids. I want to restrict windows administrator account to access the database. Please help !!!

    Our enviorment :- SQL2000 with SP3 on Windows2000 advanced server with latest service pack..

  2. #2
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    Create new login under the Logins node in EM and add "domain Admins" group. Select "Deny Access" under the Authentication option.
    You can also restrict the group to individual databases by adding it in a particular database and assinging it specific roles(deny datareader,deny datawriter) etc.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the SQL Server Agent running under?

    Builtin\Admin?

    In that case it will have sa rights..

    You need to create a new account, give it sa, change the sql server agent to run with that

    And remove auth to builtin...builtin still needs to be around to start up the box....

    Oh and buy the book SQL Server 2000 ADMIN 911

    Talks all about it...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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