Install MSDE 4

[jadec]

Hi Guys,

I bought the book: ASP.NET VISUAL C# .NET Step by Step. The book require me to intall MSDE (sql server desktop edition) after intalled Visual Studio .Net. When I run setup.exe for MSDE, I got a message box saying:

A Strong SA password is required for security reason. Please use SAPWD switch to supply the same. .

I don't understand what is that mean. I read the readme, It doesn't Help me much. Could anyone help me with it?

Thank you so much!

 

[bboffin]

Run the MSDE Setup.exe program from a command line window.
For example:

Setup /SAPWD:ThisIsAFairlyStrongPassword897ghwj79ekh

The SA user is the system administrator and can do absolutely anything to your database so it's a good idea to prevent other people from being able to guess SA's password especially if the database is in any way exposed to the outside world as it might be if it supports a web site.

If however this is a database on a private system just used by you to teach yourself about MSDE/SQL then it probably doesn't matter if SA has a password.



Bob Boffin

 

[chiph]

You should definitely assign a password to sa if the computer is visible from the internet -- the SQL Slammer worm is able to infect a database server in only a few network packets (it takes advantage of missing sa passwords).

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[jadec]

Thanks you so much! guys. I'll try that.

 

[tgreer]

Adding stars...

Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

 

[jadec]

hi Guys,

I can't figure out the syntx. I input syntx to command prompt window:

first, I changed dir. to C:\msde folder\msde, then type in

Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<mypassword>

I got syntx incorrect error. I have no idea. I don't know any dos command. Can anyone help me please? Thanks

 

[bboffin]

Are the SQLRunxxx.msi files in the same folder as Setup.exe?

If not you need to add /i<foldername> somewhere on the command line.

If you type
setup /?
on the command line a message box should pop up showing the syntax of the command.

Check that you haven't put spaces around the = signs. If you've put a space in your password then remove it.

You can also put the values after the = signs in double quotes to see if that helps.

My version of Setup suggests that the /qb+ (this switch contols how much information is displayed during installation) should be preceded by UI: and a space.


Bob Boffin

 

[jadec]

Hi, I found the syntax from

http://www.asp.net:

c:\sql2ksp3\msde>setup SAPWD=hello SecurityMode=SQL

works just fine.

Thanks!