<< BMG Sony Copy Protection, Part III the sequel | Home | SQL Server 2000 and 2005 Same Machine Continued >>

SQL Server 2000 and 2005 same machine?

Ok, I've seen this debated all over the place, and I am looking for an answer from someone who has actually done it. Can the two co-exist? Are there any concerns? I've heard/read that the 2000 should have SP3a applied, but nothing else about issues. Any thoughts?

I have another machine on which I can install it, but I wanted to install the SQLServer express edition with my VS on a machine that hosts my 2000 server which houses some utility stuff (website, CodeVault, etc).

Any help/suggestions would be appreciated. If I don't hear anything, I am going to go ahead and try it, once I back everything up of course. :-)

posted @ Sunday, November 13, 2005 4:12 PM

Print

Comments on this entry:

# re: SQL Server 2000 and 2005 same machine?

Left by Jason Bentley at 11/13/2005 11:19 PM
Gravatar
There is no reason that you cannot do it. Obviously, you can't have two default instances of any version of SQL Server but you can have ten different installations of 2000 and 2005 as long as they are all named differently, they can co-exist happily. I have 2005 installed as the default instance, 2005 Express as /SqlExpress and 2000 installed as /Sql2k. No problems so far.

# re: SQL Server 2000 and 2005 same machine?

Left by Theo Moore at 11/14/2005 1:20 AM
Gravatar
Cool deal. Thanks for the info!

# re: SQL Server 2000 and 2005 same machine?

Left by Randy Vernon at 5/1/2006 2:14 PM
Gravatar
So.. how do you connect to the the non-default instances? For example, if you machine name is "mycomputer", you could put "mycomputer" as the servername to connect to the default instance. How would (could?) you connect to the other instances?

thanks...
Randy
rvernon@spindustry.com

# re: SQL Server 2000 and 2005 same machine?

Left by Theo Moore at 5/1/2006 5:52 PM
Gravatar
Hi! Same way you would any other non-default instance in other versions. Fully qualify the named correct instance <servername>/<instancename> and that should do it, I believe.

Theo

# re: SQL Server 2000 and 2005 same machine?

Left by ben at 7/12/2006 6:00 PM
Gravatar
I have sql 2000 and sql 2005 installed on same machine.
sql2000 enterprise manager cannot be opened.
is there anyway can fix the problem?

# re: SQL Server 2000 and 2005 same machine?

Left by craig at 7/26/2006 11:27 PM
Gravatar
I have the same problem as ben. After installing 2005, i can't connect to my 2000 instance from enterprise manager. Anyone seen/resolved this?

Thanlks

# re: SQL Server 2000 and 2005 same machine?

Left by James at 9/8/2006 10:16 AM
Gravatar
I have not seen this but you should be able to administer your SQL 2000 and 2005 instances using the SQL Server Management Studio

# re: SQL Server 2000 and 2005 same machine?

Left by Jack at 9/20/2006 4:20 PM
Gravatar
Re: EM not working

check this tread out http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=397541&SiteID=1
towards the end there is some stuff on how to fix the EM not working. I personalluy have both SQL 2000 and 2005 installed on my laptop. And evrything workds fine. The trick isd to do a "side-by-side" install and name your instances

cheers

# re: SQL Server 2000 and 2005 same machine?

Left by Abhik at 9/22/2006 6:35 AM
Gravatar
I have SQL server 2000 and 2006 to the same machine. But when i tried to enter data from the asp applicaion to the 2006 version it was unable to add.

Can you please help me coz the code i have used is working for the 2006 version.

# re: SQL Server 2000 and 2005 same machine?

Left by Tanmay at 11/24/2006 12:36 AM
Gravatar
I installed SQL 2005 (PRACTICE2005 instance name) and later installed SQL 2000 (SQL2000 instance name). I can access both of them well with QA and from ASP.NET application within my local machine.
BUT, other mahines in the network are not able to access the SQL 2000 instance FROM AP.NET application.

It's very wierd problem for me since last many days and I have not been able to find good solution to this.

Any help?
Thanks,
Tanmay.

# re: SQL Server 2000 and 2005 same machine?

Left by Marnee at 11/29/2006 3:15 PM
Gravatar
I am having the same problem. Can connect to one instance but not the other. I configured each instance to listen on different IPs and ports but only the connection string specifying the SQL 2005 instance, not the 2000 instance, will connect (remotely) using the ASP.Net applications. I can however connect using the data connection explorer in Visual Studio 2005. I cannot make a remote connection to the 2000 instance using Enterprise Manager.

# re: SQL Server 2000 and 2005 same machine?

Left by Vijay at 1/23/2007 2:17 PM
Gravatar
I have installed SQL 2005 as a defualt instance and the SQL 2000 as a another instance as /sql200. I am able to connect both instance using the query manager on the same machine. But from network i m able to connect only sql 2005 and for 2000 it is not happeing. Can any one help me?

Thanks

# Object reference not set to an instance of an object.

Left by David at 2/10/2007 7:52 AM
Gravatar
On my development machine, I installed vs .net 2005/sqlexpress 2005/.net 2.0 and migrated my vs .net 2003/sqlexpress 2000/.net 1.1 application to it and it works fine. However, for some reason I now get this error message when I try to browse to my .net 1.1 app - "Object reference not set to an instance of an object." when the app attempts to connect to the sqlexpress 2000 database. The sql server 2000 enterprise manager, 2005 enterprise studio, vs .net 2003 and vs .net 2005 can still connect to the sqlexpress 2000 database. Any ideas?

# re: Object reference not set to an instance of an object.

Left by David at 2/11/2007 12:19 PM
Gravatar
I solved this one myself. Turns out my sql server instances were duplicated at some point during the install. I have two called DAVID-XVM4QJ3L\MYSERVER and DAVID-XVM4QJ3L\SQLEXPRESS another two called DAVID-XVM4QJ3L1\MYSERVER and DAVID-XVM4QJ3L1\SQLEXPRESS. Somehow the ASPNET account adopted DAVID-XVM4QJ3L1\MYSERVER after the install. Well, DAVID-XVM4QJ3L1\MYSERVER and DAVID-XVM4QJ3L1 do not exist, but they do show up in my SQL Servers list. I just deleted the ASPNET user account from SQL Server 2000 and added it back in again using the correct server.

It was really quite maddening to not have noticed the "1" there!

# re: SQL Server 2000 and 2005 same machine?

Left by Paul at 3/15/2007 4:18 PM
Gravatar
A few things. For those of you saying you're having problems with Enterprise Manager after installing SQL 2005 side-by-side with SQL 2000 - this is expected. The SQL 2005 Management Studio is what you'll now have to use.

For those of you having problems connecting and installed SQL 2000 last, that's your problem. You must install SQL 2000 (and SP4) and THEN SQL 2005.

I just did this. Installed SQL 2000 to the default "Program Files\Microsoft SQL Server" folder as the default instance. Applied SP4. Installed SQL 2005 to the same folder (it makes its own subfolders) as a named instance.

So far it's working great. I'm restoring a database that needs to have some scripts run against it in SQL 2000 before moving it to SQL 2005 and running some more scripts. I'll report back if I have any problems, but so far it has been very simple and effective.

# re: SQL Server 2000 and 2005 same machine?

Left by Richard at 3/23/2007 9:33 AM
Gravatar
I experienced the issue of installing a SQL 2000 instance on top of an existing installation of SQL 2005. Having had the same frustration of not being able to see the 2000 instance remotely I searched and found this article. Pauls comment " must install SQL 2000 SP4 before 2005" gave me a bit of a panic, but is a hint as to the solution.

SQL 2005 requires that you select "Allow remote connections to access this computer" on the Connections tab of server properties. It also requires that the "SQL Server Browser" service is running.

I checked these and found that installing the SQL 2000 had disabled the "SQL Server Browser" service. Restarting this service allowed remote connection to both the sql Server 2000 and 2005 instances.

This way I did not have to uninstall both versions to reinstall 2000 first.

# re: SQL Server 2000 and 2005 same machine?

Left by anselme at 3/27/2007 1:04 PM
Gravatar
MS SQL 2005 is allready installed and I am using .NEt 1.1

now I want to install MS SQL 2000, I must give another name for the instance ?

# re: SQL Server 2000 and 2005 same machine?

Left by Eugene at 4/6/2007 1:02 AM
Gravatar
Thank you very much Richard. I've done the same and i's working!!!

Actualy there was the other problem wich I had to resolve. It was about ports and connection protocols. I get the result only when set port = 0 for both SQL 2005 and 2000 and also switched on the NamePipes protocol for 2000.

# re: SQL Server 2000 and 2005 same machine?

Left by Paulo at 5/2/2007 7:31 AM
Gravatar
Thanks Richard!

# re: SQL Server 2000 and 2005 same machine?

Left by nadia at 6/2/2007 4:13 AM
Gravatar
I have installed SQL 2000 as a defualt instance and the SQL 2005 as a another instance.
I am not able to connect to sql 2005 throw the another server.
i selected "Allow remote connections to access this computer" on the Connections tab of server properties.
"SQL Server Browser" service is start.
In sys.configurations i checked and found that remote access = 1.
but in another server i can connect to sql server2000 via sql server 2005, but i can't connect to sql server 2005 via sql server 2005.
who can help me?
Nadia

# re: SQL Server 2000 and 2005 same machine?

Left by soonyu at 7/31/2007 10:26 PM
Gravatar
I just wonder can be maintain using sql enterprise manager while using sql management studio

# re: SQL Server 2000 and 2005 same machine?

Left by Hema Nulvi at 8/5/2007 3:17 PM
Gravatar
I have SQL server 2005 installed on my machine. I just now installed SQL server 2000 with SP3a on my machine. However i have a tool which requires the SQL 2000. But when i now start installing my tool it says SQL 2000 not installed on your machine. The SQL 2000 is not getting detected. However i created a diffrent instance for SQL 2000 and 2005 is installed as a default instance.

# re: SQL Server 2000 and 2005 same machine?

Left by Hong at 8/9/2007 1:36 AM
Gravatar
I have SQL Server 2000 installed on my machine previously. I just now installed SQL Server 2005 with SP2 on the same machine. I am unable to see the SQL Server 2005 Management Studio. I can only see the Enterprise Manager.

# re: SQL Server 2000 and 2005 same machine?

Left by Raj at 8/21/2007 9:47 AM
Gravatar
Hong,
Did you select the SQL server management tools feature when you installed SQL server 2k5?? Also, In which data partition did you install sql server 2k5??

# re: SQL Server 2000 and 2005 same machine?

Left by Raj at 8/21/2007 9:47 AM
Gravatar
Hong,
Did you select the SQL server management tools feature when you installed SQL server 2k5?? Also, In which data partition did you install sql server 2k5??

# re: SQL Server 2000 and 2005 same machine?

Left by Raj at 8/21/2007 9:47 AM
Gravatar
Hong,
Did you select the SQL server management tools feature when you installed SQL server 2k5?? Also, In which data partition did you install sql server 2k5??

# re: SQL Server 2000 and 2005 same machine?

Left by Vikas Bapat at 10/17/2007 2:31 AM
Gravatar
We have SQL Server 2000 installed on one machine which runs an ASP application. We would like to install SQL Server 2005 on the same machine to run an ASP.NET 2.0 application. Are there any potential problems ? Are there any precautions to be taken ? Is there any way by which I can go back to starting situation in case something goes wrong.

# re: SQL Server 2000 and 2005 same machine?

Left by farouk at 10/27/2007 4:15 AM
Gravatar
I have a server which has SQL200 as a default instance.
We have installed SQL2005 as another instance.

The issue we have is we need to connect remotely through firewall (using sql port 1433)to the SQL2005 instance

We tried to test with a udl file, what seems to be happening is that it is picking up the SQL200 instance, after a bit of digging around, we stopped all the SQl services (2000 + 2005)

Started the sql 2005 browser service first
then the MSSQL2005 server service
then the MSSQL2000 server service

This way the Remote connection can connect to the SQL2005 instance, previously it connected to the 2000 instance, now it cannot connect to the 2000 instance, but it can connect to the 2005 instance.

What I want toknow is that, with both instances can they use the same port i.e. 1433, if not what other port can be used?

Thanks

# SQL Server 2000 and 2005 same machine?

Left by Srikanth at 4/17/2008 12:36 PM
Gravatar
Hi Friends,

Me to with the same question, do we can have two instance SQL 2000 & 2005 in one system, the answer is clear that we can couls any one of you guide me how to go a head with it and will it slow down my system's perfomance?

is there any back end of forunt problem that might raise due to this.

Regards,
Srikanth

Comments have been closed on this topic.
«December»
SunMonTueWedThuFriSat
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

QTP and Stuff

About
Article Categories
Archives
Image Galleries
Community Related
Favourite Blogs
Personal
QTP Related links
SC Code Camp!
Syndication:

RSS ATOM