Solved

Windows Server that fails after power outage

Posted on 2015-01-19
7
128 Views
Last Modified: 2016-11-23
I have an issue at a client site that is driving me insane.

This client has a number of HP and Dell servers. They have an ESXi environment (2 hosts + shared storage).

The issue that is driving me insane is this:
Last year they installed Windows Server 2012 onto a Dell PowerEdge (2950)
They then installed SQL Server 2012
They setup their MSRS and other DB's

Then they had a power outage (< 5 minutes) in the building. They have a UPS but had not connected the newly built SQL server onto it.

Once the SQL server had come back on, they were not able to access the DB's or MSRS. So they called me in. The server showed the log on screen and all seemed fine. I was able to enter domain admin credentials and click Log On. And thats it. The log on never completed. Lots of hard boots but it never logged on. The server can be pinged by name and IP but nothing else works. No admin shares nothing.

I had to leave for the weekend. When I came back in to the client on the Monday, the log on was still taking place but showing the message that the copy of windows was not genuine. The client had a backup of all data so they rebuilt the server from scratch and restored the data.

One of their techs recommended a P2V to ESXi. They did a P2V of the server and ran it as a VM. It was not a heavily used SQL box.

A few months down the line another power issue occurred. This time it took down that VM. When the VM came back the exact same issues as described over occurred!!

One of their techs claimed that the issue was being caused by Server 2012. This was the only 2012 server they had. So the rebuilt the phyiscal PowerEdge with Windows Server 2008 R2 and put SQL Server 2012 on top. All worked fine.

Until last Friday. They had another power drop. I was called to site. Same deal. Log on screen shows fine. Domain Admin details entered fine. Then nothing. Looks like its loading. All the same symptoms as above.

Arrived this morning and this is showing:
2And again that server is showing:
1
Any ideas?
Thanks
Mark/
0
Comment
Question by:Mark Galvin
[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
  • 6
7 Comments
 
LVL 8

Expert Comment

by:nader alkahtani
ID: 40557407
this url just about Windows server 2008 and I don't know is it proper for you problem or what ?
https://support.microsoft.com/kb/2008385/en-us
0
 
LVL 13

Author Comment

by:Mark Galvin
ID: 40557459
Checking now. Will let you know outcome.
0
 
LVL 13

Author Comment

by:Mark Galvin
ID: 40557691
Hi

That GPO isn't applied. I have run the reg addition and rebooted the server.

I have entered the log in credentials and its sitting on this screen:
ApplyingUserSettings
Been like that for about an hour. Still cant browse admin shares so I dont think it worked?

Mark/
0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 13

Author Comment

by:Mark Galvin
ID: 40557806
One thing to note, I have a desktop background and nothing else. If send a CTRL ALT DELETE to the server I get the Security Screen and can launch Task Manager etc.
0
 
LVL 13

Author Comment

by:Mark Galvin
ID: 40561680
Update

Fired up MSCONFIG and put the server into Safe Mode with networking
Rebooted
Logged in fine
Fired up MSCONFIG
Disabled all non Microsoft services and did a clean boot

Server came up! Can access all SQL DB's, and can access admin shares. Everything working . Services we disabled were:
Disabled Services
We now need to enable each service and restart and see whats killing it!

Thanks
Mark/
0
 
LVL 13

Accepted Solution

by:
Mark Galvin earned 0 total points
ID: 40561751
Well, this is interesting.

Went through each provider in the list of disabled services. Enabled and restart each provider with a full server reboot after each provider's services were started. And the server is fine!

Client has connected the server to the UPS so this wont happen again.

Really perplexed as to why the server failed in the way it did AND how this mornings work has got it up & running (thumbs up!).

Going to request the question be closed.

Thanks
Mark
0
 
LVL 13

Author Closing Comment

by:Mark Galvin
ID: 40570189
Booted server into safe mode
Disabled all non Microsoft Services and rebooted the server
Server came up fine
Enabled each providers services in the services that were disabled above (and rebooted the server after each provider's service/s were enabled)

Server now up & running fine.

Thanks
Mark
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 article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

739 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