Post reply

Is it allowed to block certain ip address in linked server?

  • August 9, 2009 at 8:01 am

    #208367

    Is it allowed to block certain ip address in linked server?

    if it is allowed, how can I do that?

  • August 9, 2009 at 8:36 am

    #1036481

    you can prevent certain logins from having access to any linked servers you create, but not by IP address; typically, if you want to block IP's you do that at the operating system level, or at a router(preventing ranges of IP's from having access to services offered by your server)

    remember you can connect to SQL server via named pipes, so you wouldn't have an IP address available anyway.

    As far as i know, there is no way to query a spid/connection, and get it's IP address directly; i know the hostname() is available, and you could lookup an IP related to the hostname, but that would require hitting PING or NSLOOKUP from the command window; never seen the IP as part of any SQL table to verify against.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply