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

Question

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

Answer 1

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/aa197928(SQL.80).aspx



Additional useful links

http://msdn2.microsoft.com/en-us/library/Aa176582(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa174516(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa176583(SQL.80).aspx



Hope this helps.

Answer 2

You need to configure the second instance to use a different port. This is not a good way to work, better ids to use one instance, and 2 separate databases. You can isolate their security. 2 instances is a very heavy load on the machine, and means you need your applications set to access the second port.

Answer 3

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.