MSDE Instances

Hello everyone. After finally getting MSDE installed, I
am having trouble with instances. At bootup the instance
that is loading is the wrong one, and is not working. The
instance that is loading is just "computername," and I
need "computername\instance" to load. I have checked the
registry for the other instance and it is not there. The
only place I can find this instance is when I open the SQL
Server Service Manager and click the drop down menu for
server. When I select the "computername\instance" from
the drop down menu everything works fine, it is just
initially it loads a defective instance. Anyone have any
ideas?
Thanks,
Chris
hi Chris,
"Chris" <ckujawa@.kcpag.com> ha scritto nel messaggio
news:010701c4ac9d$fa3d49a0$a501280a@.phx.gbl
> Hello everyone. After finally getting MSDE installed, I
> am having trouble with instances. At bootup the instance
> that is loading is the wrong one, and is not working. The
> instance that is loading is just "computername," and I
> need "computername\instance" to load. I have checked the
> registry for the other instance and it is not there. The
> only place I can find this instance is when I open the SQL
> Server Service Manager and click the drop down menu for
> server. When I select the "computername\instance" from
> the drop down menu everything works fine, it is just
> initially it loads a defective instance. Anyone have any
> ideas?
Just a question... to understand...
you do have 2 MSDE instances installed...
a default instance and a named instance... please verify that both (or the
instance you are interestd in) services are set to start at bootstrap,
inspecting the Windows services manager (control panel->administrative
tools->services).. startup has to be "Automatic"...
why the default instance is not working?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi, and thank you for the reply. Sorry that I did not
make this more clear to begin with. No, I do not have two
instances installed, and I don't want two instances
installed. I guess somewhere in the middle of all the
trouble I had installing MSDE it created some kind of
bogus instance. All the readings I have read say that a
default instance in the registry will be located under
MSSQL Server and a named instance will be under Microsoft
SQL Server. I have deleted the MSSQL Server key and then
everything works fine until I reboot, then the key is re-
created. I can log off and back on after the key is
deleted and it works like it is supposed to.
When I open SVRNETCN.exe it says that I have two instances
installed:
1.) computername
2.) computername\instancename
I cannot find a way to get rid of "computername" and that
is the way that it is loading by default.
Let me know if you need more info and I hope I made it a
little more clear.
Thanks,
Chris[vbcol=seagreen]
>--Original Message--
>hi Chris,
>"Chris" <ckujawa@.kcpag.com> ha scritto nel messaggio
>news:010701c4ac9d$fa3d49a0$a501280a@.phx.gbl
instance[vbcol=seagreen]
The[vbcol=seagreen]
the[vbcol=seagreen]
The[vbcol=seagreen]
SQL[vbcol=seagreen]
any
>Just a question... to understand...
>you do have 2 MSDE instances installed...
>a default instance and a named instance... please verify
that both (or the
>instance you are interestd in) services are set to start
at bootstrap,
>inspecting the Windows services manager (control panel-
>administrative
>tools->services).. startup has to be "Automatic"...
>why the default instance is not working?
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||hi Chris,
"Chris" <ckujawa@.kcpag.com> ha scritto nel messaggio
news:089801c4ad48$ccdfdc10$a501280a@.phx.gbl
> Hi, and thank you for the reply. Sorry that I did not
> make this more clear to begin with. No, I do not have two
> instances installed, and I don't want two instances
> installed. I guess somewhere in the middle of all the
> trouble I had installing MSDE it created some kind of
> bogus instance. All the readings I have read say that a
> default instance in the registry will be located under
> MSSQL Server and a named instance will be under Microsoft
> SQL Server. I have deleted the MSSQL Server key and then
> everything works fine until I reboot, then the key is re-
> created. I can log off and back on after the key is
> deleted and it works like it is supposed to.
> When I open SVRNETCN.exe it says that I have two instances
> installed:
> 1.) computername
> 2.) computername\instancename
> I cannot find a way to get rid of "computername" and that
> is the way that it is loading by default.
> Let me know if you need more info and I hope I made it a
> little more clear.
>
ok... you do have 2 MSDE instances installed =;-D
a default instance, and a named instance named "instancename"...
and both of them shoul'd run at startup as this is the default setting
(please verify checking the services management tool)
and please do not delete registy keys that easy, becouse, as someone
elsewhere stated:
>"And by the way, editing the registry is extremely dangerous and I'm not
>responsible if you make a mistake and your hair is sure to fall out and you
>will catch pneumonia blah blah blah..." =:-)
so SQL Server Service Manager should list both instances, and both should be
running...
if you want to remove an MSDE instance, you should find an entry in the
Add/Remove programs applet, and please use that...
if you want to "manually" remove an MSDE instance,
http://support.microsoft.com/default...;EN-US;Q290991 Knowledge
Base article explains exactely the tasks to be performed as
http://support.microsoft.com/default...b;en-us;320873 does...
the second article uses a tool from the Platform SDK, Msizap.exe, which can
clear the Windows Installer entries too...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Install Problems

Iam having some problems installing an MSDE database. I have downloaded
MSDE2000A from the microsoft website and iam running the setup from the
command promt using the following command : sql2000.msi BLANKSAPWD=1
the setup starts to run fine, then it gets to a point in the installation
and the progress bar starts to go backwards and the setup exits without any
errors being logged or any indication that the install failed, except that in
the Add / Remove programs section of controll pannel there is nothing related
to MSDE installed.
how can i remedy this situation?It's hard to diagnose with the little information provided.
What version of Windows are you using?
Is there enough disk space?
Do you have admin privileges on the computer?
Watch very carefully while it is installing, an error message may appear on
the screen for just a few seconds before it uninstalls.
Come back with whatever additional information you can provide.
--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."
"Luca" <Luca@.discussions.microsoft.com> wrote in message
news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
> Iam having some problems installing an MSDE database. I have downloaded
> MSDE2000A from the microsoft website and iam running the setup from the
> command promt using the following command : sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the installation
> and the progress bar starts to go backwards and the setup exits without
> any
> errors being logged or any indication that the install failed, except that
> in
> the Add / Remove programs section of controll pannel there is nothing
> related
> to MSDE installed.
> how can i remedy this situation?|||windows server 2003
Plenty of disk space
And no there is no error at all, it gets to 1 seccond remaing then just
starts going backwards..
"Arnie Rowland" wrote:
> It's hard to diagnose with the little information provided.
> What version of Windows are you using?
> Is there enough disk space?
> Do you have admin privileges on the computer?
> Watch very carefully while it is installing, an error message may appear on
> the screen for just a few seconds before it uninstalls.
> Come back with whatever additional information you can provide.
> --
> Arnie Rowland
> "To be successful, your heart must accompany your knowledge."
>
> "Luca" <Luca@.discussions.microsoft.com> wrote in message
> news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
> > Iam having some problems installing an MSDE database. I have downloaded
> > MSDE2000A from the microsoft website and iam running the setup from the
> > command promt using the following command : sql2000.msi BLANKSAPWD=1
> >
> > the setup starts to run fine, then it gets to a point in the installation
> > and the progress bar starts to go backwards and the setup exits without
> > any
> > errors being logged or any indication that the install failed, except that
> > in
> > the Add / Remove programs section of controll pannel there is nothing
> > related
> > to MSDE installed.
> >
> > how can i remedy this situation?
>
>|||hi Luca,
Luca wrote:
> Iam having some problems installing an MSDE database. I have
> downloaded MSDE2000A from the microsoft website and iam running the
> setup from the command promt using the following command :
> sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the
> installation and the progress bar starts to go backwards and the
> setup exits without any errors being logged or any indication that
> the install failed, except that in the Add / Remove programs section
> of controll pannel there is nothing related to MSDE installed.
> how can i remedy this situation?
please add the
/L*v "c:\MsdeLog.txt"
parameter to the
c:\...\>setup.exe BLANKSAPWD=1
(btw, BLANKSAPWD=1 is not a very good choice at all)
command line call to the boostrap installer of MSDE... this will enable
verbose logging of the setup process, resulting in an about 2mb text file
(for a succesufll installation) you can inspect in case of problem..
scan the log file for
RETURN VALUE 3
entries... about 10 lines before each entry you will get some (sometime
cryptic) description of the problem..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||Ok i have added the extra command and have looked at the output.. the only
things i can see that may be causing the errors and that are close to Return
Value 3 are:
InstallSQLAgentSecurity failed (SERVER-NAME,LocalSystem,87).
-
MSI (s) (2C:D4) [09:24:31:823]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (2C:D4) [09:24:31:823]: Error in rollback skipped. Return: 5
MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry propogation
window. Discarding Changes.
MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for this
installation.
not sure if the last one means anything but the - InstallSQLAgentSecurity
failed (SERVER-NAME,LocalSystem,87). looks like something
any ideas?
"Andrea Montanari" wrote:
> hi Luca,
> Luca wrote:
> > Iam having some problems installing an MSDE database. I have
> > downloaded MSDE2000A from the microsoft website and iam running the
> > setup from the command promt using the following command :
> > sql2000.msi BLANKSAPWD=1
> >
> > the setup starts to run fine, then it gets to a point in the
> > installation and the progress bar starts to go backwards and the
> > setup exits without any errors being logged or any indication that
> > the install failed, except that in the Add / Remove programs section
> > of controll pannel there is nothing related to MSDE installed.
> >
> > how can i remedy this situation?
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the
> c:\...\>setup.exe BLANKSAPWD=1
> (btw, BLANKSAPWD=1 is not a very good choice at all)
> command line call to the boostrap installer of MSDE... this will enable
> verbose logging of the setup process, resulting in an about 2mb text file
> (for a succesufll installation) you can inspect in case of problem..
> scan the log file for
> RETURN VALUE 3
> entries... about 10 lines before each entry you will get some (sometime
> cryptic) description of the problem..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>|||hi Luca,
Luca wrote:
> MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry
> propogation window. Discarding Changes.
> MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for
> this installation.
are you installing MSDE on a Terminal Server session? if this is the case,
this usually causes a lot of problems... try installing it not on TS
session..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||thanks for all your help. i have solved to problem
"Andrea Montanari" wrote:
> hi Luca,
> Luca wrote:
> > MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry
> > propogation window. Discarding Changes.
> > MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for
> > this installation.
> are you installing MSDE on a Terminal Server session? if this is the case,
> this usually causes a lot of problems... try installing it not on TS
> session..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>

MSDE Install Problems

Iam having some problems installing an MSDE database. I have downloaded
MSDE2000A from the microsoft website and iam running the setup from the
command promt using the following command : sql2000.msi BLANKSAPWD=1
the setup starts to run fine, then it gets to a point in the installation
and the progress bar starts to go backwards and the setup exits without any
errors being logged or any indication that the install failed, except that i
n
the Add / Remove programs section of controll pannel there is nothing relate
d
to MSDE installed.
how can i remedy this situation?It's hard to diagnose with the little information provided.
What version of Windows are you using?
Is there enough disk space?
Do you have admin privileges on the computer?
Watch very carefully while it is installing, an error message may appear on
the screen for just a few seconds before it uninstalls.
Come back with whatever additional information you can provide.
Arnie Rowland
"To be successful, your heart must accompany your knowledge."
"Luca" <Luca@.discussions.microsoft.com> wrote in message
news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
> Iam having some problems installing an MSDE database. I have downloaded
> MSDE2000A from the microsoft website and iam running the setup from the
> command promt using the following command : sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the installation
> and the progress bar starts to go backwards and the setup exits without
> any
> errors being logged or any indication that the install failed, except that
> in
> the Add / Remove programs section of controll pannel there is nothing
> related
> to MSDE installed.
> how can i remedy this situation?|||windows server 2003
Plenty of disk space
And no there is no error at all, it gets to 1 seccond remaing then just
starts going backwards..
"Arnie Rowland" wrote:

> It's hard to diagnose with the little information provided.
> What version of Windows are you using?
> Is there enough disk space?
> Do you have admin privileges on the computer?
> Watch very carefully while it is installing, an error message may appear o
n
> the screen for just a few seconds before it uninstalls.
> Come back with whatever additional information you can provide.
> --
> Arnie Rowland
> "To be successful, your heart must accompany your knowledge."
>
> "Luca" <Luca@.discussions.microsoft.com> wrote in message
> news:4B112961-D412-4AF4-9DAE-8ED2692D09ED@.microsoft.com...
>
>|||hi Luca,
Luca wrote:
> Iam having some problems installing an MSDE database. I have
> downloaded MSDE2000A from the microsoft website and iam running the
> setup from the command promt using the following command :
> sql2000.msi BLANKSAPWD=1
> the setup starts to run fine, then it gets to a point in the
> installation and the progress bar starts to go backwards and the
> setup exits without any errors being logged or any indication that
> the install failed, except that in the Add / Remove programs section
> of controll pannel there is nothing related to MSDE installed.
> how can i remedy this situation?
please add the
/L*v "c:\MsdeLog.txt"
parameter to the
c:\...\>setup.exe BLANKSAPWD=1
(btw, BLANKSAPWD=1 is not a very good choice at all)
command line call to the boostrap installer of MSDE... this will enable
verbose logging of the setup process, resulting in an about 2mb text file
(for a succesufll installation) you can inspect in case of problem..
scan the log file for
RETURN VALUE 3
entries... about 10 lines before each entry you will get some (sometime
cryptic) description of the problem..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||Ok i have added the extra command and have looked at the output.. the only
things i can see that may be causing the errors and that are close to Return
Value 3 are:
InstallSQLAgentSecurity failed (SERVER-NAME,LocalSystem,87).
-
MSI (s) (2C:D4) [09:24:31:823]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,Pro
gressTotalLDWord=0)
MSI (s) (2C:D4) [09:24:31:823]: Error in rollback skipped. Return: 5
MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry propoga
tion
window. Discarding Changes.
MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for th
is
installation.
not sure if the last one means anything but the - InstallSQLAgentSecurity
failed (SERVER-NAME,LocalSystem,87). looks like something
any ideas?
"Andrea Montanari" wrote:

> hi Luca,
> Luca wrote:
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the
> c:\...\>setup.exe BLANKSAPWD=1
> (btw, BLANKSAPWD=1 is not a very good choice at all)
> command line call to the boostrap installer of MSDE... this will enable
> verbose logging of the setup process, resulting in an about 2mb text file
> (for a succesufll installation) you can inspect in case of problem..
> scan the log file for
> RETURN VALUE 3
> entries... about 10 lines before each entry you will get some (sometime
> cryptic) description of the problem..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>|||hi Luca,
Luca wrote:
> MSI (s) (2C:D4) [09:24:31:838]: Closing Terminal Server registry
> propogation window. Discarding Changes.
> MSI (s) (2C:D4) [09:24:31:885]: No System Restore sequence number for
> this installation.
are you installing MSDE on a Terminal Server session? if this is the case,
this usually causes a lot of problems... try installing it not on TS
session..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||thanks for all your help. i have solved to problem
"Andrea Montanari" wrote:

> hi Luca,
> Luca wrote:
> are you installing MSDE on a Terminal Server session? if this is the case,
> this usually causes a lot of problems... try installing it not on TS
> session..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply
>
>

MSDE IMAGE "CLONED"

Can MSDE be cloned? I would like to creates an install of MSDE in an image I
am working on, and create an image of the load. Does anyone know if this
will cause problems for MSDE?
Thanks in advance.
BobS
hi BobS,
"BobS" <bobs@.computertorture.com> ha scritto nel messaggio
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl
> Can MSDE be cloned? I would like to creates an install of MSDE in an
> image I am working on, and create an image of the load. Does anyone
> know if this will cause problems for MSDE?
> Thanks in advance.
> BobS
AFAIK not... you can ghost a complete pc, but not a single MSDE instance
installation... I actually do not understand how do you prepare the "image"
to be burned and distributed... lot of dlls, both standard Win32 and COM
dlls, have to be written to disk, both in private \Microsoft SQL Server\..
and system ... stuff has to be written to the registry... services have to
be installed and negotiated...
I do have really no clues...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Bob,
Apart from Andrea's comments, if you are just talking about creating an
operating system image that contains the MSDE and wanting to clone it, the
main issue relates to renaming the computer. Once you've done that, you
should read
http://msdn.microsoft.com/library/de...stall_5r8f.asp
about renaming a system running sql server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"BobS" <bobs@.computertorture.com> wrote in message
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
> Can MSDE be cloned? I would like to creates an install of MSDE in an image
> I
> am working on, and create an image of the load. Does anyone know if this
> will cause problems for MSDE?
> Thanks in advance.
> BobS
>
|||Thanks Greg. I'll have a look at the docs. I'm working on a special project,
and must find a way of to get this done.
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:O5CbpytuEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi Bob,
> Apart from Andrea's comments, if you are just talking about creating an
> operating system image that contains the MSDE and wanting to clone it, the
> main issue relates to renaming the computer. Once you've done that, you
> should read
>
http://msdn.microsoft.com/library/de...stall_5r8f.asp[vbcol=seagreen]
> about renaming a system running sql server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "BobS" <bobs@.computertorture.com> wrote in message
> news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
image
>