SQL 2005 Configuration and setup..

I have a dedicated server, that I host a couple of games on. I am trying to move my current website (www.coldheartedkillers.com) over to the new server.

Currently, my old server has SQL2000. I have backed up the SQL database, will it be possible to restore the database in SQL2005?

But before I go and restore the database in SQL2k5, I need to know how to properly configure it. I have it setup according the guide on this website "Configuring SQL2005 Express". All of the commands worked fine.

The problem I'm having is when I try to connect to the server, it refuses to work completely. I can't connect to the SQL server at ALL.

I have installed SQL Express Manager "Preview" program. In the SQL Express Computer Manager (the snap-in thing) I have TCP connected for the IP I want it to be.

There is no port set, but the "TCPDynamicPorts" has a default port enabled.

I have enabled: Shared Memory, TCP/IP, Named Pipes, VIA under "Client Protocols".

I have SM, NP, and VIA disabled under "PROTOCOLS FOR SQL EXPRESS". I have TCP enabled. Even when everything is enabled, I can't connect to the server. I get the error: "Cannot find server. Please ensure server is running."

Thank you!

I'd feel less suicidal if someone would respond.. !

I fixed it, but I don't know how to restore the database to the new database..

Hey tmack, I've faced the same problem... no way to get SQL 2005 working... would you mind sharing how you fixed it ?
Thanks