MSDE Installation

[mmatsumura]

I've been following a Webcast to learn how to include MSDE as part of a VB.Net Windows application. The problem I am having is that when I run an 'Install' of the deployment project, a message box appears with the following:

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

So, I have been looking over the VBS file that the presentor instructed me to write, tried making changes, but have not been able to get the installation working. Below is what my VBS file states:

**************
Option Explicit

Sub SLUtilShellExec( strCmdLine )
Dim ObjShell
Set ObjShell=CreateObject("WScript.Shell&quot
ObjShell.Run strCmdLine, 0, True
Set ObjShell = Nothing
End Sub

SLUtilShell "net start MSSQL$VSDOTNET"
SLUtilShell "osql -S TESTER\VSDOTNET -E -i ""c:\MSDETest\SQLData\NorthwindInstall.sql"" "

End Sub
****************

!Note: the second SLUtilShell line is one length.


Any assistance to help me through the problem would be greatly appriciated!


Thank You

 

[chiph]

What they're telling you is to use a strong password for the sa account. The SQL Slammer virus took advantage of many servers that were running with *no* password for sa (a HUGE security risk!).

So the usual rules for picking passwords apply: Do not use any part of a word which might be in a dictionary. Do not use 1eetspe5k (substituting numbers for similarly shaped letters. DO use a mixture of upper-case, lower-case, numeric, and punctuation.

If you have a hard time remembering your new password, write it down on a slip of paper and keep it in your wallet. Yes, I know people say not to do this, but when's the last time you let someone other than your spouse look in your wallet?

Chip H.