Remote IP Authentication

Last post 04-21-2008 4:12 AM by satya. 3 replies.
Page 1 of 1 (4 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 04-17-2008 7:59 PM

    • rootlk
    • Not Ranked
    • Joined on 04-10-2008
    • Posts 3

    Remote IP Authentication

    Reply Contact

    I am a mySQL user. Recently changed to MS SQL. Could you please help me to sort out this. When I give remote permission to a database, I want to specify the remote IP address also to the user. In MySQL its there. How can i implement this is MS SQL.

    If connection comes from that IP only it should accept.
    Filed under:

  • 04-18-2008 2:26 AM In reply to

    Re: Remote IP Authentication

    Reply Contact

    Hi,

    Do you mean to restrict in-coming connection to specific IP Address(s) in SQL Server, if so you can have to set a firewall rule. AFAIK their is no such set of restriction available to SQL Server Configuration yet!!

    Hemantgiri S. Goswami | MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
    http://forums.surat-user-group.org/

    View Hemantgiri S. Goswami's profile on LinkedIn

    Disclaimer: This post is provided as is, for the sake of knowledge sharing only.

  • 04-21-2008 2:53 AM In reply to

    Re: Remote IP Authentication

    Reply Contact

    HI Hemant,

     I think we can use the restriction through EndPoints.

    I am not that sound in this area, but the topic which I read points about it (http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/)

  • 04-21-2008 4:12 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,567
    • Microsoft MVP

    Re: Remote IP Authentication

    Reply Contact

    It is not possible to restrict or allow a specific IP address to/fro SQL Server, as referred by Hemant only you could allow/deny such connections using FIREWALL API within your network. If you have no firewall then only best bet is to control the SECURITY permission on the database level.

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
Page 1 of 1 (4 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.