Tem 10 2009

Cannot start SQL Server service + SQL Server 2005 Error 3417

Category: SQL Server 2005Latif @ 22:57

Hi,

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.

See you...

 

Tags: