Solved

Windows Server that fails after power outage

Posted on 2015-01-19
7
124 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
  • 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Viewers will learn how the fundamental information of how to create a table.

809 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