Jul 17

When i try to start the Sql Server (MSSQLSERVER) service, 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.

Hey, I have another solution. My event viewer said something about the Master database being compressed. I checked the data folder, and all database files were blue (meaning compressed, the ‘blue’ setting can be found in folder options). So I selected all files, right clicked, choose properties, clicked advanced and unchecked compressed attributes. After that, I could start the service.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Technorati
  • Twitter

Related posts:

  1. Northwind Database Installation
  2. Create Stored Procedure SQL Server
  3. Silverlight (Creating Hello World)

Leave a Reply