Installing MSDE200A on Windows 2003

I have done a freresh install of Windows 2003, patches and now trying to
install MSDE RelA.
I use the command line "SETUP SAPWD="Password"" and it appears to install
successfully. I restart. When I try to install an application that uses
MSDE it claims there is no database.
I do a "netstat -an" and do not see anything listening on port 1433. I've
uninstalled and reinstalled with no change. What am I doing wrong?
Hi
In Control Panel > Services, Is the MSDE service there and running?
Regards
Mike
"Brian" wrote:

> I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||I do "Net Start" and MSSQLSERVER is listed. It is also displayed in the gui
as automatic and running.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> In Control Panel > Services, Is the MSDE service there and running?
> Regards
> Mike
> "Brian" wrote:
|||MSDE installs by default with Windows Security only. Setting an sa password
doesn't influence that. You also have to add SECURITYMODE=SQL to your setup
script if you want to use SQL Security.
You can change an MSDE installation to use SQL Security after it has been
installed by changing the registry key
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode to 2.
See:
http://support.microsoft.com/default...b;en-us;285097
for extensive info.
Jacco Schalkwijk
SQL Server MVP
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||Brian,
By default MSDE RelA installs with TCP protocol turned off for security
reasons. Use svrnetcn.exe in the Binn folder to enable protocols and
configure ports.
Ron Allen
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?

Installation MSDE RelA - already turning insane......

Hello... i am 5th day trying to install MSDERelA to new installed 2K3
Server, no success.... (Server is running as additional domain controller in
quite wide private WAN. Key parts of verbose log:
..
Loading extended custom action library
c:\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 (XBERLA04,LocalSystem,87).
Action ended 15:59:45: InstallFinalize. Return value 3.
MSI (s) (38:A0) [15:59:45:765]: User policy value 'DisableRollback' is 0
..
..
MSI (c) (88:8C) [15:59:50:140]: Note: 1: 1708
MSI (c) (88:8C) [15:59:50:140]: Product: Microsoft SQL Server Desktop Engine
-- Installation operation failed.
MSI (c) (88:8C) [15:59:50:140]: Grabbed execution mutex.
MSI (c) (88:8C) [15:59:50:140]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (88:8C) [15:59:50:140]: MainEngineThread is returning 1603
=== Verbose logging stopped: 9.1.2007 15:59:50 ===
I tried many hints from communities, aplied or tried kb889541, kb927978,
kb829386, kb325860, kb816499, manualy purged registry from previous
installation traces....
No change, same results...full verbose log http://martinovo.info/msdesto.log
Please, Andrea Montanari, i REALLY need your expert advice, or i turn crazy
soon!!
tyvm

> please verify File and Printer sharing is enabled and the "Server" service
> is up and running..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
Yesssss Server Service is running, File server on, Print Server on, its
included in kb829386 and kb325860, which i mentioned... Well, despite it i
just have tried one more time, checked all settings, services, again manually
purged registry from MSSQL traces - same result..
..
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (XBERLA04,LocalSystem,87).
Action ended 15:59:45: InstallFinalize. Return value 3.
..
I searched thru many answers a hints to this problem in comunities (the
major part is by you) and still no chance to install - pure despair...
Any possibility to install components step by step , not in msi package, to
solve where apears conflict first?
viktor
|||Bbaaaaaaaahhhh, reason is already know, solution not clear.
During installation of SQLAagentSecurity MSinstaller needs online
connection to Primary Domain Controller on port 53!!
Localhost is additional domain controller, replicated every
24hours and only replication ports are open.
Pls Andrea, u know any solution how to install MSDE without
online connection to PDS?....
tyvm, Viktor
[vbcol=seagreen]

> Yesssss Server Service is running, File server on, Print Server on, its
> included in kb829386 and kb325860, which i mentioned... Well, despite it i
> just have tried one more time, checked all settings, services, again manually
> purged registry from MSSQL traces - same result..
> .
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (XBERLA04,LocalSystem,87).
> Action ended 15:59:45: InstallFinalize. Return value 3.
> .
> I searched thru many answers a hints to this problem in comunities (the
> major part is by you) and still no chance to install - pure despair...
> Any possibility to install components step by step , not in msi package, to
> solve where apears conflict first?
> viktor