I decided not to use SQL Server 2000. Instead I used SQL Server 2005 Express. SQL Server 2005 Express was much easier to install since it had a GUI interface. When using the “ODBC Database Source Administrator”, I got to the “Microsoft SQL Server DSN Configuration” window. When I clicked next I got the follow message:

Connection failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
Connection failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Native Client]Login timeout expired
Connection failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

I looked at the documentation on the internet for this type of problem. All of it talks about how to allow remote connections. I do not have any remote connections. I just have one stand alone PC. I did all that stuff to allow remote connections any ways to see if that helped. It did not. Does anyone have any ideas?