Installing SQL Server 2000 and SQL Server 20005 on the same machine

Hi all,

is it possible to run both instances of SQL Server 2000 and 2005 on the same PC?

The reason I am asking is becasue my install failed for SQL Server 2000 when i already have SQL server 2005 installed.

Get the following at the end of the sqlstp.log file...


Starting Service ...


-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1053)

SQL Server configuration failed.


01:52:54 Process Exit Code: (-1)
01:54:55 Setup failed to configure the server.   Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
01:54:55 Action CleanUpInstall:
01:54:55 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service SQLSERVERAGENT
01:54:55 Process Exit Code: (1060) The specified service does not exist as an installed service.

01:54:55 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
01:55:10 Action Exit Handler:
01:55:12 Process Exit Code: (0)
01:55:12 StatsGenerate returned: 2
01:55:12 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
01:55:12 StatsGenerate -1,Trystan Hughes)
01:55:12 Installation Failed.


2/4/2006 12:41:22 PM 29906 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 1


Similar Artilces:

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

Can I install sql server 2000 and sql server 2005 in the same machine
Hello ,i am an developer my pc has sql server 2005 already and now my company use sql server 2000I think 2005 is very easy to use but some of 2000 that I don't know so can I install 2000 in the same machine with 2005 ?thanks for your kindness.Kate  You definetely can. Go ahead and have fun. ***********************Dinakar NethiLife is short. Enjoy it.*********************** By the way, if you need to connect to a 2000 DB, you dont need to install 2000 on your local machine. You can still connect to the company DB through your 2005 Management Studio. Just register the server a...

Installing SQL Server 2005 & SQL Server 2000 on the same machine?
Hi All, I've installed SQL Server 2000 on my development machine, but would like to install SQL Server 2005 on the same machine without upgrading. Is it possible? I need to keep SQL Server 2000 for my existing production databases. Any one know the solutions? or any article? Thanks bosox04 wrote: I've installed SQL Server 2000 on my development machine, but would like to install SQL Server 2005 on the same machine without upgrading. Is it possible? Yep. bosox04 wrote: Any one know the solutions? or any article? Just install it and give it a different name. ********************...

Installing VS2003 and VS2005 / Sql server 2000 and SQL server 2005 on the same machine
Hey guys, I want to install on the same machine VS2003 and SQL 2000 to study for MCAD and VS2005/SQL server 2005 for ASP.NET 2.0 development.   I used to install two images of WinXP one for .NET1.1 dev and the other for .NET 2.0 but everytime you need to switch from .NET1.1 development to .NET2.0 I need to reboot and launch the other winxp image. any help would be appreciated.  I have been trying to change the world for years, but they just won't give me the source code! Where are you having a problem with this? JeffPlease: Don't forget to click "Mark as Answe...

Can I install SQL 2005 Server Express on a machine that has SQL 2000 Server
I have a dedicated server running SQL Server 2000 on Windows 2003.  Can I install SQL Server 2005 express so that I can run sites developed with VWD Express.  I still have the sites that need to use the sql 2000 server.  Thanks Yes but it best that the sql server 2000 instances be upgraded to service pack 4. Silverlight-helpVb TipsSpace Coast .Net User Group...

This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers". Can I confirm it is because: the remote db is of SQL Server 2008? There is a soln mentioned in Did anybody try this (installing 2008 express: I am just checking again, whether it will disturb my existing SQL Server installation, in any means...? Though it is mentioned that it will g...

SQL Server 2000 and SQL Server 2005 in the same server
Can enyone please send me a link to a white paper explaining how to run both SQL Server 2000 and 2005 in the same machine?Thanks. I don't know about the white paper but I had both running on my machine for a while by making the SQL 2000 a named instance. So for SQL 2005 connection strings my server name was (local) while for SQL 200 using the named instance it was (local)\joesql where joesql was the instance nameHope it helps,Joe http://www.joeaudette.com

SQL Server Reporting Services for SQL SERVER 2000 AND Visual Studio.NET 2005 .NET 2.0
Hi, Which version of SQl Server Reporting Services will work with SQL SERVER 2000 in pararrel with ASP.NET 2.0 (.NET 2.0 framework)?  Thanks, Azam HighOnCodingWanna get high! Hi, Okay I got the answer. Yes, we can use the SQL SERVER 2005 Reporting Services with SQL SERVER 2000. HighOnCodingWanna get high! ...

Installation of SQL Server 2000 and SQL Server 2005 Developer Editions on the same PC
I currently have SQL Server 2005 Developer Edition installed on my home PC. Is it safe (or even advisable) to also install SQL Server Developer Edition 2000 on the same PC? I have two clients, one using SQL Server 2000 and another one on 2005 so I need to do testing on both. Bill I have both on my laptop, but installed them in the opposite order you are wanting to do. Don't know if there would be issues doing 2005 first and then 2000. -- TheSQLGuru President Indicium Resources, Inc. "Bill Murphy" <> wrote in message ...

sql server 2005 to sql server 2000
Due to certain unavoidable reasons we have to move an application from sql server 2005 to sql server 2000 (yes from 2005 to 2000).  would changing the connection string be sufficient or are there other issues involved. How hard is it going to be to get it to work? Any tips or suggestions are greatly appreciated. Yes you will need to change the connection string!However you must look very carefully at the database structure. Do two script exports of every object in the database - one for SQL2000 compatibility and one without. Compare these two scripts, if they are significantly differe...

SQL Server 2000 Developer vs SQL Server 2000 Standard
I have installed the SQL Server 2000 developer that came with Office XP Developer. I now have a copy of SQL Server 2000 Standard. What will happen if I try to install the standard version? Will I loss any of my current database logins or settings, etc...? Thank you for any help,Thank youJackxxx Upgrading your version of SQL Server 2000 should not result in the loss of any information that you already have set up. I believe you can/should choose "Upgrade, remove, or add components to an existing instance of SQL Server" when you go to install SQL Server 2000 Standard. TerriT...

Connecting to an external SQL 2000 Server from a Vista machine with SQL 2005 installed
hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution. Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also install...

Installing SQL Server 2005 on same machine as an existing SQL Sever 2000 instance
Given than once SQL Server 2005 is installed, SQL Server Studio has to be used instead of Enterprise manager, can both SQL 2000 and 2005 be used on the same machine, be it development or production? (The second one to be installed probably would be a named instance.) Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated. Don't forget to click "Mark as Answer" on the post that helped you.This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped. The SQL Server 2005 Books...

SQL SERVER 2000: In which format the datetime will be stored in sql server 2000?
Hi All, I would like to know, how the datetime will be stored in the sqlserver datetime column. Because some time i am giving the date in dd/mm/yyyy and sometime mm/dd/yyyy. while give the date in mm/dd/yyyy works fine but not in the another case. and also while i execute a query on query analyser it shows the datetime in yyyy/mm/dd format. So anyone can please tell me how the dates will be stored in the datetime column of sqlserver database? Thanks in Advance. Regards, Dhanasekaran. G Storing of datetime depends upon the globalization setting. Normally the date time is stor...

Web resources about - Installing SQL Server 2000 and SQL Server 20005 on the same machine -

Help:Installing Japanese character sets - Wikipedia, the free encyclopedia
This help page will help you install Japanese character sets so that your computer will display them properly on the internet in your web browser ...

Earn Free Facebook Credits For Installing Apps — Of Course, There’s A Catch
This looks pretty cool at first: Earn free Facebook Credits for installing applications on your iPhone or Android device. AppDog offers this ...

Rooting and installing Android 1.5 JesusFreke - Flickr - Photo Sharing!
More information at:

Installing ClearCal Anti-Glare Film for Glossy Displays - YouTube
Demonstration of how to install a RadTech ClearCal Anti-Glare Film on a MacBook Pro. ClearCal eliminates glare on glossy displays like Apple's ...

Fatal unit fire: Builder Ray Finianos reduced height of building to avoid installing fire sprinklers ...
The builder of&nbsp;a south-west Sydney unit block where a young woman plunged to her death during a ferocious fire told a certifier to reduce ...

'Green' light bulb moment for councils installing LED street lights
Nine Sydney councils are getting ready to turn off the lights &ndash; 13,000 of them &ndash; to save more than $20 million.

Iran installing new nuclear equipment
Sky News is Australia's leader in 24-hour news. Iran has begun installing next-generation equipment at one of its main nuclear plants, a new ...

Peter Garrett believed installing insulation batts 'not that hard', royal commission told
Former environment minister Peter Garrett believed installing insulation batts was ''not that hard'' based on his own personal experience, an ...

Gillard defends installing Slipper
BBC News Gillard defends installing Slipper Sydney Morning Herald Prime Minister Julia Gillard has defended her decision to install Peter ...

CSIRO says installing solar panels on roofs of businesses could take pressure off the electricity grid ...
Installing more solar panels on the roofs of businesses would help Australia's energy grid cope with increased demand.

Resources last updated: 1/8/2016 6:54:07 PM