Showing posts with label stops. Show all posts
Showing posts with label stops. Show all posts

Wednesday, March 28, 2012

MSDE service stops and does not restart, it takes reboot to restar

Dears,
We have a problem with MSDE 2000 installed on win2003, the services get
stoped after some time and it does not restart mannual , it gets start only
after we reboot the system.
Advice us some solutions for the same.
Thanks in Advance.
Dinesh Bhandare.
Hi Dinesh,
If it won't start, there should be something in the system event log to give
you a hint.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Dinesh Bhandare" <DineshBhandare@.discussions.microsoft.com> wrote in
message news:02550A8E-80EC-4FBB-8197-58B0E435FCA4@.microsoft.com...
> Dears,
> We have a problem with MSDE 2000 installed on win2003, the services get
> stoped after some time and it does not restart mannual , it gets start
> only
> after we reboot the system.
> Advice us some solutions for the same.
> Thanks in Advance.
> Dinesh Bhandare.
>
sql

MSDE service manager just stops???

HI every one
I hope i dont sound too dumb here but i am having some problems with MSDE
I have it installed on my local machine and SQL server 2000 is also installed as i use the Enterprise manager to work on my database.
I dont have server software as my OS is win XP pro.
The problem i have is that after a while the MSDE service manager just stops and i cant get it to restart. and the only way is to uninstall it and reinstall.
i have tried to get the 2000 MSDE installed but i seem to not be able to get that working.
It is frustrating as i am developing a databse at home for a client (work experience) but i spend so much time keeping my shonky system running i loose time in developing.
is there somewhere i can learn to set my system up so i can develop a sql DB at home, or am i flogging a dead horsse.
any help greatly appreciated
Greg
Have you looked in the event log for errors?
"GREGO" wrote:

> HI every one
> I hope i dont sound too dumb here but i am having some problems with MSDE
> I have it installed on my local machine and SQL server 2000 is also installed as i use the Enterprise manager to work on my database.
> I dont have server software as my OS is win XP pro.
> The problem i have is that after a while the MSDE service manager just stops and i cant get it to restart. and the only way is to uninstall it and reinstall.
> i have tried to get the 2000 MSDE installed but i seem to not be able to get that working.
> It is frustrating as i am developing a databse at home for a client (work experience) but i spend so much time keeping my shonky system running i loose time in developing.
> is there somewhere i can learn to set my system up so i can develop a sql DB at home, or am i flogging a dead horsse.
> any help greatly appreciated
> Greg
|||Do you mean the windows event log?
i cant access the SQL server log as it is shut down and i cant access it
regards
greg
"Nigel Rivett" wrote:
[vbcol=seagreen]
> Have you looked in the event log for errors?
> "GREGO" wrote:
|||The SQL Server log is just a text file under the SQL Server directory,
normally in the LOG directory. Load the most recent one into Notepad and see
if there are any errors.
Jim
"GREGO" <GREGO@.discussions.microsoft.com> wrote in message
news:B074205A-A3A6-48DB-8EBB-350E3118AFDE@.microsoft.com...[vbcol=seagreen]
> Do you mean the windows event log?
> i cant access the SQL server log as it is shut down and i cant access it
> regards
> greg
> "Nigel Rivett" wrote:
MSDE[vbcol=seagreen]
installed as i use the Enterprise manager to work on my database.[vbcol=seagreen]
stops and i cant get it to restart. and the only way is to uninstall it and
reinstall.[vbcol=seagreen]
to get that working.[vbcol=seagreen]
(work experience) but i spend so much time keeping my shonky system
running i loose time in developing.[vbcol=seagreen]
sql DB at home, or am i flogging a dead horsse.[vbcol=seagreen]

Monday, March 26, 2012

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:

Friday, March 9, 2012

MSDE Installation stops in Command Prompt

Hi,
I am trying to install MSDE from a CD. At the beginning I cunpack all files at C:\sql2ksp3. Then in in Command prompt
I enter C:\sql2ksp3\MSDE>Setup SAPWD=Hello SecurityMode=SQL
The problem is that nothing happens after that. When I press enter another line appears C:\sql2ksp3\MSDE>
but that's about it.
The installation does not continue. Does anybody know how to "push" it a bit so it will continue?
Thanks
Try the post below for the correct file part. Hope this helps.
http://forums.asp.net/955765/ShowPost.aspx

Wednesday, March 7, 2012

MSDE Installation Fails

These are the last 3 lines the log file creates before
the installation stops. Does anyone know how to complete
the installation?
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\sqlredis.exe /q:a"
hi,
"Clete" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:19d401c4ad71$b5f839b0$a301280a@.phx.gbl
> These are the last 3 lines the log file creates before
> the installation stops. Does anyone know how to complete
> the installation?
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\sqlredis.exe /q:a"
try manually installing MDAC 2.7.1 before MSDE ... get MDAC at
http://msdn.microsoft.com/data/Default.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Install Problem

Hello,

I have just purchased a new CPU and when I attempt to install MSDE the
process nears the end and stops, and removes the installed files. If anyonr
has an idea on a correction let me know.

ThanksHi Daro,

Here's what works for me, assuming you want windows and sql server authentication -

setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="Your Password" SECURITYMODE=SQL

Good luck!

"Daro Bruno" <ddbruno@.comcast.net> wrote in message news:<2sednVOAio5CiR_d4p2dnA@.comcast.com>...
> Hello,
> I have just purchased a new CPU and when I attempt to install MSDE the
> process nears the end and stops, and removes the installed files. If anyonr
> has an idea on a correction let me know.
> Thanks|||Thanks for your reply.

I tried your work around but with no luck...I'll keep plugging away at
it.

Thanks again.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Saturday, February 25, 2012

MSDE install - problem

hi,
i want to install MSDE (comes with windows embedded designer)
install stops with following event:
ERROR:
event 19011 source MSSQLServer
FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0.
WARNING:
event 19011 source MSSQLServer
(SpnRegister) : Error 1355.
any suggestions?
hi,
Zabby wrote:
> hi,
> i want to install MSDE (comes with windows embedded designer)
> install stops with following event:
> ERROR:
> event 19011 source MSSQLServer
> FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0.
> WARNING:
> event 19011 source MSSQLServer
> (SpnRegister) : Error 1355.
> any suggestions?
if you can manually install MSDE your self, try adding the
/L*v "c:\msdelog.txt"
parameter to your call to setup.exe bootstrap installer in order to enable
verbose logging of the installation process... you can then ispect the
resulting log text file for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the found problem will be reported..
please verify File & Printer Sharing is enabled and the Server service up
and running...
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
|||thats my error:
Executing "C:\Programme\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1
-M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General_CI_AS""
MSI (c) (A8:A4) [11:05:57:062]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (CC!CC) [11:06:00:562]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
"Andrea Montanari" wrote:

> hi,
> Zabby wrote:
> if you can manually install MSDE your self, try adding the
> /L*v "c:\msdelog.txt"
> parameter to your call to setup.exe bootstrap installer in order to enable
> verbose logging of the installation process... you can then ispect the
> resulting log text file for
> RETURN VALUE 3
> entries... about 10 lines before each entry some (sometime cryptic)
> description of the found problem will be reported..
> please verify File & Printer Sharing is enabled and the Server service up
> and running...
> --
> 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,
Zabby wrote:
> thats my error:
> Executing "C:\Programme\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
> "Latin1_General_CI_AS""
> MSI (c) (A8:A4) [11:05:57:062]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> MSI (s) (CC!CC) [11:06:00:562]: Product: Microsoft SQL Server Desktop
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this problem is usually associated to previously uninstalled instance of
MSDE, as described in
http://support.microsoft.com/default...99&Product=sql
it has been sometime reported to MDAC corruption on WinXP sp2, so I do not
know if it applys to Win2003 too, but Win2003 sp1 include the very same MDAC
stack (2.8 sp2) as WinXP sp2, you can fix as described in
http://www.macropool.com/en/download/mdac_xp_sp2.html
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
|||thank you!
grat job!
"Andrea Montanari" wrote:

> hi,
> Zabby wrote:
> this problem is usually associated to previously uninstalled instance of
> MSDE, as described in
> http://support.microsoft.com/default...99&Product=sql
> it has been sometime reported to MDAC corruption on WinXP sp2, so I do not
> know if it applys to Win2003 too, but Win2003 sp1 include the very same MDAC
> stack (2.8 sp2) as WinXP sp2, you can fix as described in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> 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
>
>