Home : Products : Cannot connect to SQL Server 2008 with IP4 Address
Q13597 - HOWTO: Cannot connect to SQL Server 2008 with IP4 Address

More symptoms and solutions for connecting to SQL Server 2008. Other articles for similar problems can be found at:

KB Article Q13357 - Troubleshooting connectivity issues between the Hach WIMS Client and MS SQL Server

KB Article Q13487 - Can Ping/Connect, But Cannot Get Data When Source is on Microsoft Windows Server 2008

 

Symptom: On the server I can get a good connection, using UDL, to localhost\sql2008 (where sql2008 is my SQL instance). I open a command prompt and enter IPCONFIG to see that my IPv4 Address is 10.128.131.51. When I use 10.128.131.51\sql2008 I get an error message stating that the instance does not exist.

When I ping localhost from the command prompt we see:  ...ping statistics for ::1: - which implies IPv6. I open up SQL Server Configuration Manager and navigate to SQL Server Network Configuration > Protocols for SQL2008 (where SQL2008 is my instance name). Right click on TCP/IP and select Properties.

Click on the IP Address tab and on our installation we show 11 IP listings. I found that IP2 had an IPv4 address already, so I Activated it and Enabled it. Also, make sure the IP Address is correct - mine was different than the actual IP address of the virtual machine.

Now click Apply and OK, it will tell you that you need to restart the services - so I restarted them and retest the UDL. It worked perfectly. Hope this helps you! 

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 11/1/2011 11:17 AM.
Last Modified on 11/1/2011 2:15 PM.
Last Modified by No Author Name Available!.
Skill Level: Advanced.
Article has been viewed 13192 times.
Rated 3 out of 10 based on 17 votes.
Print Article
Email Article