[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

How do I install SQL Server 2000 ( 2005 already existing)?

Hi,
I have SQL Server 2005 installed on my machine. Now I want to install SQL Server 2000. However its giving an error like 'Procedure entry point could not be found' after installation.
How do I install SQL Server 2000 without uninstalling 2005?
Thanks in advance
0
TekiSreelakshmi
Asked:
TekiSreelakshmi
  • 3
  • 2
  • 2
3 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> How do I install SQL Server 2000 without uninstalling 2005?

If SQL Server 2005 exists as a Named instance, then you can install SQL Server 2000 as a Default instance without any issues.
If SQL Server 2005 exists as Default instance already in the machine, then you can't do it since SQL Server 2000 tries to install as a Default instance only. In this case, you have to uninstall 2005 first and then install 2000.
0
 
wdfdo1986Commented:
@rrjegan17:
I havent tried this before. But cant we install SQL 2000 as a Named Instance?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> I havent tried this before. But cant we install SQL 2000 as a Named Instance?

Thanks wdfdo1986 for the question which made me to analyze in more detail.
Have read earlier that 2000 can have only Default instances and I was actually wrong and the below article to confirm it.

http://msdn.microsoft.com/en-us/library/aa197928%28SQL.80%29.aspx

TekiSreelakshmi,

So, you can install 2000 as a named instance without disturbing your existing 2005 instance.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
AmmarRCommented:
Dear TekiSreelakshmi

you can install Sql 2000 as a named instance,

check the image

untick the default and type in the name of the instance

check this article about how to install sql server 2000 in both ways default and named
http://articles.techrepublic.com.com/5100-10878_11-1041848.html

but keep in mind, sql 2000 and sql 2005 are not very compatible when it comes to installing them on the same machine, sql 2005 and 2008 work better together.

but if you are doing it for a test or a development machine its ok, but dont do it for production.

Regards
install-sql-server-2000-screen-1.gif
0
 
wdfdo1986Commented:
@rrjegan17:
You are welcome and thanks for the immediate reply.
@TekiSreelakshmi:
Now you can install it as a named instance now.
@All:
But dont we need to consider about to ports when we are using two sql servers in same machine?
0
 
AmmarRCommented:
Dear wdfdo1986:

dont worry about the ports

The default SQL Server port is 1433, while Named instances gets a random port number.

look at the first image snapshot, i have both sql 2000 and sql 2005 on the same machine and i am using sql 2005 management studio to connect to both of them

and look at the other image, it show sql 2005 is listening on port 1568, it was given randomly, i didnt configure that

but my default instance which in this case is sql 2000, its running on port 1433


named.jpg
ports.jpg
0
 
wdfdo1986Commented:
@AmmarR:
Thanks for the update
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now