Lemonde
  • Lemonde
  • 100% (Exalted)
  • Advanced Member Topic Starter
5 years ago
SQL server start-up error 3417

Event log:

Log Name: System
Source: Service Control Manager
Date: 09/08/2019 09:36:25
Event ID: 7024
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: %computername%.domain.local
Description:
The SQL Server (MSSQLSERVER) service terminated with the following service-specific error:
WARNING: You have until SQL Server (MSSQLSERVER) to logoff. If you have not logged off at this time, your session will be disconnected, and any open files or devices you have open may lose data.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="49152">7024</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2019-08-09T08:36:25.663793200Z" />
    <EventRecordID>3518</EventRecordID>
    <Correlation />
    <Execution ProcessID="624" ThreadID="3700" />
    <Channel>System</Channel>
    <Computer>%computername%.domain.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name="param1">SQL Server (MSSQLSERVER)</Data>
    <Data Name="param2">%%3417</Data>
    <Binary>4D005300530051004C005300450052005600450052000000</Binary>
  </EventData>
</Event>
Is this a permission error or a problem with file location, I think it will amount to the same thing.
Refurbished Computers Berkshire 
Data Recovery Berkshire 
Sponsor

Want to thank us? Use: Patreon or PayPal or Bitcoins: bc1q4whppe29dw77rm4kv4pln0gqae4yjnxly0dny0hky6yhnafukzjsyrsqhk

All opinions expressed within these pages are sent in by members of the public or by our staff in their spare time, and as such do not represent any opinion held by sircles.net Ltd or their partners.

Lemonde
  • Lemonde
  • 100% (Exalted)
  • Advanced Member Topic Starter
5 years ago
After jiggin' the positions of the files

(this was a restore from another SQL server)

I now have this error instead - I am pretty convinced it is just the file locations of the model and MS DBs in the registry and the model.mdf DB that are causing the issue:

Log Name: System
Source: Service Control Manager
Date: 09/08/2019 09:50:09
Event ID: 7024
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: %computername%.domain.local
Description:
The SQL Server (MSSQLSERVER) service terminated with the following service-specific error:
WARNING: You have until SQL Server (MSSQLSERVER) to logoff. If you have not logged off at this time, your session will be disconnected, and any open files or devices you have open may lose data.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="49152">7024</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2019-08-09T08:50:09.697965800Z" />
    <EventRecordID>3529</EventRecordID>
    <Correlation />
    <Execution ProcessID="624" ThreadID="4304" />
    <Channel>System</Channel>
    <Computer>%computername%.domain.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name="param1">SQL Server (MSSQLSERVER)</Data>
    <Data Name="param2">%%3417</Data>
    <Binary>4D005300530051004C005300450052005600450052000000</Binary>
  </EventData>
</Event>
Refurbished Computers Berkshire 
Data Recovery Berkshire 
Lemonde
  • Lemonde
  • 100% (Exalted)
  • Advanced Member Topic Starter
5 years ago
This was actually due to the logfile destination under the registry here:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQLServer\Parameters]
"SQLArg0"="-dF:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\master.mdf"
"SQLArg1"="-eF:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Log\\ERRORLOG"
"SQLArg2"="-lF:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\mastlog.ldf"

UserPostedImage

I had accidentally pointed it to the wrong drive :(

All's well that ends well 🙂
Refurbished Computers Berkshire 
Data Recovery Berkshire 
berkscompsltd
4 months ago
Just as a not, when you are exporting a server with disk2VHD you MUST use VSS for SQL servers or all of the logfiles will be out of sync. and thew databases will not function.
Similar Topics
Users browsing this topic