Thursday, October 25, 2012

Cannot start SQL Server service + SQL Server 2005 Error 3417


When I try to start the Sql Server (MSSQLSERVER) or  Sql Server (SQLEXPRESS) services, get the following error :

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.
After that, I looked at eventvwr. This is the error.
The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

SOLUTION :
Go to the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ and select all the files
and right click advanced, uncheck, “Compress contents to save disk space”.
That`s it,piece of cake. Now you can start the services. Try it.

No comments: