MSDE SQL Service Manager is not installed

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

MSDE sql express on laptop, error 26

hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
installed during the installation, finally trying to get an sql database to
work, i am a newbie to both Visual studio and SQL, anyway i can see the
database inside server explorer and all its talbles, but when i try to run
the application i get an error has occured while establishing a connection
the the server, When connecting to SQL server 2005, this failure may be
caused by the fact that under the default settings SQL server does not allow
remote connections, (provider SQL network interfaces, error:26 error
locatiang server/instance Specified
i read similar posts in this forum and tried the following
enabled TCP/Ip on the server and client, do i need any of the other
protocols enabled: shared memory is enabled, named pipes is disabled, tcp/ip
is enablaed and VIA is disabled, this is for the server, for the client
shared memory, tcp/ip, named pipes are all enabled while via is disabled
i ran the SQL server surface area configuration and choose the Surface area
configuration for servcies and connections, under there, the radio buttion
for local and remote connection/Using TCP/IP only are selected. so i think
that is ok
i copi8ed a SQL database to a folder in the database and set the connection
using the wizard, i tested the connection and it is ok.
are there other things to do are other places to check,
Possibility 1:
Start the SQL Server Browser Service. SQL Server 2005 Express installs as a
named instance called sqlexpress. The SQL Server Browser Service resolves a
connection attempt of <computer_name>\sqlexpress to a port number. Without
SQL Server Browser, when connecting to a named instance you need to specify
the port number when you connect. And all named instances like SQL Server
2005 listen on dynamic ports, so the port may change when SQL Server is
started.
Possibility 2:
If you are running on a laptop, you may be running on Windows XP, service
pack 2 which automatically turns on the Windows firewall. If you are
connecting from the same server, you should be connecting using Shared
Memory so that won't matter. If you are connecting from another computer,
you may need to open a TCP port, or allow sqlservr.exe to communicate
through the firewall.
If this information is helpful, more information is available at
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Frank Bruhn" <FrankBruhn@.discussions.microsoft.com> wrote in message
news:E96EEA76-4277-4D80-8B75-79D945744E95@.microsoft.com...
> hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
> installed during the installation, finally trying to get an sql database
> to
> work, i am a newbie to both Visual studio and SQL, anyway i can see the
> database inside server explorer and all its talbles, but when i try to run
> the application i get an error has occured while establishing a connection
> the the server, When connecting to SQL server 2005, this failure may be
> caused by the fact that under the default settings SQL server does not
> allow
> remote connections, (provider SQL network interfaces, error:26 error
> locatiang server/instance Specified
> i read similar posts in this forum and tried the following
> enabled TCP/Ip on the server and client, do i need any of the other
> protocols enabled: shared memory is enabled, named pipes is disabled,
> tcp/ip
> is enablaed and VIA is disabled, this is for the server, for the client
> shared memory, tcp/ip, named pipes are all enabled while via is disabled
> i ran the SQL server surface area configuration and choose the Surface
> area
> configuration for servcies and connections, under there, the radio buttion
> for local and remote connection/Using TCP/IP only are selected. so i think
> that is ok
> i copi8ed a SQL database to a folder in the database and set the
> connection
> using the wizard, i tested the connection and it is ok.
> are there other things to do are other places to check,
>
>

MSDE sql express on laptop, error 26

hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
installed during the installation, finally trying to get an sql database to
work, i am a newbie to both Visual studio and SQL, anyway i can see the
database inside server explorer and all its talbles, but when i try to run
the application i get an error has occured while establishing a connection
the the server, When connecting to SQL server 2005, this failure may be
caused by the fact that under the default settings SQL server does not allow
remote connections, (provider SQL network interfaces, error:26 error
locatiang server/instance Specified
i read similar posts in this forum and tried the following
enabled TCP/Ip on the server and client, do i need any of the other
protocols enabled: shared memory is enabled, named pipes is disabled, tcp/i
p
is enablaed and VIA is disabled, this is for the server, for the client
shared memory, tcp/ip, named pipes are all enabled while via is disabled
i ran the SQL server surface area configuration and choose the Surface area
configuration for servcies and connections, under there, the radio buttion
for local and remote connection/Using TCP/IP only are selected. so i think
that is ok
i copi8ed a SQL database to a folder in the database and set the connection
using the wizard, i tested the connection and it is ok.
are there other things to do are other places to check,Possibility 1:
Start the SQL Server Browser Service. SQL Server 2005 Express installs as a
named instance called sqlexpress. The SQL Server Browser Service resolves a
connection attempt of <computer_name>\sqlexpress to a port number. Without
SQL Server Browser, when connecting to a named instance you need to specify
the port number when you connect. And all named instances like SQL Server
2005 listen on dynamic ports, so the port may change when SQL Server is
started.
Possibility 2:
If you are running on a laptop, you may be running on Windows XP, service
pack 2 which automatically turns on the Windows firewall. If you are
connecting from the same server, you should be connecting using Shared
Memory so that won't matter. If you are connecting from another computer,
you may need to open a TCP port, or allow sqlservr.exe to communicate
through the firewall.
If this information is helpful, more information is available at
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Frank Bruhn" <FrankBruhn@.discussions.microsoft.com> wrote in message
news:E96EEA76-4277-4D80-8B75-79D945744E95@.microsoft.com...
> hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
> installed during the installation, finally trying to get an sql database
> to
> work, i am a newbie to both Visual studio and SQL, anyway i can see the
> database inside server explorer and all its talbles, but when i try to run
> the application i get an error has occured while establishing a connection
> the the server, When connecting to SQL server 2005, this failure may be
> caused by the fact that under the default settings SQL server does not
> allow
> remote connections, (provider SQL network interfaces, error:26 error
> locatiang server/instance Specified
> i read similar posts in this forum and tried the following
> enabled TCP/Ip on the server and client, do i need any of the other
> protocols enabled: shared memory is enabled, named pipes is disabled,
> tcp/ip
> is enablaed and VIA is disabled, this is for the server, for the client
> shared memory, tcp/ip, named pipes are all enabled while via is disabled
> i ran the SQL server surface area configuration and choose the Surface
> area
> configuration for servcies and connections, under there, the radio buttion
> for local and remote connection/Using TCP/IP only are selected. so i think
> that is ok
> i copi8ed a SQL database to a folder in the database and set the
> connection
> using the wizard, i tested the connection and it is ok.
> are there other things to do are other places to check,
>
>

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
>

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
>

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
>

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

MSDE Service Accounts

Hi Guys,
Is there a way to specify the accounts under which the MSSQL and Agent
services will run during installation? I did not see an option in the switch
commands in the setup.exe.
Also, changing those accounts without EM seems to be pretty involved. Is
there any other way to change those accounts? I need to be able to change
these accounts for replication.
Thanks,
Maer
Hi,
How to change the startup account:-
1. Control Panel - Admin tools -- Services
2. Double click above the MSSQL Server service
3. In the Log on tab, change the OS user name and enter the password, Click
ok and restart the service.
Note:
Do the same for SQL Agent service.
Thanks
Hari
MCDBA
"Maer" <maer@.auditleverage.com> wrote in message
news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Hi Guys,
> Is there a way to specify the accounts under which the MSSQL and Agent
> services will run during installation? I did not see an option in the
switch
> commands in the setup.exe.
> Also, changing those accounts without EM seems to be pretty involved.
Is
> there any other way to change those accounts? I need to be able to change
> these accounts for replication.
> Thanks,
> Maer
>
|||you need to use an iss file. Check out
Setup Initialization File Details and Advanced Installation Options for more
info on how to do this.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uw%230XxFeEHA.2812@.tk2msftngp13.phx.gbl...
> Hi,
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the MSSQL Server service
> 3. In the Log on tab, change the OS user name and enter the password,
Click[vbcol=seagreen]
> ok and restart the service.
> Note:
> Do the same for SQL Agent service.
> Thanks
> Hari
> MCDBA
>
> "Maer" <maer@.auditleverage.com> wrote in message
> news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
Agent[vbcol=seagreen]
> switch
involved.[vbcol=seagreen]
> Is
change
>
|||Thank you. But isn't this just part of the changes? Don't I also have to
set the right permissions in certain folders and registry keys for the
account I am changing the service to?
I was wondering if there was a utility that would do all that
automatically.
Thanks again,
Maer
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uw%230XxFeEHA.2812@.tk2msftngp13.phx.gbl...
> Hi,
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the MSSQL Server service
> 3. In the Log on tab, change the OS user name and enter the password,
Click[vbcol=seagreen]
> ok and restart the service.
> Note:
> Do the same for SQL Agent service.
> Thanks
> Hari
> MCDBA
>
> "Maer" <maer@.auditleverage.com> wrote in message
> news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
Agent[vbcol=seagreen]
> switch
involved.[vbcol=seagreen]
> Is
change
>

MSDE Service Accounts

Hi Guys,
Is there a way to specify the accounts under which the MSSQL and Agent
services will run during installation? I did not see an option in the switch
commands in the setup.exe.
Also, changing those accounts without EM seems to be pretty involved. Is
there any other way to change those accounts? I need to be able to change
these accounts for replication.
Thanks,
Maer
Hi,
How to change the startup account:-
1. Control Panel - Admin tools -- Services
2. Double click above the MSSQL Server service
3. In the Log on tab, change the OS user name and enter the password, Click
ok and restart the service.
Note:
Do the same for SQL Agent service.
Thanks
Hari
MCDBA
"Maer" <maer@.auditleverage.com> wrote in message
news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Hi Guys,
> Is there a way to specify the accounts under which the MSSQL and Agent
> services will run during installation? I did not see an option in the
switch
> commands in the setup.exe.
> Also, changing those accounts without EM seems to be pretty involved.
Is
> there any other way to change those accounts? I need to be able to change
> these accounts for replication.
> Thanks,
> Maer
>
|||you need to use an iss file. Check out
Setup Initialization File Details and Advanced Installation Options for more
info on how to do this.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uw%230XxFeEHA.2812@.tk2msftngp13.phx.gbl...
> Hi,
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the MSSQL Server service
> 3. In the Log on tab, change the OS user name and enter the password,
Click[vbcol=seagreen]
> ok and restart the service.
> Note:
> Do the same for SQL Agent service.
> Thanks
> Hari
> MCDBA
>
> "Maer" <maer@.auditleverage.com> wrote in message
> news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
Agent[vbcol=seagreen]
> switch
involved.[vbcol=seagreen]
> Is
change
>
|||Thank you. But isn't this just part of the changes? Don't I also have to
set the right permissions in certain folders and registry keys for the
account I am changing the service to?
I was wondering if there was a utility that would do all that
automatically.
Thanks again,
Maer
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uw%230XxFeEHA.2812@.tk2msftngp13.phx.gbl...
> Hi,
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the MSSQL Server service
> 3. In the Log on tab, change the OS user name and enter the password,
Click[vbcol=seagreen]
> ok and restart the service.
> Note:
> Do the same for SQL Agent service.
> Thanks
> Hari
> MCDBA
>
> "Maer" <maer@.auditleverage.com> wrote in message
> news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
Agent[vbcol=seagreen]
> switch
involved.[vbcol=seagreen]
> Is
change
>
sql

MSDE searching for servers on the network.

Hi,
I have a MSDE installation on the network. I have no need though to
talk to any other MSDE servers or visa versa.
Is it possible to stop MSDE looking for other servers on the network
and also stop other servers finding me?
Thanks
Lee
Hi Lee,
Run svrnetcn.exe and disable all network protocols. Access the MSDE using
shared memory instead (use server name (local) ), even choose the "Hide
Server" option in the properties of TCP in that screen.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Lee Farrant" <leefarrant@.hotmail.com> wrote in message
news:97ad5817.0409160016.4e99863a@.posting.google.c om...
> Hi,
> I have a MSDE installation on the network. I have no need though to
> talk to any other MSDE servers or visa versa.
> Is it possible to stop MSDE looking for other servers on the network
> and also stop other servers finding me?
> Thanks
> Lee
|||Hello Greg,
Thanks for your help I will have a look at these settings.
Lee
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message news:<eRyFDDInEHA.1672@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
> Hi Lee,
> Run svrnetcn.exe and disable all network protocols. Access the MSDE using
> shared memory instead (use server name (local) ), even choose the "Hide
> Server" option in the properties of TCP in that screen.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Lee Farrant" <leefarrant@.hotmail.com> wrote in message
> news:97ad5817.0409160016.4e99863a@.posting.google.c om...

MSDE remote connection on Windows Home - Windows Authentication

I installed an MSDE on a PC running Windows Home Edition. I would like
to connect to this MSDE installation from an oher PC using Windows
Authentication.
What do I have to do (add account on Home Edition)
hi,
xavierdaull@.gmail.com wrote:
> I installed an MSDE on a PC running Windows Home Edition. I would like
> to connect to this MSDE installation from an oher PC using Windows
> Authentication.
> What do I have to do (add account on Home Edition)
without a Domain Controller, thought in a Workgroup environment, usually you
should rely on standard SQL Server authenticated connections for remote
ones, as all the authentication features are resolved and managed by the
Domain Controller it self..
you can however setup a local account to map the remote account of the other
machine... that's to say, on your local PC you have to add another account
with the very same "credentials" of other account(s) present on the remote
PCs...
all this (still) works becouse of the underlying OS gets somehow confused
and a sort of "embezzlement" where 2 differents accounts, YourPC\YourAccount
and OtherPC\YourAccount "share" a kind of uniqueness becouse of netbios
intrusion... a preventive netbios connection, even on a share or using NET
USE can help...
but this is not granted to work in future releases or even OS service
packs...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Rel A stops during install

My installation of MSDE Rel A is stopping at the
following point in the log file:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\sqlredis.exe /q:a"
MSI (c) (B0:E4) [16:21:46:280]: Font created. Charset:
Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
Installation of the Microsoft Data Access Components
package failed.
MSI (s) (30!FC) [16:21:48:908]: Product: Microsoft SQL
Server Desktop Engine -- Installation of the Microsoft
Data Access Components package failed.
Action ended 16:21:48: InstallFinalize. Return value 3.
MSI (s) (30:B0) [16:21:48:978]: User policy
value 'DisableRollback' is 0
MSI (s) (30:B0) [16:21:48:978]: Machine policy
value 'DisableRollback' is 0
In order to get package failed comment, I have to "End
Task" on the sqlredis.exe from the task manager. No disk
activity is occuring. I tried on another box that has XP
Pro SP2 installed and it went on just fine.
Is there something installed that is blocking this.
I have the full line of Office products installed.
hi Paul,
Paul Konen wrote:
> My installation of MSDE Rel A is stopping at the
> following point in the log file:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\sqlredis.exe /q:a"
> MSI (c) (B0:E4) [16:21:46:280]: Font created. Charset:
> Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> Installation of the Microsoft Data Access Components
> package failed.
>...
try fixing the MDAC stack, which is currently not available as a refrresh
separated package for Win XP sp 2...
first, locate the mdac.inf file in c:\windows\inf right click and install..
when prompted for a location, point to
c:\windows\servicepackfiles\i386
then when prompted for the XP cd, either load the cd or point to your
\i386...
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
|||Hi Andrea, I tried the fix you described and I stop at the same point.
I have the following in my task manager: (Hope this helps)
setup.exe
setupre.exe
sqlredis.exe
The timer on the Microsoft SqlServer shows 17 seconds. (This may not help)
Is there a install file or something I can modify to not make this install
happen quietly?
Thanks
"Andrea Montanari" wrote:

> hi Paul,
> Paul Konen wrote:
> try fixing the MDAC stack, which is currently not available as a refrresh
> separated package for Win XP sp 2...
> first, locate the mdac.inf file in c:\windows\inf right click and install..
> when prompted for a location, point to
> c:\windows\servicepackfiles\i386
> then when prompted for the XP cd, either load the cd or point to your
> \i386...
> --
> 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
>
>
|||hi Paul,
Paul wrote:
> Hi Andrea, I tried the fix you described and I stop at the same point.
> I have the following in my task manager: (Hope this helps)
> setup.exe
> setupre.exe
> sqlredis.exe
> The timer on the Microsoft SqlServer shows 17 seconds. (This may not
> help)
> Is there a install file or something I can modify to not make this
> install happen quietly?
unfortunately, usually fixing the MDAC stack or manually running the
sqlredis.exe (which actually install/update MDAC) before the re-installation
does the trick....
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
|||I tried to run the sqlredis while the installer was stuck and it didn't yield
any different results. Is there a different place to find the sqlredis that
may work.
Any other information I can provide that may help?
"Andrea Montanari" wrote:

> hi Paul,
> Paul wrote:
> unfortunately, usually fixing the MDAC stack or manually running the
> sqlredis.exe (which actually install/update MDAC) before the re-installation
> does the trick....
> --
> 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
>
>
|||hi Paul,
Paul wrote:
> I tried to run the sqlredis while the installer was stuck and it
> didn't yield any different results. Is there a different place to
> find the sqlredis that may work.
>
nope, as no refresh distribution is available for MDAC 2.8 WinXP sp2...
just a note... you can eventually try downloading and installing the new sp4
from SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE (full sp4 page at
http://www.microsoft.com/downloads/d...displaylang=en)
which include a modified setup that better checks and installs MDAC only
when and if needed..
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
|||hi Paul,
Paul wrote:
> OK, same results when installing under the SP4. Here is a snippet of
> the Log file during installation
no further idea :-(
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
|||Believe it or not, killing setupre.exe with the task manager once your setup
is frozen will allow the install to complete successfully. Not exactly a
Microsoft recommended solution, but it got me unstuck when I read about it
somewhere else.
John
"Paul Konen" wrote:

> My installation of MSDE Rel A is stopping at the
> following point in the log file:
>
|||That took care of it. I was always killing the sqlredis.exe and not setupre.
Thanks
Paul
"Process Patrol" wrote:
[vbcol=seagreen]
> Believe it or not, killing setupre.exe with the task manager once your setup
> is frozen will allow the install to complete successfully. Not exactly a
> Microsoft recommended solution, but it got me unstuck when I read about it
> somewhere else.
> John
> "Paul Konen" wrote:

MSDE rel A installation error

I got an error "Setup failed to configure the server". I
have tried to delete the directory "C:\program
files\microsoft sql sever before installation. But I still
get this error. What should i do?
Thank you very much. I spent a week to install this MSDE
but still failed. I am very desperate...
San
hi San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
> I got an error "Setup failed to configure the server". I
> have tried to delete the directory "C:\program
> files\microsoft sql sever before installation. But I still
> get this error. What should i do?
> Thank you very much. I spent a week to install this MSDE
> but still failed. I am very desperate...
in addition to folder delete, try cealning the Windows Registry too, as
reported in
http://support.microsoft.com/default...;EN-US;Q290991
"Remove a Specific Instance of SQL Server" section...
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
|||Thank you. However, I am confused. It is because that KB
is for those who have sql sever installed before. My
computer did not contains any sql sever before (I think).
Could you give me more hints on what I should delete?
Furthermore, I found a strange registry. It
is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
Should I delete this?
Thank you for your help.
San

>--Original Message--
>hi San,
>"San" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
still
>in addition to folder delete, try cealning the Windows
Registry too, as
>reported in
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q290991
>"Remove a Specific Instance of SQL Server" section...
>--
>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 San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e59401c45553$1386bba0$a101280a@.phx.gbl...
> Thank you. However, I am confused. It is because that KB
> is for those who have sql sever installed before. My
> computer did not contains any sql sever before (I think).
> Could you give me more hints on what I should delete?
> Furthermore, I found a strange registry. It
> is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
> Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
> Should I delete this?
personally I always and only cleared the registry keys reported in the KB
article... as you already read, this does not clear the Windows Installer
registry entries, but I was quiet happy with this method when a MSDE
instance I installed refused to uninstall... I still have this entry in the
Add/Remove programs applet, but I'll remove it ...perhaps =;-D
the hive you notice shoul'd only point to a Temp folder used by the setup
process...
you wrote[vbcol=seagreen]
uncomplete installations can make the system dirty, so you are supposed to
clear it before re-proceeding with new installs...
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
sql

MSDE Reinstall

Have reinstalled MSDE using Command Prompt Installation and received Errors.
Then I proceeded with a Batch.file installation and that seemed to work for the most part.

This is what I used for the Batch.file

setup.exe SAPWD=somename INSTANCENAME=somename SECURITYMODE=SQL

The Problem I ran into is - I can't seem to get the (SQL SERVER SERVICE MANAGER) to connect. I've entered the server name & instancename but so far no luck.

Ive checked - Control Panel/Administive Tools/Services - to make sure that it was installed & Yes it is there. So I Proceeded to start it up. Next I tried to Connect Via SERVER MANGER with no luck.
Then I did a c:\>osql -E check with the Command Line Prompt which returned the following message:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.

Tried again with c:\>osql -E -S
returned the same message.

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.

Not sure what to do at this point any help/advice. Thx/TIA

(MSDE Version: sql2kdesksp3)
OS = XP ProUpdate:

Finally Managed to Connect to (SERVICE MANAGER) So now I have Connection with my server. I had to Specify ServerName\Instancename - and finally managed to connect.

But I can't seem to make a Database Connection In webMatrix. I entered The (USERName & Password Name) with no luck, even tried different combinations but still no luck!! USERNAME:Someusername**** (and) PASSWORD:SomePassword****

Is there a way I can create a New USERNAME & PASSWORD, with the command Line Prompt?
Anyone know how to do this? THX /TIS

Tristen|||view post 446484|||Thank you for Link/replying Bill,

Problem corrected. Reinstalled MSDE & Made a New SQL Authentication Password.|||Did "setup /upgradesp" help you?

MSDE Problem - SQL Server not found or access denied

I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.

After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.

But now when I try to connect to the database using

osql -E -S GregInstance

I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried

osql -E -S localhost

but no luck. Why can it not find the instance of SQL Server?

Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.

Thanks
GregNot to worry, I forgot to add in the name of the pc with a \ before the instance name...

i.e

osql -E -S GREG\GregInstance

MSDE OSQL Utility

Dear all,
I have a question about the OSQL utility and the installation of MSDE. I
tried to install MSDE and SQL Server on the same machine. This should work
some people told me. As a result however my application is no longer showing
me the available servers on the machine. (laptop).
I removed everything and reinstalled only MSDE.
When I use the OSQL utility and enter OSQL -L it says there are no servers.
Should it not say which server is available.
Has anyone experienced this before. My system is no longer showing the
available servers. My application still seems to work because when I type in
the name of the server manually it is located.
How can I solve this problem.
regards,
Danny Gaethofs
hi Danny,
"Danny Gaethofs" <dangaet@.home.nl> ha scritto nel messaggio
news:uAGDu0P4EHA.2404@.TK2MSFTNGP14.phx.gbl
> Dear all,
> I have a question about the OSQL utility and the installation of
> MSDE. I tried to install MSDE and SQL Server on the same machine.
> This should work some people told me. As a result however my
> application is no longer showing me the available servers on the
> machine. (laptop).
> I removed everything and reinstalled only MSDE.
> When I use the OSQL utility and enter OSQL -L it says there are no
> servers. Should it not say which server is available.
> Has anyone experienced this before. My system is no longer showing the
> available servers. My application still seems to work because when I
> type in the name of the server manually it is located.
> How can I solve this problem.
> regards,
> Danny Gaethofs
MSDE installs by default disabling network protocols in order to minimize
external (malicious) attacks, preventing the installed instances to be
available for remote connections and disabling it's broadcast enlisting for
available SQL Server/MSDE instances...
to make it available for remote users and to enable server enlistment you
have to use Server Network Utility (svrnetcn.exe) and enable the
desired/preferred network protocol(s)
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 on machine with SQL Server

Hello,
A named instance of MSDE will be installed on our clients machines along with our VB.Net during the installation. Will this work fine even if the client already has SQL Server on his/her machine. I mean will the installation of named instance of MSDE wor
k smoothly even if SQL Server already exists. If yes, then does that apply for both SQL Server 7 & 2000. If no, then what should I do.
Thanks
dev
You should have no problems, as long as you are installing a uniquely named
instance. This is true even if SQL Server 7 is already installed on the
system.
Jim
"dev" <anonymous@.discussions.microsoft.com> wrote in message
news:B46C4961-748E-47E1-AD22-2A712100428F@.microsoft.com...
> Hello,
> A named instance of MSDE will be installed on our clients machines along
with our VB.Net during the installation. Will this work fine even if the
client already has SQL Server on his/her machine. I mean will the
installation of named instance of MSDE work smoothly even if SQL Server
already exists. If yes, then does that apply for both SQL Server 7 & 2000.
If no, then what should I do.
> Thanks
> dev
sql

MSDE Maintenance Plan

Hello,

I'm trying to configure my MSDE 2000 installation to dump all databases
and transaction logs to disk every night to be backed up by our backup
software. All goes great in configuring the maintenance plan until I get to
the retention part. I want to configure the backup plan so that it'll delete
OLD backup older than 2 days. When I click the 'Remove files older than" box
and choose 2, but there's nothing in the drop-down box where
Hours/Days/Months should be..
If I fudge it and try to edit the job nothing has saved and the job
fails.. Any help is greatly appreciated..

Thanks,
-Mike-"Michael Nostrom" <nostrom@.binghamton.edu.edu> wrote in message news:<40bdfa79$1_2@.bingnews.binghamton.edu>...
> Hello,
> I'm trying to configure my MSDE 2000 installation to dump all databases
> and transaction logs to disk every night to be backed up by our backup
> software. All goes great in configuring the maintenance plan until I get to
> the retention part. I want to configure the backup plan so that it'll delete
> OLD backup older than 2 days. When I click the 'Remove files older than" box
> and choose 2, but there's nothing in the drop-down box where
> Hours/Days/Months should be..
> If I fudge it and try to edit the job nothing has saved and the job
> fails.. Any help is greatly appreciated..
> Thanks,
> -Mike-

I have no idea what the issue is, but perhaps you can give some more
information. Are you using the latest version of MSDE? And which
operating system are you working with? Have you been able to create a
plan successfully on an MSSQL server (if you have one, but since you
have EM I guess you do)? Have you tried reinstalling the client tools,
and have you applied the latest servicepack to the client tools?

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:60cd0137.0406022246.77874ec3@.posting.google.c om...
"Michael Nostrom" <nostrom@.binghamton.edu.edu> wrote in message
news:<40bdfa79$1_2@.bingnews.binghamton.edu>...
> Hello,
> I'm trying to configure my MSDE 2000 installation to dump all
databases
> and transaction logs to disk every night to be backed up by our backup
> software. All goes great in configuring the maintenance plan until I get
to
> the retention part. I want to configure the backup plan so that it'll
delete
> OLD backup older than 2 days. When I click the 'Remove files older than"
box
> and choose 2, but there's nothing in the drop-down box where
> Hours/Days/Months should be..
> If I fudge it and try to edit the job nothing has saved and the job
> fails.. Any help is greatly appreciated..
> Thanks,
> -Mike-

I have no idea what the issue is, but perhaps you can give some more
information. Are you using the latest version of MSDE? And which
operating system are you working with? Have you been able to create a
plan successfully on an MSSQL server (if you have one, but since you
have EM I guess you do)? Have you tried reinstalling the client tools,
and have you applied the latest servicepack to the client tools?

Simon

Windows 2000 SP4
MSDE 2000 (8.00.818) SP3

EM Tools is installed on my workstation for managing other SQL Servers.

I am able to do a simple Dump to Disk, but I want to schedule nightly dumps.

Actually I manually modified the 'Steps' of the backup job and added the
necessary code to get the job to complete successfully..
Thanks anyway Simon...

MSDE log created?

If a /L parameter is not specified for an MSDE installation, is there
any install log created?hi,
swyck wrote:
> If a /L parameter is not specified for an MSDE installation, is there
> any install log created?
nope..
MSDE setup requires the
/L*v "c:\LogFileName.txt"
parameter in order to verbosely log the installation..
\Program Files\Microsoft SQL Server\MSSQL\Install\cnfgsvr.out
restricted log file is generated resulting like (hopefully, if correctly
installed)
"SQL Server has been correctly configured!"
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
-- remove DMO to reply

MSDE instance not running

I have a MSDE installation on a computer with XP
Professional. When logged in to the computer with an
administrator account, the instance of the server runs and
my application works properly. But when logged in as any
user type other than an administrator, the SQL server
doesn't run and, of course, neither does my application.
The computer may ultimately be used by multiple users and I
am interested in being able set up a user(s) to work with
the software without having administrative privileges on
the computer.
Thank you,
Mack Harris
Your MSDE instance is probably setup with Windows authentication and no
logins other than the default ones. SQL Server is running it is just that
other users besides those in the Administrators group cannot connect to the
server. If you want to keep using only Windows authentication you will need
to add logins to the server instance for the users or a group that the users
are a member of and allow them access to your applications database. You
could also switch the instance to use mixed mode authentication and setup
some SQL logins for the users.
"Mack Harris" <mack.harris@.agconnections.com> wrote in message
news:137501c5147d$314e9bf0$a601280a@.phx.gbl...
>I have a MSDE installation on a computer with XP
> Professional. When logged in to the computer with an
> administrator account, the instance of the server runs and
> my application works properly. But when logged in as any
> user type other than an administrator, the SQL server
> doesn't run and, of course, neither does my application.
> The computer may ultimately be used by multiple users and I
> am interested in being able set up a user(s) to work with
> the software without having administrative privileges on
> the computer.
> Thank you,
> Mack Harris
|||I beleive the instance was installed in mixed mode because
SECURITYMODE=SQL is in the setup.ini used on the computer.
When I go to the SQL Service Manager, the Server field is
blank, the Services field is blank, and a "Not Connected"
message is at the bottom of the dialog.
I have been looking at Local Security Settings on the
computer so I could create/modify a windows user group but
I can't find the necessary documentation to do that.
I appreciate your help,
Mack Harris

>--Original Message--
>Your MSDE instance is probably setup with Windows
authentication and no
>logins other than the default ones. SQL Server is running
it is just that
>other users besides those in the Administrators group
cannot connect to the
>server. If you want to keep using only Windows
authentication you will need
>to add logins to the server instance for the users or a
group that the users
>are a member of and allow them access to your applications
database. You
>could also switch the instance to use mixed mode
authentication and setup
>some SQL logins for the users.
>
>"Mack Harris" <mack.harris@.agconnections.com> wrote in
message
>news:137501c5147d$314e9bf0$a601280a@.phx.gbl...
>
>.
>