I realise this question was posted was some time ago, but I had the same issue recently, starting up MSSQL 2005 SP2. Basically my problem was that the MSSQL service system account did not have the correct privileges assigned to it. Once admin rights were administered, MSSQL started correctly. Hope this helps someone.

Sam