SQL server 2005 express would not start

Go to Windows control panel -> Performance and maintenance -> Administrative tools -> Services ->right click on SQLEXPRESS -> Properties -> Under Logon tab check Local logon and allow interact with local services.

It the above doe not work then
go to my SQL Server data folder via windows explorer (mine was: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL), select all the files, right click, click advanced, UNCHECK, “Compress contents to save disk space”.

Leave a Reply

Your email address will not be published. Required fields are marked *