Thursday, October 25, 2012

SQL Server 2005 Expess – How to fix error 3417


Error:
The SQL Server service could not be started.
I have been getting the error 3417 (SQL Server service terminated with service-specific error 3417…).There was also a reference to the mastlog.ldf file, which is the Master’s database log file.
The database files usually reside on a folder like “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data”. Therefore I checked that the master.mdf and mastlog.ldf were present.

Solution; 

All I had to do, was to add on the “Data” folder (mentioned above) security/permission settings, the “NETWORK SERVICE” account.

No comments: