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 without sa password

Hello friends,
I am a beginer installing MSDE in a W98 system. The setup file request me a
secure password "sa".
I don't know what must I do now?
How can I define a secure password in W98?
Thanks a lot.
Lorka
On Tue, 15 Jun 2004 16:58:27 +0200, Lorka wrote:

>Hello friends,
>I am a beginer installing MSDE in a W98 system. The setup file request me a
>secure password "sa".
>I don't know what must I do now?
>How can I define a secure password in W98?
>Thanks a lot.
>Lorka
Hi Lorka,
Make up a password that's hard to guess (*). Write it down somewhere safe,
unless you have perfect recall. Never give it out to anyone.
(*) A hard to guess password uses both upper- and lowercase letters, at
least one digit and at least one special character. Of coourse, there is
no relation between the password and your username, your real name or the
names of anyone you love. Steer clear from English words as well (or if
you do include them, make sure you misspell them - as in pas5w0Rd)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||I understand the problem - Win98 has no passwords. You must install MSDE and the use the "osql.exe" utility via DOS window commands. Look this up in the MS SQL Server 2000 Books Online (Jan 2004 version is the most recent) Its free and must be installed o
n your system. Look for sp_password as the stored procedure to set the sa password under osql.
Good luck.
Mark Ferguson
"Lorka" wrote:

> Hello friends,
> I am a beginer installing MSDE in a W98 system. The setup file request me a
> secure password "sa".
> I don't know what must I do now?
> How can I define a secure password in W98?
> Thanks a lot.
> Lorka
>
>
|||PS: Although Win98 has no passwords, SQL Server uses SQL or Mixed Mode security under Win98. Look for their descriptions in the SQL Server Books Online.
For Win98, you will have to define a user name and password in SQL Server for each user, and assign them to a SQL Server Role. Thereafter, when they attempt to access SQL Server, they will have to log into it using these names and passwords. by default on
ly the "sa" username is defined and it has no default password (i think). So the reaosn for the strong password at install time is to avoid people from just nonchalantly logging in under the "sa" user name. If anyone else knows this to be wrong, please re
ply with corrections.
Seems to me that Win98 may pose another problem. I dont think it has named pipes - an alternative method to TCP/IP by which SQLServer and applications communicate - but I am not sure about this. Again, check the SQL Server Books Online.
Mark Ferguson

Installing MSDE SA password error.

I've been trying to install MSDE so i could run ASP.Net Forums. But whenever i run the setup.exe file, it gives me a pop up message with the following message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to the readme for more details. Set up will now Exit."

Could any body please tell me what to do??...

Yes. I'm stupid. And please excuse my ignoracne.Go to run and type the following replace path and password optionally you can specify authentication mode (default is windows) SECURITYMODE=SQL.

f:\sql2ksp3\MSDE\setup.exe sapwd="password"

Hope this helps

Regards
S(:

Installing MSDE

Hi All,

I need help installing MSDE. I am using Windows XP. When I download it and try to set the password with the Command Prompt, it doesn't work. When I setup XP my username became the Admin. When I open the Command Prompt, it defaults into my documents and setting - I can't get a C:\ prompt. My login is the Admin and the old Administrator account isn't listed anywhere on my computer. Am I screwed? Do I have to reinstall XP and have the seperate Admin account? Please help.

Thanks,
TonyOK - I got it installed. When I rebooted the Icon came up but it's not connecting. It says there is no Service available. How do I set up a Service? I am running IIS5 on Windows XP Pro.

Installation password - using NT auth, want to change original password

During the installation of MSSql personal you are asked
whether you would like to use NT auth or SA or mixed mode
for your DBA password.
I am currently using only NT authentication, however my
network password has changed since the installation of
mssql personal.
Is there anyway in MSSql to change the DBA login
password? I can not seem to find it anywhere.
Thanks in advance.
BenderYou don't have to change anything in SQL Server, if you are using Windows
authentication. If you manage to log into Windows, then that's fine, as long
as your Windows account is granted access to SQL Server.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"bender" <anonymous@.discussions.microsoft.com> wrote in message
news:034501c3dec9$4b6970e0$a101280a@.phx.gbl...
During the installation of MSSql personal you are asked
whether you would like to use NT auth or SA or mixed mode
for your DBA password.
I am currently using only NT authentication, however my
network password has changed since the installation of
mssql personal.
Is there anyway in MSSql to change the DBA login
password? I can not seem to find it anywhere.
Thanks in advance.
Bender