How do I install MSDE after SQLServer 2000?

Hello,
I have SQLServer 2000 installed on a PC and I want to install
MSDE as well.
The attempted MSDE installation immediately fails with the
message:
"The instance name specified is invalid"
I looked at the autorun.inf file and I see that there is no name
specified for the new MSDE installation. Presumably it takes the
default machine name? The default machine name is already taken
by the existing SQL Server installation.
What are the correct lines to add to the MSDE autorun.inf file
for the default MSDE server name and sa account password?
After I have MSDE working is it possible to connect to it? I
would like to develop an ASP.NET web application that uses MSDE.
Ideally I would like to use something like Enterprise Manager
but to manage MSDE, at the very least I need something like
Query Analyser to work.
I note that there are some ASP.NET web apps in development that
emulate both Enterprise Manager and Query Analyser for MSDE. Has
anyone used these tools?
If necessary I can install MSDE on an other machine as I have a
LAN running here. I would prefer not to do that.
Hi,
Try executing the setup with Instance name:-
Setup.exe INSTANCENAME=<name> SAPWD=<sapassword >
Thanks
Hari
MCDBA
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||On Wed, 23 Jun 2004 08:50:23 +0100, Zenobia
<6.20.zenobia@.spamgourmet.com> wrote:

>Hello,
>I have SQLServer 2000 installed on a PC and I want to install
>MSDE as well.
>The attempted MSDE installation immediately fails with the
>message:
>"The instance name specified is invalid"
>I looked at the autorun.inf file and I see that there is no name
>specified for the new MSDE installation. Presumably it takes the
>default machine name? The default machine name is already taken
>by the existing SQL Server installation.
>What are the correct lines to add to the MSDE autorun.inf file
>for the default MSDE server name and sa account password?
>After I have MSDE working is it possible to connect to it? I
>would like to develop an ASP.NET web application that uses MSDE.
>Ideally I would like to use something like Enterprise Manager
>but to manage MSDE, at the very least I need something like
>Query Analyser to work.
>I note that there are some ASP.NET web apps in development that
>emulate both Enterprise Manager and Query Analyser for MSDE. Has
>anyone used these tools?
>If necessary I can install MSDE on an other machine as I have a
>LAN running here. I would prefer not to do that.
Apologies for wasting your time. I needed to add some lines to
the setup.ini file:
++++++++++++++++++++++++++++++++++++++++
[Options]
InstanceName="instance_name"
SAPWD="sa_password"
SecurityMode=SQL
++++++++++++++++++++++++++++++++++++++++
See:
http://msdn.microsoft.com/library/de...stsql_84xl.asp
http://support.microsoft.com/default...99&Product=sql
++++++++++++++++++++++++++++++++++++++++
But if anyone's reading. I'd appreciate help on utilities for
editing and creating MSDE databases and...
Now that MSDE is running I can't even see it on my machine. I
now have 2 Sqlservr.exe processes running, which have 2
different memory usages (16M and 8M). But why can't I see the
new database instance in my Tray. Is that normal. Surely, if I
have a process running, I should have an icon in my tray
allowing me to stop and start it?
I running XP pro SP1.
|||Zenobia,
--For the MSDE install issue
Try to run the setup in command line specifying a instance name, as
mentioned in the below syntax:
<path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
c:\<path>\msdeInstallation.log
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||>>>> > After I have MSDE working is it possible to connect to it?
Ofcourse.It will be just like a SQLServer instance.
[vbcol=seagreen]
MSDE is devoid of any GUI but you can always use EM/QA from other editions
to manage.
[vbcol=seagreen]
Aaron has a collection.Please search www.aspfaq.com
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#zwrcyPWEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Zenobia,
> --For the MSDE install issue
> Try to run the setup in command line specifying a instance name, as
> mentioned in the below syntax:
> <path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
> c:\<path>\msdeInstallation.log
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
> news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
>
|||On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
<tkdinesh@.nospam.mail.tkdinesh.com> wrote:

>Ofcourse.It will be just like a SQLServer instance.
>MSDE is devoid of any GUI but you can always use EM/QA from other editions
>to manage.
>
>Aaron has a collection.Please search www.aspfaq.com
Thanks.
After running server network utility I installed:
Named Pipes
TCP/IP
for my new MSDE installation aka machine_name\instance_name
After re booting it now shows to be 'running' in my system tray
as an option of my SQL Server and I have connected to it using
Enterprise Manager and QA.
Are these the 2 protocols I should install or will only one do?
|||Zenobia,
[vbcol=seagreen]
Its fine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:7vlid016ddkp0mdfpkvstd9kdgkoroe6ls@.4ax.com... [vbcol=seagreen]
> On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
> <tkdinesh@.nospam.mail.tkdinesh.com> wrote:
editions
> Thanks.
> After running server network utility I installed:
> Named Pipes
> TCP/IP
> for my new MSDE installation aka machine_name\instance_name
> After re booting it now shows to be 'running' in my system tray
> as an option of my SQL Server and I have connected to it using
> Enterprise Manager and QA.
> Are these the 2 protocols I should install or will only one do?
>
sql