SQL Server Performance

Remote IP Authentication

Discussion in 'SQL Server 2005 General DBA Questions' started by rootlk, Apr 17, 2008.

  1. rootlk New Member

    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.
    rootlk, Apr 17, 2008
    #2

  2. ghemant Moderator

    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!!
    ghemant, Apr 18, 2008
    #3

  3. johnson_ef Member

    johnson_ef, Apr 21, 2008
    #4

  4. satya Moderator

    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, Apr 21, 2008
    #5

Share This Page