I was trying to do a database migration from one server to another server. So in my development server i first did a trial. Now since this was a trial before it goes to production im now suppose to roll back and keep the dev configuration as it is. So to achieve this. I did the following:
- Stop all sharepoint services.
- Iisreset /stop.
- Attached the dev DB server using SQL.
- TCL/IP config checked the server details.
- Start all sharepoint services
- Start iisreset
Now there is 3 issues after this.
- Central admin opened fine. But no configurations im able to do. Including creating a new web application.
ERROR MESSAGE: THE NETWORK PATH NOT FOUND.
Site is not opening with default.aspx page. I went to sharepoint designer and opened the page defauly.aspx and did a web checkout check in. But still not working. But other pages also not opening as such.
The subsites are not upto dated once. There was a major subsite created in development which is missing in this site content section. BUT WHEN I CHECKED THE DATABASE OF THIS DEV SERVER IN TABLE ALLWEBS I CAN SEE THE SUBSITE ALREADY EXISTS THERE. BUT ITS JUST NOT READING.
Additional error messages from Log is for reference:
SqlError: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)' Source: '.Net SqlClient Data Provider' Number: 53 State: 0 Class: 20 Procedure: '' LineNumber: 0 Server: ''