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
& 2008]
kindly advice me the steps to perform above action . Thanks in advance.
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.
Christopher Reed, MCT, MCPD, MCTS, Microsoft Specialist, MTA
"The oxen are slow, but the earth is patient."
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.
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
prince2485
Member
289 Points
257 Posts
how to create different instance in SQL Server?
Dec 24, 2012 05:13 AM|LINK
Frnds,
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 & 2008]
kindly advice me the steps to perform above action . Thanks in advance.
Careed
All-Star
18798 Points
3649 Posts
Re: how to create different instance in SQL Server?
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.
"The oxen are slow, but the earth is patient."
oned_gk
All-Star
36244 Points
7386 Posts
Re: how to create different instance in SQL Server?
Dec 24, 2012 06:00 AM|LINK
http://www.mssqltips.com/sqlservertip/1048/how-and-why-would-i-use-multiple-instances-of-sql-server/
Suwandi - Non Graduate Programmer
prince2485
Member
289 Points
257 Posts
Re: how to create different instance in SQL Server?
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.
oned_gk
All-Star
36244 Points
7386 Posts
Re: how to create different instance in SQL Server?
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.
Suwandi - Non Graduate Programmer
prince2485
Member
289 Points
257 Posts
Re: how to create different instance in SQL Server?
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?
Careed
All-Star
18798 Points
3649 Posts
Re: how to create different instance in SQL Server?
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.
"The oxen are slow, but the earth is patient."
prince2485
Member
289 Points
257 Posts
Re: how to create different instance in SQL Server?
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
Careed
All-Star
18798 Points
3649 Posts
Re: how to create different instance in SQL Server?
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.
"The oxen are slow, but the earth is patient."