right click on sql server, select "property", in "connections" tab, tick "allow remote connections to this server".
right click on "My computer", choose "manage", in "services and applications->sql server configuration manager -> sql native client configuration -> client protocols", need to enable relative network protocols, should be "TCP/IP" and "named pipe".
these are for sql 2005, sql 2000 might be slight different