[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sharepoint Main Site will not connect after IP Changes

Posted on 2011-09-22
10
Medium Priority
?
489 Views
Last Modified: 2013-11-29
We have upgraded out network switches and changed the IP address of the main sql server and SharePoint server. We can connect to the central admin site but no the main portal site.SharePoint server can ping SQL server. Any help would be appreciated.

Thanks
0
Comment
Question by:NDGISupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 36579911
I'm assuming you updated DNS, right?
0
 

Author Comment

by:NDGISupport
ID: 36579955
Yes, updated DNS records for the server and sql. I can log into the main site on the sharepoint server itself but not from any other workstations. Also can access central admin but not the shared service provider created for the site.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 36580002
ARe all your SharePoint URL's using server names?

Can the workstations ping the url's and get the proper IP?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:NDGISupport
ID: 36580058
Yes, i can ping the server url and it returns the correct IP address. When i try and connect froma workstation i receive: Unable to connect to database.  Check database connection information and make sure the database server is running.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 36580103
That is odd since you say you can access it from the server.  

When you deployed the web app, you didn't specifiy an IP for the SQL server did you?  
0
 

Author Comment

by:NDGISupport
ID: 36580111
No all settings use the url of the servers.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 36580137
Are you using host file entries or sql alias on the sharepoint box?
0
 

Author Comment

by:NDGISupport
ID: 36580145
sql alias
0
 

Author Comment

by:NDGISupport
ID: 36581007
Now i m receiving the below mesaage:

HTTP/1.1 404 Connection: close Date: Thu, 22 Sep 2011 14:41:08 GMT Server: Microsoft-IIS/6.0 MicrosoftSharePointTeamServices: 12.0.0.4518 X-Powered-By: ASP.NET
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 2000 total points
ID: 36581689
I've changed ShaerPoint related server IP's many times.  As long as you are just changing IP's and not computer names, the only issue you should have is related to DNS.  If you get DNS straightened out, the farm just works.  

Exceptions include HOSTS files and specifying IP addresses on things like SQL Server (web app config) and email server.  

I'm just a little confused on your issue since you say you can load Central Admin no problem.  This shows that the front end servers can successfully find the SQL Server and the config db.  So in theory, all your web apps should be able to as well.  

If you create a new web application, does the db get created in SQL?

Did you do server restarts or IIS restarts after the IP changes?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is the first one of a series of articles I’ll be writing to address technical issues that are always referred to as network problems. The network boundaries have changed, therefore having an understanding of how each piece in the network  puzzl…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Suggested Courses

650 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