Windows could not start the SQL Server on Local Computer Error Code 3417
I havn’t been using SQL Server on my development machine for a while so to speed things up I changed the service startup to manual. Recently I’ve needed SQL Server but when I tried to start the service I got an error saying Windows could not start the SQL Server on Local Computer with the Error Code 3417. This was rather odd, so I started doing some google searched but with no direct answer other than people saying that there are issues with the master DB. As it turned out because i havn’t been using SQL Server (and hence the DB files weren’t being used) Windows has compressed these files to save space (They were coming up with blue colour in the file system). So I selected all DB and Log files in the C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA folder, went in Properties -> Advanced and unticked the “Compress contents to save disk space” checkbox. After this all files have turned black and I had no issues starting the service

I am getting error code 17051, SQL server 2008. How to solve this out please?
Sorry, that’s one you’re going to have to research yourself.