Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 26, 2012 03:01 AM by Careed
Dec 24, 2012 05:13 AM|LINK
As i want to run 2 dotnet applications which runs on different sql server version[2000 & 2008] on same server.
But I struggling while creating different instances of 2 different SQL Server version[2000 & 2008] in same server ?
So that i can run my both application which run on 2 different SQL server on same server.
I need steps to create different instance of 2 different SQL Server version[2000
kindly advice me the steps to perform above action . Thanks in advance.
Dec 24, 2012 05:35 AM|LINK
When you install SQL Server, it will give you an opportunity to either use the default installation or to create a "named" instance for that version of SQL Server. Do not use the default installation and name your instance.
Dec 24, 2012 06:00 AM|LINK
Dec 24, 2012 06:09 AM|LINK
tx for your reply,
Even i tried before, wat u adviced me. But even after creating different instance and run stored procedures, they doesnt work by saying following error e.g, there no datatype like time , Actually , in sql 2000 ,there is no such datatype such 'time' as
it i n sql server 2008 but i had 2 SQL server version in that sever.
Which Sql server version should i install first, 2000 or 2008 ? As if i installed SQL 2000 first and then installed SQL 2008. It don't allow me to attach the 2008 Database then.
Dec 24, 2012 06:55 AM|LINK
You are not able to downgrade, attact db to older sql intance.
You need to use export/import.
Dec 24, 2012 08:28 AM|LINK
I liked your link but can you tell more step in detail to install mulitple instance of different SQL sersion [2000 & 2008] on same server.
Is any other way to do so?
Dec 25, 2012 04:15 AM|LINK
I believe that the real question is why do you need to use SQL Server 2000? This version is no longer supported.
Dec 25, 2012 09:53 AM|LINK
Actually i have 2 web applications which runs on sql 2000 & 2008, so i didnt want to upgrade one of the application which run on 2000, it neither want to use 2 different server. So i m thinking to create multiple instance of different sql server version
Dec 26, 2012 03:01 AM|LINK
As SQL Server 2000 is no longer supported, wouldn't it make more sense to upgrade your application to work off of a supported version of SQL Server?
Unless you have integrated too much direct SQL Server functionality into your web application, switching should not be too complex of a task.