Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Windows Server that fails after power outage

Posted on 2015-01-19
7
Medium Priority
?
138 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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 to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

963 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