How to install second instance of SQL server 2000 on the same machine?

I want to install a second instance of SQL server 2000 on the same machine(running windows server 2003) but every time i install the second instance I cannot have connection to it from any client although I can have access to it from the server itself

what should I do to make the second instance work?

should I change anything in the parameters of the instance? maybe changing the port or maybe changing the destination of the program files when installing the instance to make it different than the the default instance program files??How to install second instance of SQL server 2000 on the same machine?
You shouldnt need a second sql server instance running, so im not sure why you are trying. You more than likely will need to change the port as that will be application specific...dont forget to allow any port forwarding through firewalls and routers. You could also try a different sql software like MySql from http://www.mysql.com , its free and powerful.How to install second instance of SQL server 2000 on the same machine?
No you do not need to change the port which the named instance is listening to, this is totally uncalled for.



This is how you should proceed to install a named instance.

http://msdn2.microsoft.com/en-us/library



Additional useful links

http://msdn2.microsoft.com/en-us/library

http://msdn2.microsoft.com/en-us/library

http://msdn2.microsoft.com/en-us/library



Hope this helps.