?
Solved

Sharepoint 2010 pings the external IP not the internal

Posted on 2013-05-29
4
Medium Priority
?
295 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month9 days, 11 hours left to enroll

609 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