Share via

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,551 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.
13,361 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 questions
Accepted answer
  1. m 4,271 Reputation points
    2020-09-23T04:23:04.827+00:00

    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.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,721 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.

    1 person found this answer helpful.
    0 comments