I am having a server on which currently SQL Server 2000 is installed. We remotely connect to this server by specifying its IP and Port number.
Now we want to install a new instance of SQL Server 2005 on this. The main requirement is to keep the old SQL Server 2000 intact and install new SQL Server 2005 on the same server.
Now I want to know that in doing so, will we be able to connect SQL Server 2005 with the same IP and Port number?
What changes I have to make to my connection string to connect to this new Instance of SQL Server 2005?
If IP and Port number are going to change, then where I need to modify them so that I be able to connect to SQL Server 2005 using the earlier IP and port number.
Thanks in advance.