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:
[code=markup]<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>
[/code]
Is this a permission error or a problem with file location, I think it will amount to the same thing.
Posted by: Lemonde - 09 August 2019 09:52:15
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:
[code=markup]<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>[/code]
Posted by: Lemonde - 09 August 2019 10:15:19
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"
[img=https://www.sircles.net/downloads/sql3417-1.png]SQL Startup error 3417[/img]
I had accidentally pointed it to the wrong drive :(
All's well that ends well :)
Posted by: berkscompsltd - 29 July 2024 11:33:31
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.
