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/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 problem: Command line syntex error....

Today, I met a trouble when i install sql server.
Operation system: 2000 server
Hardware:My pc
sql server : 2000 enterprise edition
authorization mode: per processor
I am very worried now.Help me,thks a lot!What was the problem?
"Ocean" <Ocean@.discussions.microsoft.com> wrote in message
news:A49D0503-B404-4C0C-A1B9-57B667D49623@.microsoft.com...
> Today, I met a trouble when i install sql server.
> Operation system: 2000 server
> Hardware:My pc
> sql server : 2000 enterprise edition
> authorization mode: per processor
> I am very worried now.Help me,thks a lot!

installation problem.. instance name?!

i tried installing MSDE with the command line: setup SAPWD=<password> SECURITYMODE=SQL and i get the following error: The instance name specified is invalid. what is it saying? can someone pls help me out? thanxI don't know but it might misinterpretate the securitymode=sql flag for an instancename? Or do already you have another instance of MSDE installed at your computer? In that case the next installation has to be named. Each installation is a new instance)
I installed MSDE with just the SAPWD flag, try that