Results 1 to 3 of 3

Thread: Mac Address

  1. #1
    Join Date
    Jul 2005
    Posts
    9

    Unanswered: Mac Address

    Hello,
    I want to block certain mac address to access my MS-SQL server. for that what can i do. for example
    I want to block the mac address [abc]. how is it possible to block the mac address [abc]

  2. #2
    Join Date
    Jan 2006
    Location
    Singapore
    Posts
    47
    Use a firewall. You can't do it from MS SQL Server
    -----------------
    KH


  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Or from a router on the network, a sample:
    To determine the corresponding IP address for this MAC address, run the following DOS networking command in a DOS window:
    arp -a
    This displays the IP address of all connected machines.
    Match up the net_address value from the sysprocesses query (step 1) with the corresponding Physical Address in the arp -a results (step 2) to determine the IP address corresponding to the Physical Address is the IP address of the machine running the blocking process. To find the corresponding hostname of this machine, run the following DOS networking command in a DOS window:
    ping -a <IPaddress>
    In the command above, <IPaddress> indicates the IP address identified with the arp -a command.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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