1) make sure, using the sql network utility that you have TCP/ip active on
the MSDE and where the ADP is.
2) you can connect because you are using pipe which uses NT authorization.
3) TCPIP only uses SQL userID'
4) you can play with multimode, but I don't recommend designing around it.
5) in your ADP when you are using TCPIP use the IP addressees as the server
name.
6) make sure any firewall allow both port 1434 and 1433.
7) I believe MSDE 2K uses one other port.
8) 255.255.255.255 is a broadcast to find any thing listening on port 1434.
sort of like an autofind.
9) *.sql are only use to make a DB in the sQL server. after that, they
server no function.
10) open the query analyzer and load the SQL file. I am not sure if it has a
make DB command in it.
11) if not create the DB then use the Drop down in the query analyzer to
select the DB you want to run the sQL script against.

Welcome to many winter hours of enjoyment as you trek up the SQL server
learning curve.