For SQL server 2000 you can change port that SQL is listening (default 1433) with Server Network Utility.

If you're using Microsoft SQL Server 2005, you have to go to SQL Server Configuration manager, open up SQL Native Client Configuration, choose Client Protocols, doble-click on TCP/IP and change the default port to whatever you need.