Friday, March 30, 2012
MSDE SQL Service Manager is not installed
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
Wednesday, March 28, 2012
MSDE setup errors - Act! 2005
This latest ver of Act! now requires MSDE 2000A. When the
program itself tries to install (along with MSDE in the
background), it hangs at the end, with Error 1603. Their
tech support suggested I try installing MSDE myself. That
install setup hung at the end, causing the error log
language below. Any suggestions on how to get MSDE to
follow thru on the setup?
I'm running WinXP Home. Full admin privs.
TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -
Q "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Action ended 18:12:05: InstallFinalize. Return value 3.
Hi Bill,
I'd suggest trying the verbose setup option and reading/posting the log file
produced.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:048901c49150$6e423360$a401280a@.phx.gbl...
> My problem originates with trying to install Act! 2005.
> This latest ver of Act! now requires MSDE 2000A. When the
> program itself tries to install (along with MSDE in the
> background), it hangs at the end, with Error 1603. Their
> tech support suggested I try installing MSDE myself. That
> install setup hung at the end, causing the error log
> language below. Any suggestions on how to get MSDE to
> follow thru on the setup?
> I'm running WinXP Home. Full admin privs.
> TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
> E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
> \sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -
> Q "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 18:12:05: InstallFinalize. Return value 3.
|||I had problems installing MSDE too. You might want to make sure you
have file and printer sharing for MS networks turned on. It worked
for me after turning it on. I'm not sure why.
-Bgarr
"Bill" <anonymous@.discussions.microsoft.com> wrote in message news:<048901c49150$6e423360$a401280a@.phx.gbl>...
> My problem originates with trying to install Act! 2005.
> This latest ver of Act! now requires MSDE 2000A. When the
> program itself tries to install (along with MSDE in the
> background), it hangs at the end, with Error 1603. Their
> tech support suggested I try installing MSDE myself. That
> install setup hung at the end, causing the error log
> language below. Any suggestions on how to get MSDE to
> follow thru on the setup?
> I'm running WinXP Home. Full admin privs.
> TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
> E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
> \sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -
> Q "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 18:12:05: InstallFinalize. Return value 3.
|||I, too, tried to install Act! 2005 tonight and was stopped by:
"Error: -1603 Fatal error during installation"
How do I make sure file and printer sharing are turned on. I'm on a
stand alone computer runing XP Home. Plenty of disk space.
Hoby, in Idaho
bgarrydo@.netscape.net (Bruce Garr) wrote in message news:<3136070.0409060431.2679afed@.posting.google.c om>...[vbcol=seagreen]
> I had problems installing MSDE too. You might want to make sure you
> have file and printer sharing for MS networks turned on. It worked
> for me after turning it on. I'm not sure why.
> -Bgarr
> "Bill" <anonymous@.discussions.microsoft.com> wrote in message news:<048901c49150$6e423360$a401280a@.phx.gbl>...
|||Greg, My computer help left and I am here to figure this
out myself. I can do some things on computer, but Verbose
setup is greek to me. How do I try this setup? Thanks.
Bill at badkochie@.yahoo.com Sept.2 reply
>--Original Message--
>Hi Bill,
>I'd suggest trying the verbose setup option and
reading/posting the log file
>produced.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Bill" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:048901c49150$6e423360$a401280a@.phx.gbl...
the[vbcol=seagreen]
That[vbcol=seagreen]
D3605127224A}[vbcol=seagreen]
I "MSSQLSERVER" -[vbcol=seagreen]
server
>
>.
>
|||hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:89c101c49626$84ff6430$a301280a@.phx.gbl...
> Greg, My computer help left and I am here to figure this
> out myself. I can do some things on computer, but Verbose
> setup is greek to me. How do I try this setup? Thanks.
add the
/L*v "c:\msdelog.txt"
parameter to your command line parameters call for setup.exe
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 setup errors
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (B4!D0) [17:39:55:781]: 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.
I got some info on the possible causes of failure as below. Unfortunately
neither of them help.
If your machine name has lowercase characters then you may be hitting this
issue - http://support.microsoft.com/default...;en-us;Q285100
If you had a old instance of MSDE on the machine you may be hitting this
issue - http://support.microsoft.com/default...b;en-us;816499
"Shishir" wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set of erros
> in the setup log. These lines are from a non-verbose log I created while
> running the setup.
> Appreciate any help.
> Thanks
> Shishir
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> Setting SqlEdition property failed
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
> -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (B4!D0) [17:39:55:781]: 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.
>
|||hi Shishir,
Shishir wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set
> of erros in the setup log. These lines are from a non-verbose log I
> created while running the setup.
>..
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this exception is sometime related to MDAC stack corruption... as no MDAC XP
sp2 refresh is available to fix it, you can only go as indicated 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
|||I downloaded the repair tool and reregistered all the components. It still
fails the same way.
"Andrea Montanari" wrote:
> hi Shishir,
> Shishir wrote:
> this exception is sometime related to MDAC stack corruption... as no MDAC XP
> sp2 refresh is available to fix it, you can only go as indicated 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
>
>
sql
Monday, March 26, 2012
MSDE Reinstall
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?
Saturday, February 25, 2012
MSDE install fails on Server 2003 - HELP!
helped. Here is the MSDE setup log:
=== Verbose logging started: 06/25/2005 13:42:38 Build type: SHIP UNICODE
3.01.4000.1823 Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (2C:C8) [13:42:38:263]: Resetting cached policy values
MSI (c) (2C:C8) [13:42:38:263]: Machine policy value 'Debug' is 0
MSI (c) (2C:C8) [13:42:38:263]: ******* RunEngine:
******* Product:
D:\SystemStuff\BENT9.1\WINNT\INSTALL\MSDE\Setup\Sq lRun01.msi
******* Action:
******* CommandLine: **********
MSI (c) (2C:C8) [13:42:38:263]: Client-side and UI is none or basic: Running
entire install on the server.
MSI (c) (2C:C8) [13:42:38:263]: Grabbed execution mutex.
MSI (c) (2C:C8) [13:42:38:278]: Cloaking enabled.
MSI (c) (2C:C8) [13:42:38:278]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (2C:C8) [13:42:38:278]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (50:8C) [13:42:38:310]: Grabbed execution mutex.
MSI (s) (50:F0) [13:42:38:310]: Resetting cached policy values
MSI (s) (50:F0) [13:42:38:310]: Machine policy value 'Debug' is 0
MSI (s) (50:F0) [13:42:38:310]: ******* RunEngine:
******* Product:
D:\SystemStuff\BENT9.1\WINNT\INSTALL\MSDE\Setup\Sq lRun01.msi
******* Action:
******* CommandLine: **********
MSI (s) (50:F0) [13:42:38:310]: Machine policy value 'DisableUserInstalls'
is 0
MSI (s) (50:F0) [13:42:38:310]: MainEngineThread is returning 2
MSI (c) (2C:C8) [13:42:38:325]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (2C:C8) [13:42:38:325]: MainEngineThread is returning 2
=== Verbose logging stopped: 06/25/2005 13:42:38 ===
Any ideas on how to fix this? The system I'm installining on is Windows
Server 2003, Standard Edition, no SP.
hi Axel,
Axel Larson wrote:
> I keep getting setup errors in MSDE. None of the KB articles I've
> found have helped. Here is the MSDE setup log:
>...
actually a
RETURN VALUE 3
entry should indicate the problem, but I can not see it in your log... is
this all there is?
are you trying to install MSDE in Terminal Server application server mode?
http://support.microsoft.com/?id=830629
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