Current Position:Home > Site does not load after some minutes of creation or after restart the server

Site does not load after some minutes of creation or after restart the server

Update:10-11Source: network consolidation
Advertisement
Hello,
I have been asked to create a test enviroment identical to the production enviroment. So, what I did was:
Backed up the production web application's content database: Prod_WSS_ContentDB
Created new test servers (domain controller, sql server and sharepoint 2013 server) in a new, completely isolated, network environment, without any connection with the production environment (specifically Azure)
Created a new web application in test environment with a new content database.
Dismounted the new content database with powershell: Dismount-spcontentdatabase Test_WSS_Content
Copy the Prod_WSS_ContentDB database to the test sql server and restored it with Management Studio.
Mount the Prod_WSS_ContentDB databe to the web application with powershell:
Mount-spcontentdatabse Prod_WSS_ContentDB -WebApplication http://testsp/
Then, when I type http://testsp in the browser it redirects me to http://testsp/SitePages/Home.aspx
and the site loads exactly as the production environment.
But, after some minutes, or if I restart the Sharepoint Server, when I navigate to
http://sitesp I am redirected to http://testsp/SitePages/Home.aspx
as expected, but the site does not load, the browser just show a complety blank page.
The Central Administration site loads normally.
Trying to fix it I found that if I dismount the content database Prod_WSS_ContentDB, then mount the test database Test_WSS_Content,
then navigate to the site, dismount Test_WSS_Content and finally mount again Prod_WSS_ContentDB, the site loads normally, no blank page, but after some minutes or if I restart the same happens again.
For the error event I receice in event viewer it seems that the problem is related to database. I have not found a solution for this error... How can I solve  this?
The error is:
Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          6/27/2014 2:44:22 PM
Event ID:      5586
Task Category: Database
Level:         Error
Keywords:      
User:          UCETEST\spaccount
Computer:      TESTSP01.ucetest.edu.do
Description:
Unknown SQL Exception -2146893055 occurred. Additional error information from SQL Server is included below.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <EventID>5586</EventID>
    <Version>15</Version>
    <Level>2</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2014-06-27T14:44:22.743159500Z" />
    <EventRecordID>4742</EventRecordID>
    <Correlation />
    <Execution ProcessID="1688" ThreadID="1692" />
    <Channel>Application</Channel>
    <Computer>TESTSP01.ucetest.edu.do</Computer>
    <Security UserID="S-1-5-21-2552298216-324766354-3392103171-1108" />
  </System>
  <EventData>
    <Data Name="int0">-2146893055</Data>
    <Data Name="string1">A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid)</Data>
  </EventData>
</Event>
Melvintt
MCTS, Windows Server 2008 R2: Network Infrastructure
MCTS, Windows Server 2008 R2: Active Directory, Configuring

The Best Answer

Advertisement
Hi,
According to your post, my understanding is that Site does not load after some minutes of creation or after restart the server.
Please make sure you create a test environment for existing production site correctly.
Here are some great articles for your reference:
Moving content between SharePoint environments
Copy SharePoint production data to a test environment
Build a SharePoint 2010 Test/Development Farm
Best Regards,
Linda Li
Linda Li
TechNet Community Support
Hello Linda Li,
I follwed that steps to create my test enviroment... and I have recreated it some times using that same steps, but the problem persits. After some minutes or after I restart the SharePoint server the site does not load.
Melvintt
MCTS, Windows Server 2008 R2: Network Infrastructure
MCTS, Windows Server 2008 R2: Active Directory, Configuring