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?

Installing MSDE

Someone please tell me how to install MSDE. I am somewhat unfamiliar with the command prompt - I'm using XP Professional. I need to set "SAPWD."

I have tried "setup SAPWD="" security=SQL" but I don't believe I'm doing it right.Did you modify the Setup.ini file that is in the same directory as the MSDE Setup.exe so that it looks something like this.

[Options]
INSTANCENAME=SomeInstanceName
SECURITYMODE=SQL
SAPWD=whatever

After you change these settings you should re-install MSDE.

This link may help|||I got it set up, thanks.sql

Installation/Connection problems with MS Desktop Engine

Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
Steve,
You may have installed with SA and strong password (Sql authentication) but I believe the install defaults to Windows authentication.
Follow the below to make sure ... (excerpt from KB-322336)
******
If you are not sure how to verify the authentication mode of your MSDE installation, you can check the corresponding registry entry. By default, the value of the Windows LoginMode registry subkey is set to 1 for Windows Authentication. When Mixed Mode authentication is enabled, this value is a 2.
a.. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode
NOTE: Before you switch authentication modes, you must set a sa password to avoid exposing a potential security hole
******
Hope this helps,
Tunji
"Steve Wash" <swash1@.home.com> wrote in message news:79GdnaCfS4T2AtbcRVn-tQ@.comcast.com...
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?

Installation Issue

I try to install MSDE using the sapwd switch. During the 'Please wait while
Windows configures Microsoft SQL Server Desktop Engine' process an error pops
up stating:
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I searched high and low for installation logs and the event viewer on my
server but I cannot find anything relavent to this error.
hi,
Mikey Rogers wrote:
> I try to install MSDE using the sapwd switch. During the 'Please
> wait while Windows configures Microsoft SQL Server Desktop Engine'
> process an error pops up stating:
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> I searched high and low for installation logs and the event viewer on
> my server but I cannot find anything relavent to this error.
as you can see from
http://support.microsoft.com/default...9&Product=sql,
the most relevant cause of this exception is due to uncomplete
installation(s) of other MSDE instances...
if you are not involved in this problem, it recently appears due to MDAC
stack corruptions...
if you have WinXP sp2 installed you can not fix it by applying the higher
MDAC stack (http://msdn.microsoft.com/data/mdac/...s/default.aspx)
becouse no refresh is available for that MDAC sp level, but you can fix MDAC
as reported in http://www.macropool.com/en/download...xp_sp2.html...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> I try to install MSDE using the sapwd switch. During the 'Please wait
> while Windows configures Microsoft SQL Server Desktop Engine' process
> an error pops up stating:
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> I searched high and low for installation logs and the event viewer on
> my server but I cannot find anything relavent to this error.
>
add certificate

Installation hangs for MSDE2000A on XP SP1

I'm trying to install MSDE2000A on XP SP1. I issue the command:
setup /SAPWD="mypassword" /L*v C:\MSDERelA\setup.log
The installation progresses for a couple of minutes and then hangs. The
last entry in the log is:
MSI (s) (DC:34) [06:37:29:140]: Executing op:
ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (DC:34) [06:37:29:140]: Executing op:
CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
MSI (s) (DC:2C) [06:37:29:156]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI66A.tmp, Entrypoint: InstallSqlRedis
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
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"
If I cancel the setup, it rolls back from this point.
I noted the information at:
http://support.microsoft.com/default...b;EN-US;841061
But this really deals with running the setup from an application, not from
the Microsoft supplied installer at a command line. Anyway, I tried this as
well and wrote a small application to run the installation as shown in the
KB. No change in behavior, the end-result is the same and the last log is
the same one.
BTW, I meant to say this is XP SP2, not SP1...
Sorry
|||hi,
jwh20 wrote:
> I'm trying to install MSDE2000A on XP SP1. I issue the command:
> setup /SAPWD="mypassword" /L*v C:\MSDERelA\setup.log
> The installation progresses for a couple of minutes and then hangs.
> The last entry in the log is:
> MSI (s) (DC:34) [06:37:29:140]: Executing op:
> ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
> MSI (s) (DC:34) [06:37:29:140]: Executing op:
> CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
> MSI (s) (DC:2C) [06:37:29:156]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI66A.tmp, Entrypoint: InstallSqlRedis
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> 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"
>
> If I cancel the setup, it rolls back from this point.
>
please verify, using thetask manager, the setupre.exe is actually hanging...
if this is the case, kill this process... the installation should go on and
proceed with success...
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