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:

Comments

1.
how to create a website how to create a website United States says:

Abroad, modified cars long, first appeared in the modified car to better participate in the competition, drag racing, like so many people have converted their car engines,. Strict standards and excellence in service is what made Cullitons the premiere limo service of choice for thousands of Torontonians as well as visiting guests from all over the world. Access Free Online Maps via Wi - Fi or 3G network, such as Google Map.