• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 496
  • Last Modified:

Sharepoint Main Site will not connect after IP Changes

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
NDGISupport
Asked:
NDGISupport
  • 5
  • 5
1 Solution
 
Justin SmithSr. System EngineerCommented:
I'm assuming you updated DNS, right?
0
 
NDGISupportAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
ARe all your SharePoint URL's using server names?

Can the workstations ping the url's and get the proper IP?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
NDGISupportAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
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
 
NDGISupportAuthor Commented:
No all settings use the url of the servers.
0
 
Justin SmithSr. System EngineerCommented:
Are you using host file entries or sql alias on the sharepoint box?
0
 
NDGISupportAuthor Commented:
sql alias
0
 
NDGISupportAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now