Post reply

Way to authenticate id, if coming from certain IP address SQL2k/2005 ?

  • May 15, 2007 at 7:01 pm

    #172500

    I have Sqlserver 2000 sp3. Is there a way in SQL Server 2000/2005 where I can restrict Sql/NT id to connect if it is coming from a certain IP address else not allow to connect ? Quick response is highly appreciated.

  • May 16, 2007 at 5:04 am

    #706722

    you would probably need to use some functionality on the host OS

    Everything you can imagine is real.

  • May 16, 2007 at 8:16 am

    #706807

    The only way is through network/firewall or an OS firewall limit. The IP coming through to SQL Server is submitted by the client and not necessarily the real IP. By default it is, but this could easily be spoofed.

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

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