i am new to sql server so please guide me in this real time situation. i am having one SQL Server installed all ready on my live Server and its running fine. we are installing a new instance of SQL Server 2008 R2 and then will move few databases
from 2005 to 2008. presently our few application pointing to SQL Server 2005 (default IP :1433).
now let me know if install New SQL Server of version 2008, this will also be cofigure on default IP 1433 on which sql server 2005 is allready running. so how my application will identify that which server it should point (2005 or 2008) do
i need to mention Instance as well in my application config file for pointing database recently migrated to 2008. and how sql it self manage the both SQL Server 2005 and SQL Server 2008 on same IP