SQL Native: Connection refused by using IP

SQL Native: Connection refused by using IP

• Vitali Greenberg

  This tool is located under:

  Start Menu -> Programs -> Microsoft SQL Server 2005 -> SQL Server Surface Area Configuration.

  SQL Server Configuration Manager is located in the same spot. I have multiple network connections (ie. network cards) on my machine, and this interfered with my host name resolution in the past too. If you continue to experience problems after enabling remote access (in the SQL Server Surface Area Configuration tool), try using a different network protocol (eg. TCP/IP vs Named Pipes). One thing that I did to enable resolution in my case was to set up an alias for my machine with exactly the same name as my machine:

  1. Open SQL Server Configuration Manager
  2. Navigate: SQL Server Configuration Manager -> SQL Native Client Configuration -> Aliases.
  3. Right-click -> New Alias
  4. In "Alias Name" and "Server", set the name of your machine (eg. MYMACHINE)
  5. I used Named Pipes for this

  
  
  

• Loge

  I've found the solution, in fact SQL Browser was not running so know i can use IP Adress to connect to SQL Server 2005.

  Thks

  
  

• jennie44752

  It doesn't work from where SQL Server has been installed and from another computer, both by using an IP adress.
  

• lufa

  It still doesn't work.

  I made a netstat -n and i got:

  TCP 192.168.1.4:1159 168.95.192.1:53 TIME_WAIT
  TCP 192.168.1.4:1168 168.95.192.1:53 TIME_WAIT
  TCP 192.168.1.4:1177 128.63.2.53:53 TIME_WAIT
  TCP 192.168.1.4:1181 192.33.4.12:53 TIME_WAIT

  Port 1433 is not indicated so why

  
  

• Tiago_mor

  >> But in the 2nd case i cannot connect to SQL Server from another computer.
  Do you mean you can connect to SQL Server from another computer using 192.168.1.2\MYDATABASE
  
  
  

• Eyes

  You will need to configure to allow remote connection via the Surface Area Config
  
  
• SQL Native: Connection refused by using IP