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

akhter hussain 2,491 Reputation points
2020-09-22T15:58:54.987+00:00

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.?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,502 questions
{count} votes

Accepted answer
  1. Miamiao-MSFT 4,216 Reputation points
    2020-09-23T04:23:04.827+00:00

    Hi @akhter hussain ,

    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.

    No comments

1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,511 Reputation points
    2020-09-22T18:25:46.087+00:00

    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.

    No comments