logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Lemonde  
#1 Posted : 09 August 2019 09:39:41(UTC)
Lemonde

Rank: Advanced Member

Groups: Registered
Joined: 08/01/2017(UTC)
Posts: 354
United Kingdom
Location: London

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.
Sponsor
Lemonde  
#2 Posted : 09 August 2019 09:52:15(UTC)
Lemonde

Rank: Advanced Member

Groups: Registered
Joined: 08/01/2017(UTC)
Posts: 354
United Kingdom
Location: London

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>
Lemonde  
#3 Posted : 09 August 2019 10:15:19(UTC)
Lemonde

Rank: Advanced Member

Groups: Registered
Joined: 08/01/2017(UTC)
Posts: 354
United Kingdom
Location: London

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"

SQL Startup error 3417

I had accidentally pointed it to the wrong drive :(

All's well that ends well :)

Edited by user 09 August 2019 10:33:20(UTC)  | Reason: Not specified

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.