I couldn't possibly tell you what to do without knowing what errors are involved. Check the SQL Server error logs. In Management Studio, expand the management box and it's under SQL Server logs
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" - Theodore Roosevelt