Solved

Sharepoint 2010 pings the external IP not the internal

Posted on 2013-05-29
4
246 Views
Last Modified: 2013-06-14
I've been getting those sharepoint errors in the event log saying it cannot connect to the SQL server. So I thought I might try to ping it and when pinging the hostname, it came back with the external IP address outside the firewall which some people call the public IP address. I can ping the internal IP but when I ping the hostname, it returns with no response.

I added an entry for the sql server to the hosts file and to the Lmhosts file. First I checked the DNS server and found the appropriate entry there so that was really puzzling.

Is there something I am missing here? Sometimes it finds the other machine and sometimes it does not. Anyone seen this before?
0
Comment
Question by:garyoh
  • 3
4 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39207133
Hi,
sorry I am a bit confused. What server did you ping with the hostname? The SQL or the SharePoint frontend server?

In general a PING is not a good indicator if a server is reachable as most firewalls (either dedicated or the Windows integrated one) block ICMP packages, because thats the first entry point for scaning tools.

What is your SharePoint farm configuration (dedicated SQL server, how many SharePoint frontend / app server), what SharePoint edition do you use?

Does SharePoint work in general?
Thanks and HTH
Rainer
0
 

Author Comment

by:garyoh
ID: 39208674
Well, ping is good in that it shows the IP address the ip address the name resolves to.  This provided the info which I used. And so far, it works just fine. The error in the logs is not back.

I am using sharepoint 2010 as stated above and there is a dedicated Hyper-v slice for the SQL 2005 or 2008....probably 2008 but I am not in front of machines right now. There is one instance of sharepoint 2010 on another Slice as well. Hope that helps. Machine is up now for over 12 hours...great news!
0
 

Accepted Solution

by:
garyoh earned 0 total points
ID: 39233834
I'll live with the LMhosts answer I tried. It works and I am up for over a week know.
0
 

Author Closing Comment

by:garyoh
ID: 39247020
I was able to get this on my own.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
This video discusses moving either the default database or any database to a new volume.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now