Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of Mark Galvin
Mark GalvinπŸ‡¬πŸ‡§

Windows Server that fails after power outage
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:
User generated imageAnd again that server is showing:
User generated image
Any ideas?
Thanks
Mark/

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of nader alkahtaninader alkahtaniπŸ‡ΈπŸ‡¦

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

Avatar of Mark GalvinMark GalvinπŸ‡¬πŸ‡§

ASKER

Checking now. Will let you know outcome.

Avatar of Mark GalvinMark GalvinπŸ‡¬πŸ‡§

ASKER

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:
User generated image
Been like that for about an hour. Still cant browse admin shares so I dont think it worked?

Mark/

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of Mark GalvinMark GalvinπŸ‡¬πŸ‡§

ASKER

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.

Avatar of Mark GalvinMark GalvinπŸ‡¬πŸ‡§

ASKER

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:
User generated image
We now need to enable each service and restart and see whats killing it!

Thanks
Mark/

ASKER CERTIFIED SOLUTION
Avatar of Mark GalvinMark GalvinπŸ‡¬πŸ‡§

ASKER

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of Mark GalvinMark GalvinπŸ‡¬πŸ‡§

ASKER

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

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.