Adding SQL Server Compact 4.0 (CE) support to Visual Studio 2010 SP1

I just noticed that SQL Server Compact 4.0 tooling is not installed along with Visual Studio 2010 SP1 by default. 

Ofcource you can still make a SQL Server Compact 4.0 database using the latest build of EntityFramework from Nuget and using Code First development. However if you try to open the generated sdf file from Visual Studio you get the error "The operation could not be completed. Unspecified error" as shown : 

To fix this you can either install "Visual Studio 2010 SP1 Tools for SQL Server Compact 4" from the Web Platforms Installer or use the offline installer available here : http://go.microsoft.com/fwlink/?LinkId=212219 

Enjoy!

Recovering a Report Server when you have SQL Server rights

Simply change the executing service account of your report server. Make sure that account has full access to sql server. Afterwards login with that account and access your Report Manager URL. Simple isn't it?

You might need to restart the machine for it to work though :)