SQL Native: Connection refused by using IP

Question

Hi!!!

I got a problem, if i try to connect with SQL Native client by IP (exemple: 192.168.1.2\MYDATABASE) it doesn't work. But I use: HOME\MYDATABASE it works. But in the 2nd case i cannot connect to SQL Server from another computer.

 

Thanks fr your help.

 

fred

Answer 1

>> 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 ?

Answer 2

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

Answer 3

You will need to configure to allow remote connection via the Surface Area Config

Answer 4

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

Answer 5

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 ?

Answer 6

 

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