MSDE

[mmatsumura]

Hi all,

I've been trying to deploy MSDE via a program written in VB.Net but haven't had success. When I try to install it I am presented with the following message:

"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."

I would greatly appriciate a prompt reply!


Thank You

 

[pgtek]

hi
try
user admin
pwd sullivans

or

sa
pwd sa

 

[pgtek]

or
user sa
pwd sullivans

 

[mmatsumura]

pgtek,

Thanks for the prompt message reply.

So, where and how should I make the changes. Currently the string I have reads:

"Dim cn As New SqlConnection("server=MMATSUMURA1\VSDOTNET;Database=Northwind;Integrated Security=SSPI&quot

Please provide a bit more assistance...


Many, Many Thanks

 

[SQLBill]

Have you checked the MSDE readme file like the error said?

I believe it should be like this:

"Dim cn As New SqlConnection("server=MMATSUMURA1\VSDOTNET;SAPWD=thepassword;Database=Northwind;Integrated Security=SSPI&quot

-SQLBill

 

[mmatsumura]

SQLBill,

Thanks for the note... I will make the change and see what happens. Should it pass or not, I'll post another note!


Thanks

 

[zhavic]

'mmatsumura',

May be I am wrong with this, but this error is often about installing SP3 for MSSQL 2000 or MSDE 2000

You sad:
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

It sounds for me like you has problem with instaling MSDE, not with connecting to it.

And also it sounds to me like this:
MSDE was installed before you install your application, but your installer want to install SP3 for MSSQL2000

Is it true ?
If yes, look there:

http://support.microsoft.com/?kbid=810826

In this link I read this:

Regardless of whether an instance of Desktop Engine is using Microsoft Windows or Mixed Mode authentication, the Setup cannot continue if a blank password is detected for the sa logon. A warning message appears if a blank password is detected. If you have a blank password for the sa logon, before you continue you must change the password by using the sp_password stored procedure.

Just change 'sa' password before installing your application, and after install you can change 'sa' password back to blank.

Switch SAPWD is used in 'setup.ini' file of installer for SP3 MSSQL 2000, and it may look like this:

[Options]
SQPWD=some_password

-------------------
Note, that 'some_password' couldn't be blank
After install of SP3, 'sa' password will be 'some_password'


Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[mmatsumura]

zhavic,

Glad you sent the message. I too was thinking about what may be going wrong, but I don't know how to repair it. Given that, what do I need to do to figure out what's broken? PLEASE... I am really close to pitching this laptop down the stairs...

Hope You Are Willing!

 

[mmatsumura]

To All,

I would send a copy of what I'm working on should it help!


Thanks...

 

[JayKusch]

This is as expected, starting with SP3 a strong sa password is required for
security reasons. You can use the switch SAPWD to go past this error.

If you are not using the latest MSDE SP3a i recommend you use that version
found in

http://www.microsoft.com/sql/downloads/2000/sp3.asp,

download the
files necessary to install an MSDE SP3a instance. Please refer to section
3.7 of the sp3Readme.htm for installation instructions, this is important as
we
introduced new switches starting in SP3. There is an extensive discussion
of the need for a password.

For example you want to install an instance named 'foo' using SQL
authentication and an sa password=footest then a sample command line will
be:
>setup.exe instancename=foo securitymode=SQL sapwd=footest /l*v c:\test.log

Note that i created a verbose log test.log using the switch /l*v so that i
can confirm sucessful installation by looking at the log after the
installation.


Thanks

J. Kusch

 

[zhavic]

To 'mmatsumura'

Don't do that with that laptop, you can damage the stairs!


Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[mmatsumura]

JayKusch,

Thanks! I am using SP3a and have read paragraph 3.7 several times and tried to follow instruction. Anyway...

I plan on installing another instance like you mentioned, make changes to the VB.Net stuff and try it again. When I initially setup MSDE, I followed the instruction shown on a Microsoft document titled "MSDE 2000 for Developers Using Visual Studio.NET." The command it said to use reads:

&quot;Run the following command to set up MSDE for VS.Net. Replace <YOUR SA PASSWORD> with the systems administrator's password that you would like to use: Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD>&quot;

Is that far off track?

Anyway, I am going to follow you suggestion and post another note!

Many Thanks!

 

[mmatsumura]

JayKusch,

I am running into the same problem -

&quot;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.&quot;

What on earth am I doing wrong??? If you are in the state of Virginia, let me know.


Thanks, again!

 

[JayKusch]

Nope ... in Texas but still digging for more info for you.

Thanks

J. Kusch

 

[mmatsumura]

JayKusch,

Thanks again. I decided to add the code in this note for you to have a look at. There are two sections - Form and VBS:

Here's the form:

*****
Imports System.Data.SqlClient

Public Class Form1
Inherits System.Windows.Forms.Form

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


Dim cn As New SqlConnection(&quot;server=MMATSUMURA1\DEPLOY;uid=sa;pwd=LMR;Database=Northwind&quot
Dim sql As String = _
&quot;SELECT ProductName AS Product, CategoryID AS Category, UnitPrice AS Price, UnitsInStock AS [# In Stock];&quot; & _
&quot;FROM Products &quot;
Dim cmd As New SqlCommand(sql, cn)
Dim sda As New SqlDataAdapter(cmd)
Dim ds As DataSet
ds = New DataSet

sda.Fill(ds)
DataGrid1.DataSource = ds.Tables(0)
End Sub
End Class
*****

Here's the VBS

*****

Option Explicit

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

SLUtilShell &quot;net start MSSQL$DEPLOY&quot;
SLUtilShell &quot;osql -E -S MMATSUMURA1\DEPLOY -i &quot;&quot;C:\Backup\SQLData\instnwnd.sql&quot;&quot; &quot;
*****

Hope you have a look and drop me another line.


Many Thanks!!!