Results 1 to 2 of 2

Thread: SQL 2000 security

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    SQL 2000 security

    Can anyone help or advise on the following: -

    1) setting the number of login attempts and locking a sql login

    2) Setting a SQL login to be only valid against a given Ip address.

    thx
    Tim

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,931
    You can't do it directly from SQL Server

    1. You can change the property of sql server to use Windows authentication only, this way lock out is managed by Windows.

    2. You can set property of the login ID in Windows to restrict the workstation. Again you have to use Windows security at SQL Server level.

Posting Permissions

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