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. Install Windows XP Service Pack 3 (SP3)
  2. Missing Microsoft SQL Server Management Studio
  3. Northwind Database Installation
  4. Create Stored Procedure SQL Server
  5. Silverlight (Creating Hello World)

Leave a Reply