Event ID 17055 (18052 Error:826)

#1

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find anything
on this specific error.

Thanks,
Paul

#2

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#3

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#4

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#5

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#6

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#7

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#8

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#9

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul

#10

Sounds like the MSSQL service is set to start up automatically. A clustered
SQL service should be set to Manual start. The Cluster service handles
starting and stopping the actual SQL services. SQL likely failed because
its disk resources were not online on Node 1.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote

Quote:

Lost power on the active node of my SQL Server. It failed over to Node 2
without problem, but when I brought it back to Node 1 (the server that
lost
power) I get Event ID 17055
Error Description 18052
Error 826
Severity 22

The MSSQLServer service trys to start and then stops. I can't find
anything
on this specific error.

Thanks,
Paul