hmm i had that problem ages just unistall and reinstall thats what I did.
Can anyone help me i've got a ded server with all the IP"S connected to the client but it says Cannot Connect, im using a csv client.
go to your win service manager, and try to mees with the sql-server service.
and everybody saying that it has nothing to do with the service= you're wrong!
the service isn't running!! so the first thing to do, is to get the service running!
log in as admin, and try to start the service.
believe me, it will work somehow activating that service.