Different Instances of 2005 and 2008 version on same ip on same server

Question

hi,

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

---

Regards, Shanu

Answer 1

Hi,

You have to specify instance name in the connection string. Installing multiple instances on the same box is very common. 

I hope it helps.

J.

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog