You said this was an upgrade. If 6.5 is currently running, that would definitly cause a problem. Most of the time this is a security issue. Use the services applet in the control panel to configure the MSSQLService to use the local system account.
What happens if you try launching sql server from the command line. Open a command window and issue type sqlservr at the prompt.
-Mike