 | |
#41
 
| |||
| |||
|
Re: Event ID 17055 (18052 Error:826) -
07-30-2008
, 10:26 AM
|
Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#42
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#43
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#44
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#45
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#46
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#47
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#48
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#49
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
#50
| |||
| |||
|
|
Nope, that's pretty much everything. Paul "Tom Moreau" wrote: Anything in the SQL Server errorlog - beyond what you have posted? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Paul Essick" <PaulEssick (AT) discussions (DOT) microsoft.com> wrote in message news:4F8A504E-75F9-482D-ABA7-2C88D1EB1D41 (AT) microsoft (DOT) com... Services are set correctly. Disk resources are on the node and accessable. The service starts and then immediately stops when attempting to start from Services. "Geoff N. Hiten" wrote: 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 in message news:4663F384-404F-4931-824B-40817E185394 (AT) microsoft (DOT) com... 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 |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.