Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i am using sql server 2005.

my system is connected in network.

i want to give access to my sql server to specific person(IP) in the network and other persons should not access.

please solve this issue.

thanks in advance.

share|improve this question
    
"network" is LAN or WAN? If it is LAN, TomTom answer is right. –  lg. Sep 17 '10 at 13:10

2 Answers 2

It starts with reading the documentation.

  • Give the user a login, protected by a password
  • Grant this login rights to the databases the user should access
  • Give user the login and password.

Finished.

share|improve this answer

As TomTom indicated, the person will need a login. If both of you are on the domain (internal network), this is usually best accomplished by giving access to the person's Windows user account rather than a SQL Server login.

If you definitely need to restrict down to a specific IP, SQL Server has no built-in functionality for that. With SQL Server 2005 SP2 and greater you could build a logon trigger, but that can be problematic. Your best bet is to look into building an IPSEC policy that locks down your SQL Server access remotely to that specific IP address.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.