Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Windows Server that fails after power outage

Posted on 2015-01-19
7
Medium Priority
?
131 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

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 ?
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
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…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

718 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