I am installing MSDE from the SQL Server 2000 CD on a W2K
Pro environment. No errors in installation. There is no
service installed to start SQL Server. Any ideas?
hi Rick,
"Rick" <rsexauer@.avayle.com> ha scritto nel messaggio
news:cde901c48a55$bb29d270$a601280a@.phx.gbl...
> I am installing MSDE from the SQL Server 2000 CD on a W2K
> Pro environment. No errors in installation. There is no
> service installed to start SQL Server. Any ideas?
actually, Service Manager should be present in the tray area...
can you please confirm, browsing the installed services in the control
panel->services applet that MSDE is properly installed?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label installing. Show all posts
Showing posts with label installing. Show all posts
Friday, March 30, 2012
MSDE SP4 installation problem
Having a real problem installing SP4 on MSDE. I've read the notes that come
along with the install files and I've tried most every combination that
makes sense in the command line. Here's just one example:
setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
UPGRADEPWD=apasswoord
DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
It's the default instance. The setup command simply returns immediately, no
log created etc.
I'm at a loss to know what's wrong here.
Thanks for any input you can offer.
jimI believe I have fixed this, appears to be in the comand line arguments. I
couldn't get them to work as in the supplied examples, but still haven't
solved the original problem, which is my other post -'Dist Query Problem'
"Jim Bailey" <jimREMOVETHIS@.ANDTHISjbaileygroup.com> wrote in message
news:3uSve.169016$IO.100652@.tornado.tampabay.rr.com...
> Having a real problem installing SP4 on MSDE. I've read the notes that
come
> along with the install files and I've tried most every combination that
> makes sense in the command line. Here's just one example:
> setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
> UPGRADEPWD=apasswoord
> DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
> It's the default instance. The setup command simply returns immediately,
no
> log created etc.
> I'm at a loss to know what's wrong here.
> Thanks for any input you can offer.
> jim
>
along with the install files and I've tried most every combination that
makes sense in the command line. Here's just one example:
setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
UPGRADEPWD=apasswoord
DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
It's the default instance. The setup command simply returns immediately, no
log created etc.
I'm at a loss to know what's wrong here.
Thanks for any input you can offer.
jimI believe I have fixed this, appears to be in the comand line arguments. I
couldn't get them to work as in the supplied examples, but still haven't
solved the original problem, which is my other post -'Dist Query Problem'
"Jim Bailey" <jimREMOVETHIS@.ANDTHISjbaileygroup.com> wrote in message
news:3uSve.169016$IO.100652@.tornado.tampabay.rr.com...
> Having a real problem installing SP4 on MSDE. I've read the notes that
come
> along with the install files and I've tried most every combination that
> makes sense in the command line. Here's just one example:
> setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
> UPGRADEPWD=apasswoord
> DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
> It's the default instance. The setup command simply returns immediately,
no
> log created etc.
> I'm at a loss to know what's wrong here.
> Thanks for any input you can offer.
> jim
>
MSDE SP4 installation problem
Having a real problem installing SP4 on MSDE. I've read the notes that come
along with the install files and I've tried most every combination that
makes sense in the command line. Here's just one example:
setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
UPGRADEPWD=apasswoord
DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
It's the default instance. The setup command simply returns immediately, no
log created etc.
I'm at a loss to know what's wrong here.
Thanks for any input you can offer.
jim
I believe I have fixed this, appears to be in the comand line arguments. I
couldn't get them to work as in the supplied examples, but still haven't
solved the original problem, which is my other post -'Dist Query Problem'
"Jim Bailey" <jimREMOVETHIS@.ANDTHISjbaileygroup.com> wrote in message
news:3uSve.169016$IO.100652@.tornado.tampabay.rr.co m...
> Having a real problem installing SP4 on MSDE. I've read the notes that
come
> along with the install files and I've tried most every combination that
> makes sense in the command line. Here's just one example:
> setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
> UPGRADEPWD=apasswoord
> DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
> It's the default instance. The setup command simply returns immediately,
no
> log created etc.
> I'm at a loss to know what's wrong here.
> Thanks for any input you can offer.
> jim
>
along with the install files and I've tried most every combination that
makes sense in the command line. Here's just one example:
setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
UPGRADEPWD=apasswoord
DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
It's the default instance. The setup command simply returns immediately, no
log created etc.
I'm at a loss to know what's wrong here.
Thanks for any input you can offer.
jim
I believe I have fixed this, appears to be in the comand line arguments. I
couldn't get them to work as in the supplied examples, but still haven't
solved the original problem, which is my other post -'Dist Query Problem'
"Jim Bailey" <jimREMOVETHIS@.ANDTHISjbaileygroup.com> wrote in message
news:3uSve.169016$IO.100652@.tornado.tampabay.rr.co m...
> Having a real problem installing SP4 on MSDE. I've read the notes that
come
> along with the install files and I've tried most every combination that
> makes sense in the command line. Here's just one example:
> setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
> UPGRADEPWD=apasswoord
> DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
> It's the default instance. The setup command simply returns immediately,
no
> log created etc.
> I'm at a loss to know what's wrong here.
> Thanks for any input you can offer.
> jim
>
MSDE SP4 installation problem
Having a real problem installing SP4 on MSDE. I've read the notes that come
along with the install files and I've tried most every combination that
makes sense in the command line. Here's just one example:
setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
UPGRADEPWD=apasswoord
DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
It's the default instance. The setup command simply returns immediately, no
log created etc.
I'm at a loss to know what's wrong here.
Thanks for any input you can offer.
jimI believe I have fixed this, appears to be in the comand line arguments. I
couldn't get them to work as in the supplied examples, but still haven't
solved the original problem, which is my other post -'Dist Query Problem'
"Jim Bailey" <jimREMOVETHIS@.ANDTHISjbaileygroup.com> wrote in message
news:3uSve.169016$IO.100652@.tornado.tampabay.rr.com...
> Having a real problem installing SP4 on MSDE. I've read the notes that
come
> along with the install files and I've tried most every combination that
> makes sense in the command line. Here's just one example:
> setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
> UPGRADEPWD=apasswoord
> DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
> It's the default instance. The setup command simply returns immediately,
no
> log created etc.
> I'm at a loss to know what's wrong here.
> Thanks for any input you can offer.
> jim
>
along with the install files and I've tried most every combination that
makes sense in the command line. Here's just one example:
setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
UPGRADEPWD=apasswoord
DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
It's the default instance. The setup command simply returns immediately, no
log created etc.
I'm at a loss to know what's wrong here.
Thanks for any input you can offer.
jimI believe I have fixed this, appears to be in the comand line arguments. I
couldn't get them to work as in the supplied examples, but still haven't
solved the original problem, which is my other post -'Dist Query Problem'
"Jim Bailey" <jimREMOVETHIS@.ANDTHISjbaileygroup.com> wrote in message
news:3uSve.169016$IO.100652@.tornado.tampabay.rr.com...
> Having a real problem installing SP4 on MSDE. I've read the notes that
come
> along with the install files and I've tried most every combination that
> makes sense in the command line. Here's just one example:
> setup /upgradesp sqlrun SECURITYMODE=sql UPGRADEUSER=sa
> UPGRADEPWD=apasswoord
> DISABLENETWORKPROTOCOLS=0 /L*v c:\mylog.log
> It's the default instance. The setup command simply returns immediately,
no
> log created etc.
> I'm at a loss to know what's wrong here.
> Thanks for any input you can offer.
> jim
>
Wednesday, March 28, 2012
MSDE Sort Page
Hi,
I would like to install MSDE by selecting options from the
screen and not by typing commads at command prompt, just
the same way of installing SQL Server 2000.
I would also like to change the Sorting and collation
options under MSDE.
Please Help.
Thanks
Asim
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:79d501c48460$d47c2890$a401280a@.phx.gbl...
> Hi,
> I would like to install MSDE by selecting options from the
> screen and not by typing commads at command prompt, just
> the same way of installing SQL Server 2000.
> I would also like to change the Sorting and collation
> options under MSDE.
you have then to provide your own custom tool, which will then pass al
gathered info to the setup.exe via standard command line parameters or INI
settings
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||HI Andrea,
I think your message did not come completely. I would
appreciate if you can send it once again.
Also please let me know how can I change by what code, the
sort or collation page setting after the MSDE has been
installed. My email is asim@.dataocean.com
Thanks
>--Original Message--
>hi Asim,
>"Asim" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:79d501c48460$d47c2890$a401280a@.phx.gbl...
the
>you have then to provide your own custom tool, which will
then pass al
>gathered info to the setup.exe via standard command line
parameters or INI
>settings
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||hi Asim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7c8b01c48468$b1d359a0$a601280a@.phx.gbl...
> HI Andrea,
> I think your message did not come completely. I would
> appreciate if you can send it once again.
> Also please let me know how can I change by what code, the
> sort or collation page setting after the MSDE has been
> installed. My email is asim@.dataocean.com
my message was complete... LOL
I apologise if it was not clear
you have to implement a vb/vc/.net/delphi pre-installer, which collects all
user's input regarding settings like SAPWD, DISABLENETWORKPROTOCOLS,
INSTANCENAME, SECURITYMODE, TARGETDIR, DATADIR and COLLATION (for sort
order)...
then you have shell out to setup.exe passing all parameters (or setting them
in the referenced INI file)
as regard COLLATION, you can not change the system collation after the
instance has been installed...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I would like to install MSDE by selecting options from the
screen and not by typing commads at command prompt, just
the same way of installing SQL Server 2000.
I would also like to change the Sorting and collation
options under MSDE.
Please Help.
Thanks
Asim
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:79d501c48460$d47c2890$a401280a@.phx.gbl...
> Hi,
> I would like to install MSDE by selecting options from the
> screen and not by typing commads at command prompt, just
> the same way of installing SQL Server 2000.
> I would also like to change the Sorting and collation
> options under MSDE.
you have then to provide your own custom tool, which will then pass al
gathered info to the setup.exe via standard command line parameters or INI
settings
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||HI Andrea,
I think your message did not come completely. I would
appreciate if you can send it once again.
Also please let me know how can I change by what code, the
sort or collation page setting after the MSDE has been
installed. My email is asim@.dataocean.com
Thanks
>--Original Message--
>hi Asim,
>"Asim" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:79d501c48460$d47c2890$a401280a@.phx.gbl...
the
>you have then to provide your own custom tool, which will
then pass al
>gathered info to the setup.exe via standard command line
parameters or INI
>settings
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||hi Asim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7c8b01c48468$b1d359a0$a601280a@.phx.gbl...
> HI Andrea,
> I think your message did not come completely. I would
> appreciate if you can send it once again.
> Also please let me know how can I change by what code, the
> sort or collation page setting after the MSDE has been
> installed. My email is asim@.dataocean.com
my message was complete... LOL
I apologise if it was not clear
you have to implement a vb/vc/.net/delphi pre-installer, which collects all
user's input regarding settings like SAPWD, DISABLENETWORKPROTOCOLS,
INSTANCENAME, SECURITYMODE, TARGETDIR, DATADIR and COLLATION (for sort
order)...
then you have shell out to setup.exe passing all parameters (or setting them
in the referenced INI file)
as regard COLLATION, you can not change the system collation after the
instance has been installed...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
MSDE setup failed
was installing MSDE for use with Web matrix
thot had done all correctly ie the setup.exe sapwd=xxxxx securitymode=sql from the command prompt
was told that setup has failed
where is the problemWas there any other information provided with the error message? If the message was "Setup Failed to configure the server" then this might help:
thot had done all correctly ie the setup.exe sapwd=xxxxx securitymode=sql from the command prompt
was told that setup has failed
where is the problemWas there any other information provided with the error message? If the message was "Setup Failed to configure the server" then this might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql
Also, there should be a setup log created that might have more information.
MSDE Setup and first database
I'm deploying MSDE with a desktop app (windows forms .net).
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is the recommended
method for doing this?
Thank You!
Hi,
Give a batch file to create the database. All you have to do is double click
the batch file. batch file should contain:-
OSQL -Usa -Ppassword -S servername -Q'Create database
dbname' -o'c:\createdb.log'
Save the command inside a .BAT file and send to client side to create the
database. Instad of giving the -Q parameter you
can also input a .SQL file which contans sequence of TSQL commands.
Thanks
Hari
SQL Server MVP
"Harley" <harleyobrienAThotmailDOTcom> wrote in message
news:E3273FC0-ADE4-47B1-9F3D-8DEC479E3341@.microsoft.com...
> I'm deploying MSDE with a desktop app (windows forms .net).
> after installing MSDE, how do I create the database for the application?
> I cannot provide a createdb.sql script to the user because there is no
> queryanalyzer or similar tools.
> How can I run the create query from the setup? or what is the recommended
> method for doing this?
> Thank You!
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is the recommended
method for doing this?
Thank You!
Hi,
Give a batch file to create the database. All you have to do is double click
the batch file. batch file should contain:-
OSQL -Usa -Ppassword -S servername -Q'Create database
dbname' -o'c:\createdb.log'
Save the command inside a .BAT file and send to client side to create the
database. Instad of giving the -Q parameter you
can also input a .SQL file which contans sequence of TSQL commands.
Thanks
Hari
SQL Server MVP
"Harley" <harleyobrienAThotmailDOTcom> wrote in message
news:E3273FC0-ADE4-47B1-9F3D-8DEC479E3341@.microsoft.com...
> I'm deploying MSDE with a desktop app (windows forms .net).
> after installing MSDE, how do I create the database for the application?
> I cannot provide a createdb.sql script to the user because there is no
> queryanalyzer or similar tools.
> How can I run the create query from the setup? or what is the recommended
> method for doing this?
> Thank You!
MSDE setup / installation
Hi
I am a beginner in this, may I asked some basic question
1. do I need any version of MSDE before installing MSDE2000 sp3?
2. I have an environment with two servers, each of these has a web server
with a DC running, and I have written a .NET application for administrator
to maintain user a/c in this domain. Now, I would like to use a MSDE server
for keeping logs.
Can I have an installation of MSDE on each of these servers such that the
two installation would synchronize on a periodic basis?
Please note that changes of records are expected on either of these servers!
TIA
hi,
dl wrote:
> Hi
> I am a beginner in this, may I asked some basic question
> 1. do I need any version of MSDE before installing MSDE2000 sp3?
no, you can just directly install MSDE Rel A (sp3a level) and upgrade to sp4
via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or
directly install MSDE at the sp4 level... but currently it's not clear to me
if general users not owning a "required" SQL Server license as per
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for
direct sp4 use... just a note, Microsoft representatives already exposed a
refresh of MSDE Rel A updated at sp4 level will be made available...)
> 2. I have an environment with two servers, each of these has a web
> server with a DC running, and I have written a .NET application for
> administrator to maintain user a/c in this domain. Now, I would like
> to use a MSDE server for keeping logs.
> Can I have an installation of MSDE on each of these servers such that
> the two installation would synchronize on a periodic basis?
> Please note that changes of records are expected on either of these
> servers!
>
yes, you can install MSDE on both servers, and even provide a replication
paht between the 2 MSDE instances, as MSDE supports merge and snapshot
replication
(http://msdn.microsoft.com/library/de...lover_694n.asp)
but, unfortunately, without Enterprise Manager tool it will be not trivial
to set it up
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||In message <ei6anK5cFHA.3488@.tk2msftngp13.phx.gbl>, dl@.?.?.invalid
writes
>Hi
>I am a beginner in this, may I asked some basic question
>1. do I need any version of MSDE before installing MSDE2000 sp3?
If your download file for sp3 is about 60-70mb then know it will install
MSDE at the same time if not present. You would be better using the
MSDERelA package (which includes sp3).
>2. I have an environment with two servers, each of these has a web server
>with a DC running, and I have written a .NET application for administrator
>to maintain user a/c in this domain. Now, I would like to use a MSDE server
>for keeping logs.
>Can I have an installation of MSDE on each of these servers such that the
>two installation would synchronize on a periodic basis?
>Please note that changes of records are expected on either of these servers!
Yes. You can have as many instances per server as you like (well up to
16 anyway - I think thats the right number). Yes you can use DTS to
keep the servers synchronised (you would normally pick one as the master
however). Just make sure your database and table design are decent (ie:
Primary Keys etc).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
I am a beginner in this, may I asked some basic question
1. do I need any version of MSDE before installing MSDE2000 sp3?
2. I have an environment with two servers, each of these has a web server
with a DC running, and I have written a .NET application for administrator
to maintain user a/c in this domain. Now, I would like to use a MSDE server
for keeping logs.
Can I have an installation of MSDE on each of these servers such that the
two installation would synchronize on a periodic basis?
Please note that changes of records are expected on either of these servers!
TIA
hi,
dl wrote:
> Hi
> I am a beginner in this, may I asked some basic question
> 1. do I need any version of MSDE before installing MSDE2000 sp3?
no, you can just directly install MSDE Rel A (sp3a level) and upgrade to sp4
via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or
directly install MSDE at the sp4 level... but currently it's not clear to me
if general users not owning a "required" SQL Server license as per
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for
direct sp4 use... just a note, Microsoft representatives already exposed a
refresh of MSDE Rel A updated at sp4 level will be made available...)
> 2. I have an environment with two servers, each of these has a web
> server with a DC running, and I have written a .NET application for
> administrator to maintain user a/c in this domain. Now, I would like
> to use a MSDE server for keeping logs.
> Can I have an installation of MSDE on each of these servers such that
> the two installation would synchronize on a periodic basis?
> Please note that changes of records are expected on either of these
> servers!
>
yes, you can install MSDE on both servers, and even provide a replication
paht between the 2 MSDE instances, as MSDE supports merge and snapshot
replication
(http://msdn.microsoft.com/library/de...lover_694n.asp)
but, unfortunately, without Enterprise Manager tool it will be not trivial
to set it up
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||In message <ei6anK5cFHA.3488@.tk2msftngp13.phx.gbl>, dl@.?.?.invalid
writes
>Hi
>I am a beginner in this, may I asked some basic question
>1. do I need any version of MSDE before installing MSDE2000 sp3?
If your download file for sp3 is about 60-70mb then know it will install
MSDE at the same time if not present. You would be better using the
MSDERelA package (which includes sp3).
>2. I have an environment with two servers, each of these has a web server
>with a DC running, and I have written a .NET application for administrator
>to maintain user a/c in this domain. Now, I would like to use a MSDE server
>for keeping logs.
>Can I have an installation of MSDE on each of these servers such that the
>two installation would synchronize on a periodic basis?
>Please note that changes of records are expected on either of these servers!
Yes. You can have as many instances per server as you like (well up to
16 anyway - I think thats the right number). Yes you can use DTS to
keep the servers synchronised (you would normally pick one as the master
however). Just make sure your database and table design are decent (ie:
Primary Keys etc).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
MSDE Service permissions
Hi All,
I'm installing MSDE 2000 with a custom application (launched using
setup.exe, not integrating merge modules) and am having a problem with the
service permissions for SQL services. The custom app installer is being
build with Installshield Pro 6.3.
Everything works fine for admin users, but MSDE won't start for non-admin
users. The MSSQL$Instance service won't start unless it's logging on a Local
System.
I need non-admin users to have access to the database.
Is there any way to setup MSDE on install to work for everyone?
What does one need to do to manually configure it after install to work for
everyone?
Thanks,
leon.
hi Leon,
"LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
news:Oe0QyXhhEHA.904@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I'm installing MSDE 2000 with a custom application (launched using
> setup.exe, not integrating merge modules) and am having a problem with the
> service permissions for SQL services. The custom app installer is being
> build with Installshield Pro 6.3.
> Everything works fine for admin users, but MSDE won't start for non-admin
> users. The MSSQL$Instance service won't start unless it's logging on a
Local
> System.
> I need non-admin users to have access to the database.
> Is there any way to setup MSDE on install to work for everyone?
> What does one need to do to manually configure it after install to work
for
> everyone?
usually MSDE is installed setting the relative services account to
LocalSystem, that provide (far) enought privileges (on the local machine)
for all logged users...
have a look at
http://msdn.microsoft.com/library/de...l/THCMCh18.asp
for more restrictions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
By default the services use Local System option for log on. This worked fine
for all admin users but did not work for a non-admin user. When a non-admin
user logs in (local or domain user), the services won't start using Local
System. (side note: this is on a WinXP Pro machine). The non-admin user
cannot start or stop any service.
We did get it to work for the non-admin user by using the local
administrator account for log on (I goofed when trying it the first time by
using domain admin password instead of local admin password). This is not
the way we want to go, but it's the only way it does work right now.
I did find one thing via your link, in the Installation Recommendations:
"Create a least privileged local account with which to run the SQL Server
service. Use this account when you are prompted for service settings during
setup. Do not use the local system account or an administrator account. "
There is no prompt when installing MSDE. What exactly is a "least priviledge
local account"?
Any other suggestions are most welcome!
Thanks for your help.
leon.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2okhj5Fbml6lU1@.uni-berlin.de...[vbcol=seagreen]
> hi Leon,
> "LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
> news:Oe0QyXhhEHA.904@.TK2MSFTNGP09.phx.gbl...
the[vbcol=seagreen]
non-admin
> Local
> for
> usually MSDE is installed setting the relative services account to
> LocalSystem, that provide (far) enought privileges (on the local machine)
> for all logged users...
> have a look at
>
http://msdn.microsoft.com/library/de...l/THCMCh18.asp
> for more restrictions..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Leon,
"LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
news:eO0WPBthEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi Andrea,
> By default the services use Local System option for log on. This worked
fine
> for all admin users but did not work for a non-admin user. When a
non-admin
> user logs in (local or domain user), the services won't start using Local
> System. (side note: this is on a WinXP Pro machine). The non-admin user
> cannot start or stop any service.
actually they shoul'd run, as all this is intended to work this way... SQL
Server is run under another privileged account than the current logged
account, which only needs to connect to the specified server and query for
information..
perhaps you have to check your local policies...
> We did get it to work for the non-admin user by using the local
> administrator account for log on (I goofed when trying it the first time
by
> using domain admin password instead of local admin password). This is not
> the way we want to go, but it's the only way it does work right now.
I usually use a local account (not LocalSystem), with enought rights on
relevent share(s) if needed..
> I did find one thing via your link, in the Installation Recommendations:
> "Create a least privileged local account with which to run the SQL Server
> service. Use this account when you are prompted for service settings
during
> setup. Do not use the local system account or an administrator account. "
> There is no prompt when installing MSDE. What exactly is a "least
priviledge
> local account"?
no, there's not... that info is for a full blown SQL Server installation..
you have to set that property after MSDE installed, accessing the services
management applet... perhaps it can be done via WMI, but never tried it..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||more,
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
news:2omoccFcfn07U1@.uni-berlin.de...[vbcol=seagreen]
> hi Leon,
> "LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
> news:eO0WPBthEHA.2908@.TK2MSFTNGP10.phx.gbl...
Local[vbcol=seagreen]
they do not have to... set the service's "start at boostrap" property...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The instructions on the SQLServer Installation Recommendations say to create
a new user, remove it from the users group and use it for the service login.
We created an "msde" user, removed it from Users group, set it as the Log On
As account (it is listed in the "Log on as a service" policy), gave full
access rights for the data files to Everyone, and it doesn't work.
So you have installed MSDE 2000 A and had its service (MSDE$InstanceName)
starting with a non-admin log in?
If so, you must have some magic touch because we're trying this on 2
separate machines with the same failure on each. We'll be trying it on a
fresh XP install shortly, but I don't really expect different results.
Even when logged into the XP as an administrator, setting the MSDE service
login account to "msde" causes the service to fail on a start attempt. It
gives the following error:
Could not start the MSDE$... service on Local Computer.
Error 5: Access is Denied
How do you access the "start at boostrap" property of a service?
thanks,
leon.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2omogoFcbbrgU1@.uni-berlin.de...[vbcol=seagreen]
> more,
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
> news:2omoccFcfn07U1@.uni-berlin.de...
> Local
user
> they do not have to... set the service's "start at boostrap" property...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Leon,
"LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
news:%233zBrHvhEHA.644@.tk2msftngp13.phx.gbl...
> The instructions on the SQLServer Installation Recommendations say to
create
> a new user, remove it from the users group and use it for the service
login.
> We created an "msde" user, removed it from Users group, set it as the Log
On
> As account (it is listed in the "Log on as a service" policy), gave full
> access rights for the data files to Everyone, and it doesn't work.
> So you have installed MSDE 2000 A and had its service (MSDE$InstanceName)
> starting with a non-admin log in?
> If so, you must have some magic touch because we're trying this on 2
> separate machines with the same failure on each. We'll be trying it on a
> fresh XP install shortly, but I don't really expect different results.
> Even when logged into the XP as an administrator, setting the MSDE service
> login account to "msde" causes the service to fail on a start attempt. It
> gives the following error:
> Could not start the MSDE$... service on Local Computer.
> Error 5: Access is Denied
I do always use a local admin account, and I never use the special
LocalSystem account, created just for this purpose and never use an actual
local or domain administrator account. The account must be in the local
Administrators group if you're installing SQL Server on Windows NT or
Windows 2000. You can create this account before you begin installing SQL
Server, or you can change the account under which SQL Server runs at a later
time.
Setting less privileges is intended in not using a Domain Admin account for
network protection.
> How do you access the "start at boostrap" property of a service?
in the service management, select Startup Mode = automatic
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea
Sorry, referring to the automatic service startup as "start at bootstrap"
property is a little different terminology than I am used to. I do
understand the automatic startup option.
We will just include some instructions for setting up the app for non-admin
users.
Thanks for your help.
leon.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2ong8qFcg0ccU1@.uni-berlin.de...[vbcol=seagreen]
> hi Leon,
> "LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
> news:%233zBrHvhEHA.644@.tk2msftngp13.phx.gbl...
> create
> login.
Log[vbcol=seagreen]
> On
(MSDE$InstanceName)[vbcol=seagreen]
service[vbcol=seagreen]
It
> I do always use a local admin account, and I never use the special
> LocalSystem account, created just for this purpose and never use an actual
> local or domain administrator account. The account must be in the local
> Administrators group if you're installing SQL Server on Windows NT or
> Windows 2000. You can create this account before you begin installing SQL
> Server, or you can change the account under which SQL Server runs at a
later
> time.
> Setting less privileges is intended in not using a Domain Admin account
for
> network protection.
> in the service management, select Startup Mode = automatic
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
I'm installing MSDE 2000 with a custom application (launched using
setup.exe, not integrating merge modules) and am having a problem with the
service permissions for SQL services. The custom app installer is being
build with Installshield Pro 6.3.
Everything works fine for admin users, but MSDE won't start for non-admin
users. The MSSQL$Instance service won't start unless it's logging on a Local
System.
I need non-admin users to have access to the database.
Is there any way to setup MSDE on install to work for everyone?
What does one need to do to manually configure it after install to work for
everyone?
Thanks,
leon.
hi Leon,
"LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
news:Oe0QyXhhEHA.904@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I'm installing MSDE 2000 with a custom application (launched using
> setup.exe, not integrating merge modules) and am having a problem with the
> service permissions for SQL services. The custom app installer is being
> build with Installshield Pro 6.3.
> Everything works fine for admin users, but MSDE won't start for non-admin
> users. The MSSQL$Instance service won't start unless it's logging on a
Local
> System.
> I need non-admin users to have access to the database.
> Is there any way to setup MSDE on install to work for everyone?
> What does one need to do to manually configure it after install to work
for
> everyone?
usually MSDE is installed setting the relative services account to
LocalSystem, that provide (far) enought privileges (on the local machine)
for all logged users...
have a look at
http://msdn.microsoft.com/library/de...l/THCMCh18.asp
for more restrictions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
By default the services use Local System option for log on. This worked fine
for all admin users but did not work for a non-admin user. When a non-admin
user logs in (local or domain user), the services won't start using Local
System. (side note: this is on a WinXP Pro machine). The non-admin user
cannot start or stop any service.
We did get it to work for the non-admin user by using the local
administrator account for log on (I goofed when trying it the first time by
using domain admin password instead of local admin password). This is not
the way we want to go, but it's the only way it does work right now.
I did find one thing via your link, in the Installation Recommendations:
"Create a least privileged local account with which to run the SQL Server
service. Use this account when you are prompted for service settings during
setup. Do not use the local system account or an administrator account. "
There is no prompt when installing MSDE. What exactly is a "least priviledge
local account"?
Any other suggestions are most welcome!
Thanks for your help.
leon.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2okhj5Fbml6lU1@.uni-berlin.de...[vbcol=seagreen]
> hi Leon,
> "LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
> news:Oe0QyXhhEHA.904@.TK2MSFTNGP09.phx.gbl...
the[vbcol=seagreen]
non-admin
> Local
> for
> usually MSDE is installed setting the relative services account to
> LocalSystem, that provide (far) enought privileges (on the local machine)
> for all logged users...
> have a look at
>
http://msdn.microsoft.com/library/de...l/THCMCh18.asp
> for more restrictions..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Leon,
"LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
news:eO0WPBthEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi Andrea,
> By default the services use Local System option for log on. This worked
fine
> for all admin users but did not work for a non-admin user. When a
non-admin
> user logs in (local or domain user), the services won't start using Local
> System. (side note: this is on a WinXP Pro machine). The non-admin user
> cannot start or stop any service.
actually they shoul'd run, as all this is intended to work this way... SQL
Server is run under another privileged account than the current logged
account, which only needs to connect to the specified server and query for
information..
perhaps you have to check your local policies...
> We did get it to work for the non-admin user by using the local
> administrator account for log on (I goofed when trying it the first time
by
> using domain admin password instead of local admin password). This is not
> the way we want to go, but it's the only way it does work right now.
I usually use a local account (not LocalSystem), with enought rights on
relevent share(s) if needed..
> I did find one thing via your link, in the Installation Recommendations:
> "Create a least privileged local account with which to run the SQL Server
> service. Use this account when you are prompted for service settings
during
> setup. Do not use the local system account or an administrator account. "
> There is no prompt when installing MSDE. What exactly is a "least
priviledge
> local account"?
no, there's not... that info is for a full blown SQL Server installation..
you have to set that property after MSDE installed, accessing the services
management applet... perhaps it can be done via WMI, but never tried it..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||more,
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
news:2omoccFcfn07U1@.uni-berlin.de...[vbcol=seagreen]
> hi Leon,
> "LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
> news:eO0WPBthEHA.2908@.TK2MSFTNGP10.phx.gbl...
Local[vbcol=seagreen]
they do not have to... set the service's "start at boostrap" property...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The instructions on the SQLServer Installation Recommendations say to create
a new user, remove it from the users group and use it for the service login.
We created an "msde" user, removed it from Users group, set it as the Log On
As account (it is listed in the "Log on as a service" policy), gave full
access rights for the data files to Everyone, and it doesn't work.
So you have installed MSDE 2000 A and had its service (MSDE$InstanceName)
starting with a non-admin log in?
If so, you must have some magic touch because we're trying this on 2
separate machines with the same failure on each. We'll be trying it on a
fresh XP install shortly, but I don't really expect different results.
Even when logged into the XP as an administrator, setting the MSDE service
login account to "msde" causes the service to fail on a start attempt. It
gives the following error:
Could not start the MSDE$... service on Local Computer.
Error 5: Access is Denied
How do you access the "start at boostrap" property of a service?
thanks,
leon.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2omogoFcbbrgU1@.uni-berlin.de...[vbcol=seagreen]
> more,
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
> news:2omoccFcfn07U1@.uni-berlin.de...
> Local
user
> they do not have to... set the service's "start at boostrap" property...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Leon,
"LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
news:%233zBrHvhEHA.644@.tk2msftngp13.phx.gbl...
> The instructions on the SQLServer Installation Recommendations say to
create
> a new user, remove it from the users group and use it for the service
login.
> We created an "msde" user, removed it from Users group, set it as the Log
On
> As account (it is listed in the "Log on as a service" policy), gave full
> access rights for the data files to Everyone, and it doesn't work.
> So you have installed MSDE 2000 A and had its service (MSDE$InstanceName)
> starting with a non-admin log in?
> If so, you must have some magic touch because we're trying this on 2
> separate machines with the same failure on each. We'll be trying it on a
> fresh XP install shortly, but I don't really expect different results.
> Even when logged into the XP as an administrator, setting the MSDE service
> login account to "msde" causes the service to fail on a start attempt. It
> gives the following error:
> Could not start the MSDE$... service on Local Computer.
> Error 5: Access is Denied
I do always use a local admin account, and I never use the special
LocalSystem account, created just for this purpose and never use an actual
local or domain administrator account. The account must be in the local
Administrators group if you're installing SQL Server on Windows NT or
Windows 2000. You can create this account before you begin installing SQL
Server, or you can change the account under which SQL Server runs at a later
time.
Setting less privileges is intended in not using a Domain Admin account for
network protection.
> How do you access the "start at boostrap" property of a service?
in the service management, select Startup Mode = automatic
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea
Sorry, referring to the automatic service startup as "start at bootstrap"
property is a little different terminology than I am used to. I do
understand the automatic startup option.
We will just include some instructions for setting up the app for non-admin
users.
Thanks for your help.
leon.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2ong8qFcg0ccU1@.uni-berlin.de...[vbcol=seagreen]
> hi Leon,
> "LM" <leonm@.vtn-tech.com> ha scritto nel messaggio
> news:%233zBrHvhEHA.644@.tk2msftngp13.phx.gbl...
> create
> login.
Log[vbcol=seagreen]
> On
(MSDE$InstanceName)[vbcol=seagreen]
service[vbcol=seagreen]
It
> I do always use a local admin account, and I never use the special
> LocalSystem account, created just for this purpose and never use an actual
> local or domain administrator account. The account must be in the local
> Administrators group if you're installing SQL Server on Windows NT or
> Windows 2000. You can create this account before you begin installing SQL
> Server, or you can change the account under which SQL Server runs at a
later
> time.
> Setting less privileges is intended in not using a Domain Admin account
for
> network protection.
> in the service management, select Startup Mode = automatic
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Monday, March 26, 2012
MSDE Seems to Install - Service Manager Loads - No Connection
Hi,
I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
..net Standard Edition and tried to reinstall MSDE. The installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I have since uninstalled
Developer Edition to no avail. I am running Windows XP Pro.
Regards
Barry-Jon
hi Barry-Jon,
Microsoft wrote:
> Hi,
> I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
> Edition. I then found I could not use Developer Edition with Visual
> Basic .net Standard Edition and tried to reinstall MSDE. The
> installation seems to go fine but when the Service Manager loads is
> tells me "Not Connected - \\" no servers are in the Server drop-down
> and no services are listed in the Services drop-down. I am very new
> to all of this and would very much appreciate any help/advice you
> could offer. I have since uninstalled Developer Edition to no avail.
> I am running Windows XP Pro.
> Regards
> Barry-Jon
please have a look at
http://support.microsoft.com/default...b;EN-US;814132 ...
you can modify this behaviour enabling the desired/required network protocol
by running the Server Network Utility (svrnetcn.exe)...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Microsoft" <barryjonoconnell_spam_no@.yahoo.co.uk> wrote in message
news:ucCLTwKEFHA.1188@.tk2msftngp13.phx.gbl...
> Hi,
> I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
> Edition. I then found I could not use Developer Edition with Visual Basic
> .net Standard Edition and tried to reinstall MSDE. The installation seems
> to go fine but when the Service Manager loads is tells me "Not Connected -
> \\" no servers are in the Server drop-down and no services are listed in
> the Services drop-down. I am very new to all of this and would very much
> appreciate any help/advice you could offer. I have since uninstalled
> Developer Edition to no avail. I am running Windows XP Pro.
> Regards
> Barry-Jon
I posted this in the vb group as well, but just in case...
I'm not sure you're doing anything wrong, but perhaps the instructions we
use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003
will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior
MSDE installation attempts hanging around. The place to check is: C:\Program
Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL
Server, delete it and its contents!
2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your
MSDE download is). This step will extract the contents of the file to a
designated folder. Make a note of the destination folder. You'll need it
later. This step does not install MSDE (although the dialogs seem to hint
that it does)!
4. Navigate to the folder you created in Step 2. In that folder, you will
find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
SETUP.EXE will install MSDE.
5. To execute SETUP.EXE correctly, you must supply an instance name and a
system administrator password as part of the command: i.e. the command must
be:
SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
where yourSAPassword is your actual system administrator password. This
password is needed only to install MDSE, not to use it. Access to MSDE is
controlled by normal "NT Security" which should allow users access based on
network logon and password. It is very important the the INSTANCENAME
parameter be NetSDK, as this name will enable you to generate the sample
databases automatically instead of having to run SQL scripts from the
command line.
6. Once installation is complete, you must reboot the PC before you will
see MSDE. After the reboot, you should see the MSDE icon in SysTray.
7. You now must execute the file: ConfigSamples.exe to configure sample
applications and MSDE system databases. This step will also create user
databases in the following location: C:\Program Files\Microsoft SQL
Server\MSSQL\Data.
</quote>
If you have trouble locating the ConfigSamples.exe, it's a small file
(56k) and I can send it to your email if needed.
Hope this helps.
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||Thanks Peter - that looks pretty much like what I did in the end. Saved
your post in case I ever forget :-)
"Peter van der Goes" <p_vandergoes@.toadstool.u> wrote in message
news:edfqWhQEFHA.3592@.TK2MSFTNGP15.phx.gbl...
> "Microsoft" <barryjonoconnell_spam_no@.yahoo.co.uk> wrote in message
> news:ucCLTwKEFHA.1188@.tk2msftngp13.phx.gbl...
> I posted this in the vb group as well, but just in case...
> I'm not sure you're doing anything wrong, but perhaps the instructions we
> use for classroom/lab installs of MSDE to work with Visual Studio .NET
> 2003 will be helpful:
> <quote>
> 1. Before you begin, check the PC to ensure there are no remnants of
> prior MSDE installation attempts hanging around. The place to check is:
> C:\Program Files\Microsoft SQL Server. If you locate a folder named
> Microsoft SQL Server, delete it and its contents!
>
> 2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your
> MSDE download is). This step will extract the contents of the file to a
> designated folder. Make a note of the destination folder. You'll need it
> later. This step does not install MSDE (although the dialogs seem to hint
> that it does)!
>
> 4. Navigate to the folder you created in Step 2. In that folder, you will
> find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
> SETUP.EXE will install MSDE.
>
> 5. To execute SETUP.EXE correctly, you must supply an instance name and a
> system administrator password as part of the command: i.e. the command
> must be:
>
> SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
>
> where yourSAPassword is your actual system administrator password. This
> password is needed only to install MDSE, not to use it. Access to MSDE is
> controlled by normal "NT Security" which should allow users access based
> on network logon and password. It is very important the the INSTANCENAME
> parameter be NetSDK, as this name will enable you to generate the sample
> databases automatically instead of having to run SQL scripts from the
> command line.
>
> 6. Once installation is complete, you must reboot the PC before you will
> see MSDE. After the reboot, you should see the MSDE icon in SysTray.
>
> 7. You now must execute the file: ConfigSamples.exe to configure sample
> applications and MSDE system databases. This step will also create user
> databases in the following location: C:\Program Files\Microsoft SQL
> Server\MSSQL\Data.
> </quote>
>
> If you have trouble locating the ConfigSamples.exe, it's a small file
> (56k) and I can send it to your email if needed.
>
> Hope this helps.
>
> --
> Peter [MVP Visual Developer]
> Jack of all trades, master of none.
>
I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
..net Standard Edition and tried to reinstall MSDE. The installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I have since uninstalled
Developer Edition to no avail. I am running Windows XP Pro.
Regards
Barry-Jon
hi Barry-Jon,
Microsoft wrote:
> Hi,
> I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
> Edition. I then found I could not use Developer Edition with Visual
> Basic .net Standard Edition and tried to reinstall MSDE. The
> installation seems to go fine but when the Service Manager loads is
> tells me "Not Connected - \\" no servers are in the Server drop-down
> and no services are listed in the Services drop-down. I am very new
> to all of this and would very much appreciate any help/advice you
> could offer. I have since uninstalled Developer Edition to no avail.
> I am running Windows XP Pro.
> Regards
> Barry-Jon
please have a look at
http://support.microsoft.com/default...b;EN-US;814132 ...
you can modify this behaviour enabling the desired/required network protocol
by running the Server Network Utility (svrnetcn.exe)...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Microsoft" <barryjonoconnell_spam_no@.yahoo.co.uk> wrote in message
news:ucCLTwKEFHA.1188@.tk2msftngp13.phx.gbl...
> Hi,
> I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
> Edition. I then found I could not use Developer Edition with Visual Basic
> .net Standard Edition and tried to reinstall MSDE. The installation seems
> to go fine but when the Service Manager loads is tells me "Not Connected -
> \\" no servers are in the Server drop-down and no services are listed in
> the Services drop-down. I am very new to all of this and would very much
> appreciate any help/advice you could offer. I have since uninstalled
> Developer Edition to no avail. I am running Windows XP Pro.
> Regards
> Barry-Jon
I posted this in the vb group as well, but just in case...
I'm not sure you're doing anything wrong, but perhaps the instructions we
use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003
will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior
MSDE installation attempts hanging around. The place to check is: C:\Program
Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL
Server, delete it and its contents!
2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your
MSDE download is). This step will extract the contents of the file to a
designated folder. Make a note of the destination folder. You'll need it
later. This step does not install MSDE (although the dialogs seem to hint
that it does)!
4. Navigate to the folder you created in Step 2. In that folder, you will
find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
SETUP.EXE will install MSDE.
5. To execute SETUP.EXE correctly, you must supply an instance name and a
system administrator password as part of the command: i.e. the command must
be:
SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
where yourSAPassword is your actual system administrator password. This
password is needed only to install MDSE, not to use it. Access to MSDE is
controlled by normal "NT Security" which should allow users access based on
network logon and password. It is very important the the INSTANCENAME
parameter be NetSDK, as this name will enable you to generate the sample
databases automatically instead of having to run SQL scripts from the
command line.
6. Once installation is complete, you must reboot the PC before you will
see MSDE. After the reboot, you should see the MSDE icon in SysTray.
7. You now must execute the file: ConfigSamples.exe to configure sample
applications and MSDE system databases. This step will also create user
databases in the following location: C:\Program Files\Microsoft SQL
Server\MSSQL\Data.
</quote>
If you have trouble locating the ConfigSamples.exe, it's a small file
(56k) and I can send it to your email if needed.
Hope this helps.
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||Thanks Peter - that looks pretty much like what I did in the end. Saved
your post in case I ever forget :-)
"Peter van der Goes" <p_vandergoes@.toadstool.u> wrote in message
news:edfqWhQEFHA.3592@.TK2MSFTNGP15.phx.gbl...
> "Microsoft" <barryjonoconnell_spam_no@.yahoo.co.uk> wrote in message
> news:ucCLTwKEFHA.1188@.tk2msftngp13.phx.gbl...
> I posted this in the vb group as well, but just in case...
> I'm not sure you're doing anything wrong, but perhaps the instructions we
> use for classroom/lab installs of MSDE to work with Visual Studio .NET
> 2003 will be helpful:
> <quote>
> 1. Before you begin, check the PC to ensure there are no remnants of
> prior MSDE installation attempts hanging around. The place to check is:
> C:\Program Files\Microsoft SQL Server. If you locate a folder named
> Microsoft SQL Server, delete it and its contents!
>
> 2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your
> MSDE download is). This step will extract the contents of the file to a
> designated folder. Make a note of the destination folder. You'll need it
> later. This step does not install MSDE (although the dialogs seem to hint
> that it does)!
>
> 4. Navigate to the folder you created in Step 2. In that folder, you will
> find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
> SETUP.EXE will install MSDE.
>
> 5. To execute SETUP.EXE correctly, you must supply an instance name and a
> system administrator password as part of the command: i.e. the command
> must be:
>
> SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
>
> where yourSAPassword is your actual system administrator password. This
> password is needed only to install MDSE, not to use it. Access to MSDE is
> controlled by normal "NT Security" which should allow users access based
> on network logon and password. It is very important the the INSTANCENAME
> parameter be NetSDK, as this name will enable you to generate the sample
> databases automatically instead of having to run SQL scripts from the
> command line.
>
> 6. Once installation is complete, you must reboot the PC before you will
> see MSDE. After the reboot, you should see the MSDE icon in SysTray.
>
> 7. You now must execute the file: ConfigSamples.exe to configure sample
> applications and MSDE system databases. This step will also create user
> databases in the following location: C:\Program Files\Microsoft SQL
> Server\MSSQL\Data.
> </quote>
>
> If you have trouble locating the ConfigSamples.exe, it's a small file
> (56k) and I can send it to your email if needed.
>
> Hope this helps.
>
> --
> Peter [MVP Visual Developer]
> Jack of all trades, master of none.
>
Friday, March 23, 2012
MSDE Productcode
Hello,
I am installing MSDE along with my app using the MS Toolkit. When I install MSDE and then my app, everything works fine. However if later I uninstall my app (not MSDE instance) and rerun the setup.exe, it disables my app setup saying that MSDE prerequis
ite has to be installed. But MSDE is already on my machine as I did not uninstall it.
Someone pointed out that the productcode should remain the same for the setup. But I never change it. It's a fixed GUID.
Any ideas anyone. Thanks
Dev,
This is a known issue with the RC build of the Toolkit. We'll be fixing it
for RTM.
Cheers,
Brian A. Randell
MCW Technologies
"dev" <anonymous@.discussions.microsoft.com> wrote in message
news:2A575001-D9A3-47EA-9142-C1E5546D3CD8@.microsoft.com...
> Hello,
> I am installing MSDE along with my app using the MS Toolkit. When I
install MSDE and then my app, everything works fine. However if later I
uninstall my app (not MSDE instance) and rerun the setup.exe, it disables my
app setup saying that MSDE prerequisite has to be installed. But MSDE is
already on my machine as I did not uninstall it.
> Someone pointed out that the productcode should remain the same for the
setup. But I never change it. It's a fixed GUID.
> Any ideas anyone. Thanks
|||Great, Thanks
|||On Tue, 27 Apr 2004 16:33:49 -0700, "Brian A. Randell"
<brianr@.nospam.mcwtech.com> wrote:
>Dev,
>This is a known issue with the RC build of the Toolkit. We'll be fixing it
>for RTM.
Any indication of when that might be?
|||Dates are a funny thing. They move. In time for Tech Ed US is our goal. But
as always, could be sooner or later.
Cheers,
Brian A. Randell
MCW Technologies
"Brady Kelly" <bkelly@.icom-it.co.za> wrote in message
news:e6iv80praetf3cp77legif9a1i4tloovre@.4ax.com... [vbcol=seagreen]
> On Tue, 27 Apr 2004 16:33:49 -0700, "Brian A. Randell"
> <brianr@.nospam.mcwtech.com> wrote:
it
> Any indication of when that might be?
I am installing MSDE along with my app using the MS Toolkit. When I install MSDE and then my app, everything works fine. However if later I uninstall my app (not MSDE instance) and rerun the setup.exe, it disables my app setup saying that MSDE prerequis
ite has to be installed. But MSDE is already on my machine as I did not uninstall it.
Someone pointed out that the productcode should remain the same for the setup. But I never change it. It's a fixed GUID.
Any ideas anyone. Thanks
Dev,
This is a known issue with the RC build of the Toolkit. We'll be fixing it
for RTM.
Cheers,
Brian A. Randell
MCW Technologies
"dev" <anonymous@.discussions.microsoft.com> wrote in message
news:2A575001-D9A3-47EA-9142-C1E5546D3CD8@.microsoft.com...
> Hello,
> I am installing MSDE along with my app using the MS Toolkit. When I
install MSDE and then my app, everything works fine. However if later I
uninstall my app (not MSDE instance) and rerun the setup.exe, it disables my
app setup saying that MSDE prerequisite has to be installed. But MSDE is
already on my machine as I did not uninstall it.
> Someone pointed out that the productcode should remain the same for the
setup. But I never change it. It's a fixed GUID.
> Any ideas anyone. Thanks
|||Great, Thanks
|||On Tue, 27 Apr 2004 16:33:49 -0700, "Brian A. Randell"
<brianr@.nospam.mcwtech.com> wrote:
>Dev,
>This is a known issue with the RC build of the Toolkit. We'll be fixing it
>for RTM.
Any indication of when that might be?
|||Dates are a funny thing. They move. In time for Tech Ed US is our goal. But
as always, could be sooner or later.
Cheers,
Brian A. Randell
MCW Technologies
"Brady Kelly" <bkelly@.icom-it.co.za> wrote in message
news:e6iv80praetf3cp77legif9a1i4tloovre@.4ax.com... [vbcol=seagreen]
> On Tue, 27 Apr 2004 16:33:49 -0700, "Brian A. Randell"
> <brianr@.nospam.mcwtech.com> wrote:
it
> Any indication of when that might be?
MSDE Problems
I am having sever troubles installing msde. I download the sql2kdesksp3 from microsoft and then I run it. Nothing is installed! I have to do statements in command prompt, statesment which I dont understand and im probably not doing them right either. After a lot of testing and trying I finally got it installed. But it didnt say MSSQL$NetSDK as it is showed in my book, it said MSSQL Server. And from on there Im stuck. I have tried to add a connection in vs.net as it says with (local)NetSDK but it just says it cant open a connection. My computer name is Kris, I think I should use that instead of (local) and I dont know at all what they mean by NetSDK.
Can anyone help me?
That will give you a list of all the Sql Server and MSDEs on your computer. Hopefully one will by Kris\SomeInstanceName. Try that name or whatever name turns up.
That should correspond to one of the name returned by osql -L
Can anyone help me?
Regards Kristoffer
Windows XPI'm not an MSDE install expert by any means but I would go out to the command prompt (Start->Run->cmd->OK) and type in
osql -L
That will give you a list of all the Sql Server and MSDEs on your computer. Hopefully one will by Kris\SomeInstanceName. Try that name or whatever name turns up.
You might also check in the Setup.Ini file that is in the same directory as you installed MSDE from. If you open it in Notepad or equivalent tool look for the
INSTANCENAME=SomeInstanceName
That should correspond to one of the name returned by osql -L
(local) is an all purpose name that just means "use this server".sql
MSDE over the network
Please help! I've had this problem for FOREVER. It's driving me batty.
I'm installing MSDE in a networked environment. I'm using SQL-DMO to find all
instances of MSDE on the network. *Usually*, this works great.
Unfortunately, sometimes MSDE instances refuse to advertise on the network.
I can't register them in Enterprise Manager or see them with SQL-DMO. I'm
using setup.exe to install these instances, and I'm setting
DISABLENETWORKPROTOCOLS=0. I've run the svrnetcn.exe program, and each
vanished instance is in fact listening via TCP/IP and Remote Procedure Calls.
I've added each instance as an exception in the Windows Firewall on XP SP2.
Each disappeared instance has in fact been started. Local applications can
see these vanished instances, but networked applications cannot. There are no
other firewalls or packet filtering on the network. I'm behind a Microsoft
Wireless Base Station Router. Am I missing something?
This problem is about to drive me insane. I'm using the exact same
installation program and parameters to setup.exe, but some instances just
don't want to play on the network. Any help would be greatly appreciated.
Thanks in advance.
Rob Reagan
rob at digitallabsinc.com
Are any of the MSDE instances installed on XP SP2? If the MSDE instance does
not have SP3 installed then XP will block MSDE from broadcasting its status.
You can see warnings about this in the system event log. This is the same
with Windows Server 2003.
Jim
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:ED94255F-732F-4DFF-B994-CEAD94B90354@.microsoft.com...
> Please help! I've had this problem for FOREVER. It's driving me batty.
> I'm installing MSDE in a networked environment. I'm using SQL-DMO to find
all
> instances of MSDE on the network. *Usually*, this works great.
> Unfortunately, sometimes MSDE instances refuse to advertise on the
network.
> I can't register them in Enterprise Manager or see them with SQL-DMO. I'm
> using setup.exe to install these instances, and I'm setting
> DISABLENETWORKPROTOCOLS=0. I've run the svrnetcn.exe program, and each
> vanished instance is in fact listening via TCP/IP and Remote Procedure
Calls.
> I've added each instance as an exception in the Windows Firewall on XP
SP2.
> Each disappeared instance has in fact been started. Local applications can
> see these vanished instances, but networked applications cannot. There are
no
> other firewalls or packet filtering on the network. I'm behind a Microsoft
> Wireless Base Station Router. Am I missing something?
> This problem is about to drive me insane. I'm using the exact same
> installation program and parameters to setup.exe, but some instances just
> don't want to play on the network. Any help would be greatly appreciated.
> Thanks in advance.
> Rob Reagan
> rob at digitallabsinc.com
>
|||YOU ARE THE MAN! Thanks so much for that response.
"Jim Young" wrote:
> Are any of the MSDE instances installed on XP SP2? If the MSDE instance does
> not have SP3 installed then XP will block MSDE from broadcasting its status.
> You can see warnings about this in the system event log. This is the same
> with Windows Server 2003.
> Jim
> "Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
> news:ED94255F-732F-4DFF-B994-CEAD94B90354@.microsoft.com...
> all
> network.
> Calls.
> SP2.
> no
>
>
I'm installing MSDE in a networked environment. I'm using SQL-DMO to find all
instances of MSDE on the network. *Usually*, this works great.
Unfortunately, sometimes MSDE instances refuse to advertise on the network.
I can't register them in Enterprise Manager or see them with SQL-DMO. I'm
using setup.exe to install these instances, and I'm setting
DISABLENETWORKPROTOCOLS=0. I've run the svrnetcn.exe program, and each
vanished instance is in fact listening via TCP/IP and Remote Procedure Calls.
I've added each instance as an exception in the Windows Firewall on XP SP2.
Each disappeared instance has in fact been started. Local applications can
see these vanished instances, but networked applications cannot. There are no
other firewalls or packet filtering on the network. I'm behind a Microsoft
Wireless Base Station Router. Am I missing something?
This problem is about to drive me insane. I'm using the exact same
installation program and parameters to setup.exe, but some instances just
don't want to play on the network. Any help would be greatly appreciated.
Thanks in advance.
Rob Reagan
rob at digitallabsinc.com
Are any of the MSDE instances installed on XP SP2? If the MSDE instance does
not have SP3 installed then XP will block MSDE from broadcasting its status.
You can see warnings about this in the system event log. This is the same
with Windows Server 2003.
Jim
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:ED94255F-732F-4DFF-B994-CEAD94B90354@.microsoft.com...
> Please help! I've had this problem for FOREVER. It's driving me batty.
> I'm installing MSDE in a networked environment. I'm using SQL-DMO to find
all
> instances of MSDE on the network. *Usually*, this works great.
> Unfortunately, sometimes MSDE instances refuse to advertise on the
network.
> I can't register them in Enterprise Manager or see them with SQL-DMO. I'm
> using setup.exe to install these instances, and I'm setting
> DISABLENETWORKPROTOCOLS=0. I've run the svrnetcn.exe program, and each
> vanished instance is in fact listening via TCP/IP and Remote Procedure
Calls.
> I've added each instance as an exception in the Windows Firewall on XP
SP2.
> Each disappeared instance has in fact been started. Local applications can
> see these vanished instances, but networked applications cannot. There are
no
> other firewalls or packet filtering on the network. I'm behind a Microsoft
> Wireless Base Station Router. Am I missing something?
> This problem is about to drive me insane. I'm using the exact same
> installation program and parameters to setup.exe, but some instances just
> don't want to play on the network. Any help would be greatly appreciated.
> Thanks in advance.
> Rob Reagan
> rob at digitallabsinc.com
>
|||YOU ARE THE MAN! Thanks so much for that response.
"Jim Young" wrote:
> Are any of the MSDE instances installed on XP SP2? If the MSDE instance does
> not have SP3 installed then XP will block MSDE from broadcasting its status.
> You can see warnings about this in the system event log. This is the same
> with Windows Server 2003.
> Jim
> "Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
> news:ED94255F-732F-4DFF-B994-CEAD94B90354@.microsoft.com...
> all
> network.
> Calls.
> SP2.
> no
>
>
Wednesday, March 21, 2012
MSDE on win98 / WinME
I have a lot of problems installing MSDE on a Win98 and WinME computer.
Most of the time SQL Server will not start.
If I am lucky and SQL Server will start I can not create a Database.
It will pop up a message 42000 18452.
Any ideas how to solve this?
hi Peter,
Peter Herijgers wrote:
> I have a lot of problems installing MSDE on a Win98 and WinME
> computer. Most of the time SQL Server will not start.
> If I am lucky and SQL Server will start I can not create a Database.
> It will pop up a message 42000 18452.
> Any ideas how to solve this?
as per
http://msdn.microsoft.com/library/de...rview_74vn.asp ,
MSDE should be supported on Win98/ME, but actually I never installed it on
that platform...
what is the "verbose" message you got along with the 42000 exception?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If have installed WinME on a brand new computer with all the latest updates.
Installing MSDE is going well but if I want to access the database the
following error appears:
SQL Server Error: SQL State: 42000, SQL Error Code: 18452
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
MSDTC and SQL Server Agent are turned off.
SQL Server is turned on.
I installed MSDE with the following parameters:
[OPTIONS]
INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
Thanks
"Andrea Montanari" wrote:
> hi Peter,
> Peter Herijgers wrote:
> as per
> http://msdn.microsoft.com/library/de...rview_74vn.asp ,
> MSDE should be supported on Win98/ME, but actually I never installed it on
> that platform...
> what is the "verbose" message you got along with the 42000 exception?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||BTW
The password for login on ME is different then the MSDE password.
I don't know if this would cause any problems.
"Peter Herijgers" wrote:
[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||hi Peter,
Peter Herijgers wrote:
> If have installed WinME on a brand new computer with all the latest
> updates. Installing MSDE is going well but if I want to access the
> database the following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
are you mixing up trusted connection with user defined credentials for
login?
how and with what tool are you trying to connect to the MSDE instance?
if you use oSql.exe, the command line tool provided with MSDE, you have 2
different ways to connect..
specifying a trusted WinNT connection,
c:\...\>osql.exe -E -S(Local)
or with a standard SQL Server authenticated connection,
c:\..\>osql.exe -Usa -Pyourpwd -S(Local)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Again,
BTW, can you please verify the mixed mode authentication is enabled?..
run regsvr32.exe, locate the registry "LoginMode" key as indicated in
http://support.microsoft.com/default...b;en-us;285097 and verify
it's value is 2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I recently installed quite a few MSDE (SP3) on laptops for one of my apps
(Win2K and WinXP SP2). I found that the SQL Security was not enabled in
spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
to figure it out why. I simply went to Windows Registry to manually enable
SQL Security mode:
HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
set it to 2.
This will enable SQL Security mode, which is used for Win9x & ME.
"Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest
> updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v
> C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||Maybe I have made a big mistake but it is running now.
On a WinXP machine I code the following (Delphi):
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=MyName');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=True');
I have changed this into:
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=sa');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=False');
Now it works very find.
It runs on both Win98 and WinXP.
Thanks.
"Norman Yuan" wrote:
> I recently installed quite a few MSDE (SP3) on laptops for one of my apps
> (Win2K and WinXP SP2). I found that the SQL Security was not enabled in
> spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
> to figure it out why. I simply went to Windows Registry to manually enable
> SQL Security mode:
> HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
> set it to 2.
> This will enable SQL Security mode, which is used for Win9x & ME.
> "Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
> message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...
>
>
sql
Most of the time SQL Server will not start.
If I am lucky and SQL Server will start I can not create a Database.
It will pop up a message 42000 18452.
Any ideas how to solve this?
hi Peter,
Peter Herijgers wrote:
> I have a lot of problems installing MSDE on a Win98 and WinME
> computer. Most of the time SQL Server will not start.
> If I am lucky and SQL Server will start I can not create a Database.
> It will pop up a message 42000 18452.
> Any ideas how to solve this?
as per
http://msdn.microsoft.com/library/de...rview_74vn.asp ,
MSDE should be supported on Win98/ME, but actually I never installed it on
that platform...
what is the "verbose" message you got along with the 42000 exception?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If have installed WinME on a brand new computer with all the latest updates.
Installing MSDE is going well but if I want to access the database the
following error appears:
SQL Server Error: SQL State: 42000, SQL Error Code: 18452
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
MSDTC and SQL Server Agent are turned off.
SQL Server is turned on.
I installed MSDE with the following parameters:
[OPTIONS]
INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
Thanks
"Andrea Montanari" wrote:
> hi Peter,
> Peter Herijgers wrote:
> as per
> http://msdn.microsoft.com/library/de...rview_74vn.asp ,
> MSDE should be supported on Win98/ME, but actually I never installed it on
> that platform...
> what is the "verbose" message you got along with the 42000 exception?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||BTW
The password for login on ME is different then the MSDE password.
I don't know if this would cause any problems.
"Peter Herijgers" wrote:
[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||hi Peter,
Peter Herijgers wrote:
> If have installed WinME on a brand new computer with all the latest
> updates. Installing MSDE is going well but if I want to access the
> database the following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
are you mixing up trusted connection with user defined credentials for
login?
how and with what tool are you trying to connect to the MSDE instance?
if you use oSql.exe, the command line tool provided with MSDE, you have 2
different ways to connect..
specifying a trusted WinNT connection,
c:\...\>osql.exe -E -S(Local)
or with a standard SQL Server authenticated connection,
c:\..\>osql.exe -Usa -Pyourpwd -S(Local)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Again,
BTW, can you please verify the mixed mode authentication is enabled?..
run regsvr32.exe, locate the registry "LoginMode" key as indicated in
http://support.microsoft.com/default...b;en-us;285097 and verify
it's value is 2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I recently installed quite a few MSDE (SP3) on laptops for one of my apps
(Win2K and WinXP SP2). I found that the SQL Security was not enabled in
spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
to figure it out why. I simply went to Windows Registry to manually enable
SQL Security mode:
HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
set it to 2.
This will enable SQL Security mode, which is used for Win9x & ME.
"Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest
> updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v
> C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||Maybe I have made a big mistake but it is running now.
On a WinXP machine I code the following (Delphi):
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=MyName');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=True');
I have changed this into:
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=sa');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=False');
Now it works very find.
It runs on both Win98 and WinXP.
Thanks.
"Norman Yuan" wrote:
> I recently installed quite a few MSDE (SP3) on laptops for one of my apps
> (Win2K and WinXP SP2). I found that the SQL Security was not enabled in
> spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
> to figure it out why. I simply went to Windows Registry to manually enable
> SQL Security mode:
> HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
> set it to 2.
> This will enable SQL Security mode, which is used for Win9x & ME.
> "Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
> message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...
>
>
sql
MSDE Not installing
I am running Windows XP Pro. When trying to install MSDE, sql2ksp3, i go to the command line and enter:
setup SAPWD=somegreatpassword SECURITYMODE=SQL and off it goes, gathering information and starting to install.
setup SAPWD=somegreatpassword SECURITYMODE=SQL and off it goes, gathering information and starting to install.
After a short period of time where the status bar shows about 9 seconds left the status bar runs backwards down to zero and installation stops.
No error message, no crashes, just packs up its tent and goes away.
I have tried running setup from a batch file with the same results.
I have turned off my antivirus program as well as all other programs.
Need Input! - Thanks - T.C.nothing in the System error log?|||Still have the probl if you modify msde setup.ini to install?
e.g.
----------------------------
TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Binn"
DATADIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Data"
INSTANCENAME="MyInstance"
SECURITYMODE="SQL"
SAPWD="mysapassword"
----------------------------|||Thanks for the tries but...
Adjusting the ini gave me the same negative results.
System Event viewer just tracked that Installer was used.
Application Event viewer returned error message:
"Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
and when i follow link to web site i am told Sorry but no help here.|||Hi, I am having the same problem. I have done a bit of research on the net and the MS knowledge base and come up with the following kb article...
http://support.microsoft.com/default.aspx?scid=kb;[LN];816499|||And seeHOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Instance|||thank you one and all for try but alas to no avail. I have not a previous version of SQL so i am a bit stuck.|||You can try to open RPC services, and Server Services.
They are in control pad.|||I have found what it was, I also was having the problem. You have to start the service Server started, even if it is Manual, you will still need to start it.
In the instalation docs for MSDE SP3 under Install Log Verbose at the bottom to look for "Value 3", and withing 10 lines of that you find the item that failed. I found "InstallSQLAgentSecurity failed..." I then proceeded to do a search for that on Technet and low and behold there it was. in the very first sentance of "829386 - You Cannot Install MSDE 2000 if the Server Service Is Not Running" it says you need the Server service running.|||I had the same problem, with my Windows XP home. I worked on it for 4 hours, the problem was that you have to have a network set-up on your computer. so I entered into setting up a home network wizard, windows installed all the components and then I installed the MSDE. Worked like a charm. So the way to solve this is to start the network Wizard! and then install MSDE.
Thanks guys.sql
Monday, March 19, 2012
MSDE login problem
After installing MSDE 2000 in mixed mode local access worked fine.
Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.
Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.
Anyone know why?
thanks in advanceAfter that login by SQL user and password is denied after restart local MSDE machine
With this I mean access from other machines on the network. Local login is working ok.|||Solution found!
Install MSDE again with DISABLENETWORKPROTOCOLS=0.
Changing it afterwards with SQL Server enterprice manager doesn't work.
just for those who are having the same problem
Monday, March 12, 2012
MSDE Lockdown scripts
We are installing MSDE along with one of our applications.
But with the current security threats, we want to make sure
that the installed MSDE is secure. So is there any lock
down scripts available publicly that can be used for the same.
Thanks in Advance.
hi,
"Arunkumar Viswanathan" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:012101c4904c$0eea0af0$a401280a@.phx.gbl...
> We are installing MSDE along with one of our applications.
> But with the current security threats, we want to make sure
> that the installed MSDE is secure. So is there any lock
> down scripts available publicly that can be used for the same.
not that I'm aware of... anyway, MSDE installs by default disabling network
protocols and with Windows NT authentication only... you only have to set a
strong "sa" password...
this is the *standard*, and should be quite secure... but usually you will
need remote connections (which require TCP/IP or other preferred network
protocol to be enabled) ... if you do not need SQL Server authenticated
connections, you can go with the default "trusted" only...
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 Andrea,
Thanks for replying. As you rightly said the we have to
provide a strong password to the sa user. But generally in
a stand alone MSDE installation some stored procedures are
given public previleges and that can cause problems with
advanced users. So if you of know of any lock down scripts
pls post the link here.
Thanks
Arunkumar
>--Original Message--
>not that I'm aware of... anyway, MSDE installs by default
disabling network
>protocols and with Windows NT authentication only... you
only have to set a
>strong "sa" password...
>this is the *standard*, and should be quite secure... but
usually you will
>need remote connections (which require TCP/IP or other
preferred network
>protocol to be enabled) ... if you do not need SQL Server
authenticated
>connections, you can go with the default "trusted" only...
>--
>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 Arunkumar,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:452d01c49052$8853d550$a601280a@.phx.gbl...
> Hi Andrea,
> Thanks for replying. As you rightly said the we have to
> provide a strong password to the sa user. But generally in
> a stand alone MSDE installation some stored procedures are
> given public previleges and that can cause problems with
> advanced users. So if you of know of any lock down scripts
> pls post the link here.
again... unfortunately I do not know one :-(
but, again, it all depends on what you want to secure...
if you mean system stored procedures, usually (at least the problematic,
like xp_cmdshell and so on) they are "protected" requiring sysadmins
privileges
on the other side, if you mena your own procedures, it' up to you to remove
"guest" permission to them =;-D
so I usually remove guest login and deny public involvement... and I do
manage privileges in user's groups...
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
But with the current security threats, we want to make sure
that the installed MSDE is secure. So is there any lock
down scripts available publicly that can be used for the same.
Thanks in Advance.
hi,
"Arunkumar Viswanathan" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:012101c4904c$0eea0af0$a401280a@.phx.gbl...
> We are installing MSDE along with one of our applications.
> But with the current security threats, we want to make sure
> that the installed MSDE is secure. So is there any lock
> down scripts available publicly that can be used for the same.
not that I'm aware of... anyway, MSDE installs by default disabling network
protocols and with Windows NT authentication only... you only have to set a
strong "sa" password...
this is the *standard*, and should be quite secure... but usually you will
need remote connections (which require TCP/IP or other preferred network
protocol to be enabled) ... if you do not need SQL Server authenticated
connections, you can go with the default "trusted" only...
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 Andrea,
Thanks for replying. As you rightly said the we have to
provide a strong password to the sa user. But generally in
a stand alone MSDE installation some stored procedures are
given public previleges and that can cause problems with
advanced users. So if you of know of any lock down scripts
pls post the link here.
Thanks
Arunkumar
>--Original Message--
>not that I'm aware of... anyway, MSDE installs by default
disabling network
>protocols and with Windows NT authentication only... you
only have to set a
>strong "sa" password...
>this is the *standard*, and should be quite secure... but
usually you will
>need remote connections (which require TCP/IP or other
preferred network
>protocol to be enabled) ... if you do not need SQL Server
authenticated
>connections, you can go with the default "trusted" only...
>--
>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 Arunkumar,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:452d01c49052$8853d550$a601280a@.phx.gbl...
> Hi Andrea,
> Thanks for replying. As you rightly said the we have to
> provide a strong password to the sa user. But generally in
> a stand alone MSDE installation some stored procedures are
> given public previleges and that can cause problems with
> advanced users. So if you of know of any lock down scripts
> pls post the link here.
again... unfortunately I do not know one :-(
but, again, it all depends on what you want to secure...
if you mean system stored procedures, usually (at least the problematic,
like xp_cmdshell and so on) they are "protected" requiring sysadmins
privileges
on the other side, if you mena your own procedures, it' up to you to remove
"guest" permission to them =;-D
so I usually remove guest login and deny public involvement... and I do
manage privileges in user's groups...
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 Intstallation Problem
Hallo!
When installing MSDE (run setup) the process starts; when it is nearly at the end (progbar rigth), then suddenly the progbar goes very quick to the left side and the installtion is over.
There ist no error msg or something like that. The only event code is 11708(information) from the msi installer.
I have an XP pro System (not SP2).
Thx in advance for helpsry double post|||I'm also having this same problem, except I'm running XP Home.
I'm using the MSDE that comes with the [b]SAMS Teach Yourself ASP.NET In 24 Hours[/b] book, and after I've typed in the command line:
setup SAPWD=password SECURITYMODE=sql
it begins to install. Then after the green bar goes back to left the dialog box closes and then nothing happens. According to the book I should be promted to resart my computer, but I'm not. And the MSDE icon doesn't appear in the system tray.
I've tried restarting my cmputer manually and also downloading MSDE from http://asp.net/msde but the same thing happens.|||Please refer to my post in this section under the subject: "Overcoming MSDE Setup Problems".
Link: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=739042|||Here is the log file
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
MSI (s) (A0:D0): QueryPathOfRegTypeLib returned -2147319779 in local context. Path is ''
MSI (s) (A0:D0): CMsiServices::ProcessTypeLibrary runs in local context, not impersonated.
MSI (s) (A0:D0): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (A0:D0): Executing op: ActionStart(Name=InstallServices,Description=Installing new services,Template=Service: )
Action 20:21:56: InstallServices. Installing new services
MSI (s) (A0:D0): Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (A0:D0): Executing op: ServiceInstall(Name=SQLAgent$MATRIXDB,DisplayName=SQLAgent$MATRIXDB,ImagePath=D:\programme\Microsoft SQL Server\MSSQL$MATRIXDB\Binn\sqlagent.EXE -i MATRIXDB,ServiceType=16,StartType=3,ErrorControl=1,,Dependencies=MSSQL$MATRI
XDB
MSI (s) (A0:D0): Executing op: ServiceInstall(Name=MSSQL$MATRIXDB,DisplayName=MSSQL$MATRIXDB,ImagePath=D:\programme\Microsoft SQL Server\MSSQL$MATRIXDB\Binn\sqlservr.exe -sMATRIXDB,ServiceType=16,StartType=2,ErrorControl=1,,,,,,)
MSI (s) (A0:D0): Executing op: ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
Action 20:21:57: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (A0:D0): Executing op: CustomActionSchedule(Action=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Source=BinaryData,Target=InstallPerfMon,)
MSI (s) (A0:D0): Creating MSIHANDLE (676) of type 790536 for thread 1744
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOKUME~1\Ifoko\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOKUME~1\Ifoko\LOKALE~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 20:21:57: InstallFinalize. Return value 3.
MSI (s) (A0:D0): User policy value 'DisableRollback' is 0
MSI (s) (A0:D0): Machine policy value 'DisableRollback' is 0
MSI (s) (A0:D0): Executing op: Header(Signature=1397708873,Version=200,Timestamp=829465254,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (A0:D0): Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (A0:D0): Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (A0:D0): Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=,CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: )
Action 20:21:57: Rollback. Rolling back action:
I have XP Pro; tried it with msde2000a too -> same phenomen, rollback before finishing;
Maybay I should delete everything from MSDE out of the registry, because I think there are some keys from old installations, which make trouble.
Anyone an idea ?
espezially: MSI (s) (A0:D0): Creating MSIHANDLE (676) of type 790536 for thread 1744
What does this mean ?
thx|||No one an idea ?
I think the problem is the are bad keys in the registry from old installations. There are still MSSQL$... keys by the legacy settings. But I cant delete them.
plz help|||These MSDE installation errors are frustrating, and there are so many different causes that it can be difficult to help you troubleshoot.
The area to focus on there is "PerfmonLoad routine returned error code 6". See if something in this KB article helps you:A SQL Server Desktop Engine 2000 installation fails when it tries to register Performance Monitor counters.
Terri|||Thx a lot!
I think this is the rigth way.
So next Problem: I think the error comes that I have no permission to update the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009 keys
Its mentioned in the article to have permission to the keys.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\007 (german) I got full permission and I can change the key with regedit.
I run XP Pro (german) and I am the only user (administratror group).
So how could I manage to update the 009 key ?|||Please help :P
So i tried some other things without succsess:
* regional settings to englisch ;(
* deleting everything from reg with "mssql"
* using msizap to remove
Still the problem when installing the performance counters for MSDE.
I looked with regedit at the permissions at the key and I should have full. But I still can not change the key.
lg|||I don't have anything to offer other than what was in the article. Did you follow it step by step from the top down -- including making sure all of the indicated services were turned off?
Sorry not to be more help.
Terri|||"Please help :P
So i tried some other things without succsess:
* regional settings to englisch ;(
* deleting everything from reg with "mssql"
* using msizap to remove
Still the problem when installing the performance counters for MSDE.
I looked with regedit at the permissions at the key and I should have full. But I still can not change the key.
lg "
Have you tried my solution? Use DISABLEROLLBACK=1 and restart. Then delete the installed files and install again. It worked for me. I also tried to delete stuff from the registry with no success. Then I tried the DISABLEROLLBACK route and it worked.
Auf Deutch:
Haben Sie meine Lösung versucht? Verwenden Sie DISABLEROLLBACK=1 und beginnen Sie wieder. Dann löschen Sie die angebrachten Akten und bringen Sie wieder an. Es funktionierte für mich. Ich versuchte auch, Material aus dem Registry ohne Erfolg zu löschen. Dann versuchte ich den DISABLEROLLBACK Weg und es funktionierte.
Now back to English:
I hope this helps. I see you already have posted on my "Overcoming MSDE Setup Problems" thread. Link: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=750253
Friday, March 9, 2012
MSDE installs almost 90% and then uninstalls itself
Hello,
I am having a problem with installing MSDE on one of the Win2K client
machines. The MSDE setup runs to about 90% installation (progress bar shows
at least) and then seems like focus goes away from the setup progress bar and
then progress bar shows uninstalling (it does not say its uninstalling but
the progress bar starts going left instead of going right) and then setup
exits without any prompt.
For the records we are using MSDE released on August 5, 2000.
I can not ask much questions and will have a one time shot more to resolve
this issue on Thursday. Any help will be apreciated.
Regards,
Anis
hi Anis,
"Anis Siddiqy" <Anis Siddiqy@.discussions.microsoft.com> ha scritto nel
messaggio news:343A7271-8F3E-4A0C-8948-6540FD8F89BF@.microsoft.com
> Hello,
> I am having a problem with installing MSDE on one of the Win2K client
> machines. The MSDE setup runs to about 90% installation (progress bar
> shows at least) and then seems like focus goes away from the setup
> progress bar and then progress bar shows uninstalling (it does not
> say its uninstalling but the progress bar starts going left instead
> of going right) and then setup exits without any prompt.
> For the records we are using MSDE released on August 5, 2000.
> I can not ask much questions and will have a one time shot more to
> resolve this issue on Thursday. Any help will be apreciated.
> Regards,
> Anis
please add the
/L*v "c:\MsdeLog.txt"
command line parameter to your setup.exe call
this will enable verbose logging of the installation process (about 2mb)
where you can search for
RETURN VALUE 3
entries that define error conditions... about 10/15 lines after or before
that entries some (sometime a little cryptic) explanation of the problem is
provided..
anyway, before doing, please verify that File and Printer Sharing is set and
that the Server service is running
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
I am having a problem with installing MSDE on one of the Win2K client
machines. The MSDE setup runs to about 90% installation (progress bar shows
at least) and then seems like focus goes away from the setup progress bar and
then progress bar shows uninstalling (it does not say its uninstalling but
the progress bar starts going left instead of going right) and then setup
exits without any prompt.
For the records we are using MSDE released on August 5, 2000.
I can not ask much questions and will have a one time shot more to resolve
this issue on Thursday. Any help will be apreciated.
Regards,
Anis
hi Anis,
"Anis Siddiqy" <Anis Siddiqy@.discussions.microsoft.com> ha scritto nel
messaggio news:343A7271-8F3E-4A0C-8948-6540FD8F89BF@.microsoft.com
> Hello,
> I am having a problem with installing MSDE on one of the Win2K client
> machines. The MSDE setup runs to about 90% installation (progress bar
> shows at least) and then seems like focus goes away from the setup
> progress bar and then progress bar shows uninstalling (it does not
> say its uninstalling but the progress bar starts going left instead
> of going right) and then setup exits without any prompt.
> For the records we are using MSDE released on August 5, 2000.
> I can not ask much questions and will have a one time shot more to
> resolve this issue on Thursday. Any help will be apreciated.
> Regards,
> Anis
please add the
/L*v "c:\MsdeLog.txt"
command line parameter to your setup.exe call
this will enable verbose logging of the installation process (about 2mb)
where you can search for
RETURN VALUE 3
entries that define error conditions... about 10/15 lines after or before
that entries some (sometime a little cryptic) explanation of the problem is
provided..
anyway, before doing, please verify that File and Printer Sharing is set and
that the Server service is running
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 installation problem in Windows XP
Dear All,
We have been facing problems in installing MSDE 2000 in machines having
Windows XP. The installation starts and then after sometime it retraces back.
The error seems to be because of something related to SQLAgentSecurity.
I am attaching the error log details ( the portion which mentions about the
error) below.
Has anyone faced any similar issues? Can anyone help?
Regards,
Ani
Error log details
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 17:11:59: WriteEnvironmentStrings. Updating environment strings
WriteEnvironmentStrings: Name: PATH, Value: c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\, Action 1610612738
Action 17:11:59: RegisterTypeLibraries. Registering type libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
Action 17:12:03: InstallServices. Installing new services
Action 17:12:04: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
Action 17:12:05: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action CallSQLAdHlp
c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
Action 17:12:06: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
Action 17:12:06: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
Action ended 17:12:07: InstallFinalize. Return value 3.
Action 17:12:07: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Rollback: Installing new services
Rollback: Registering type libraries
Rollback: Updating environment strings
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B
Rollback: Writing system registry values
Rollback: Unregistering program identifiers
Rollback: Registering Class servers
Rollback: Creating shortcuts
Rollback: Creating duplicate files
Rollback: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: NoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: RollbackNoRebootReplace.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\SqlSetup\Temp
Rollback: InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Copying new files
Rollback: Creating folders
Rollback: Removing ODBC components
Rollback: Deleting services
Rollback: Stopping services
Rollback: Updating component registration
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
Action ended 17:12:14: INSTALL. Return value 3.
Action ended 17:12:14: INSTALL. Return value 3.
=== Logging stopped: 4/28/2005 17:12:14 ===
MSI (c) (94:24): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
hi,
Aniruddha wrote:
> Dear All,
> We have been facing problems in installing MSDE 2000 in machines
> having Windows XP. The installation starts and then after sometime it
> retraces back. The error seems to be because of something related to
> SQLAgentSecurity.
> InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
> Action ended 17:12:07: InstallFinalize. Return value 3.
you probably do not have File & Printer Sharing Services turned on.
please chek the control panel, Admin Tools - Services and (eventually) set
it to on.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
We have been facing problems in installing MSDE 2000 in machines having
Windows XP. The installation starts and then after sometime it retraces back.
The error seems to be because of something related to SQLAgentSecurity.
I am attaching the error log details ( the portion which mentions about the
error) below.
Has anyone faced any similar issues? Can anyone help?
Regards,
Ani
Error log details
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 17:11:59: WriteEnvironmentStrings. Updating environment strings
WriteEnvironmentStrings: Name: PATH, Value: c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\, Action 1610612738
Action 17:11:59: RegisterTypeLibraries. Registering type libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
Action 17:12:03: InstallServices. Installing new services
Action 17:12:04: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
Action 17:12:05: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action CallSQLAdHlp
c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
Action 17:12:06: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
Action 17:12:06: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
Action ended 17:12:07: InstallFinalize. Return value 3.
Action 17:12:07: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Rollback: Installing new services
Rollback: Registering type libraries
Rollback: Updating environment strings
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B
Rollback: Writing system registry values
Rollback: Unregistering program identifiers
Rollback: Registering Class servers
Rollback: Creating shortcuts
Rollback: Creating duplicate files
Rollback: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: NoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: RollbackNoRebootReplace.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\SqlSetup\Temp
Rollback: InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Copying new files
Rollback: Creating folders
Rollback: Removing ODBC components
Rollback: Deleting services
Rollback: Stopping services
Rollback: Updating component registration
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
Action ended 17:12:14: INSTALL. Return value 3.
Action ended 17:12:14: INSTALL. Return value 3.
=== Logging stopped: 4/28/2005 17:12:14 ===
MSI (c) (94:24): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
hi,
Aniruddha wrote:
> Dear All,
> We have been facing problems in installing MSDE 2000 in machines
> having Windows XP. The installation starts and then after sometime it
> retraces back. The error seems to be because of something related to
> SQLAgentSecurity.
> InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
> Action ended 17:12:07: InstallFinalize. Return value 3.
you probably do not have File & Printer Sharing Services turned on.
please chek the control panel, Admin Tools - Services and (eventually) set
it to on.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)