Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

Question

Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

Analyst_SQL 3,576

I am facing error when i am starting sql service
Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

what could be the issue.?

Shashank Singh 6,251 Reputation points

2020-09-22T16:27:24.663+00:00

Go to eventviewer and check in application and system logs. Look for MSSQL logs and find out the reason why it failed to start. Post the reason here.
Analyst_SQL 3,576 Reputation points

2020-09-22T18:28:12.897+00:00

MDF CURROPT ,giving alert
RatheeshKNair 6 Reputation points

2020-09-23T06:16:08.64+00:00

if MDF corrupt and SQL is not online , is it master database corruption? Try to start the in single user mode and rebuild the master , also you can try restoring the master from backup.
tibor_karaszi@hotmail.com 4,316 Reputation points

2020-09-23T09:10:07.247+00:00

Are you saying that below is literally what is days in the event log, and nothing else from when you try to start your SQL server?

MDF CURROPT ,giving alert

You need to be precise if you want good help. In addition to eventlog, also check the errorlog file for relevant error messages.

Accepted answer

1 additional answer

Your answer

Shashank Singh 6,251 Reputation points

2020-09-22T16:27:24.663+00:00

Go to eventviewer and check in application and system logs. Look for MSSQL logs and find out the reason why it failed to start. Post the reason here.
Analyst_SQL 3,576 Reputation points

2020-09-22T18:28:12.897+00:00

MDF CURROPT ,giving alert
RatheeshKNair 6 Reputation points

2020-09-23T06:16:08.64+00:00

if MDF corrupt and SQL is not online , is it master database corruption? Try to start the in single user mode and rebuild the master , also you can try restoring the master from backup.
tibor_karaszi@hotmail.com 4,316 Reputation points

2020-09-23T09:10:07.247+00:00

Are you saying that below is literally what is days in the event log, and nothing else from when you try to start your SQL server?

MDF CURROPT ,giving alert

You need to be precise if you want good help. In addition to eventlog, also check the errorlog file for relevant error messages.

Answer 1

Hi @Analyst_SQL ,

what could be the issue.?...MDF CURROPT ,giving alert

There are many casues for Error 3417, please reference this doc. to fix this error: how-to-resolve-sql-server-error-3417

And if your mdf curropt, please firstly execute code:

DBCC CHECKDB

And then you can reference this doc to repaire your mdf files: how-to-repair-mdf-file-in-sql-server-database

BTW, do you have any backup files? If yes, you can restore your backup files.

More information : dbcc-checkdb-transact-sql,quickstart-backup-restore-database

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Tom Phillips 17,771

That is a generic "failure to start service" message and in no way helps diagnose the actual problem. Please look at the system event log for the actual error.

Share via

Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

1 additional answer

Your answer