Solved

Installing msde 2000 sp2 second instance doesn't work

Posted on 2004-08-04
4
238 Views
Last Modified: 2012-06-27
Hi everyone.
I've installed MSDE 2000 SP2 with no problem.
Then I needed to install a second instance.
I changed the .INI file and created a line with INSTANCENAME=LP6
MSDE started to install then at the end it starts to roll back and nothing is installed.
What am I doing wrong ??
I've installed MSDE 2nd instance in the past and had no problem.
What is hapening now ????

I'm sure I'm doing something wrong but what ???????

Thank you

Carlos
0
Comment
Question by:Carlos-jm
  • 3
4 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 11718861
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 11718957
To install another instance of MSDE you'll have to run the MSDE setup.exe with the [INSTANCENAME="InstanceName"] parameter to create a named instance of MSDE.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 11719078
You can do this at the command
line when installing MSDE:

c:\setup.exe INSTANCENAME=MyInstance
0
 

Author Comment

by:Carlos-jm
ID: 11721402
EugeneZ

Is this the file to download " sql2kdesksp3.exe " ???

Carlos
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now