Error installing MSDE (Microsoft SQL Server Desktop Engine)

As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this
error message :
"A strong SA password is required for security reasons.
Please use SAPWD switch to suply the same. Setup will now exit"
How do i solve this?Use the SAPWD switch when you invoke setup.exe, and give it a strong
password?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"João Portela" <joao.portela@.netvisao.pt> wrote in message
news:newscache$6xa43i$l7e$1@.newsfront4.netvisao.pt...
> As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this
> error message :
> "A strong SA password is required for security reasons.
> Please use SAPWD switch to suply the same. Setup will now exit"
> How do i solve this?
>|||The problem is that i don't know what SAPWD switch is, as nor how to use
it.
could you please explain me?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||All is explained in the readme file?
Open a command prompt, navigate to the folder with setup.exe from MSDE, and
type
setup.exe INSTANCENAME=WhateverYouWantTheInstanceToBeNamed SECURITYMODE=SQL
SAPWD=WhateverYouWantThePasswordToBe DISABLENETWORKPROTOCOLS=0
--
http://www.aspfaq.com/
(Reverse address to reply.)
"João Portela" <joao.portela@.netvisao.pt> wrote in message
news:OMyzMWGjEHA.712@.TK2MSFTNGP09.phx.gbl...
> The problem is that i don't know what SAPWD switch is, as nor how to use
> it.
> could you please explain me?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Error installing MSDE (Microsoft SQL Server Desktop Engine)

As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this
error message :
"A strong SA password is required for security reasons.
Please use SAPWD switch to suply the same. Setup will now exit"
How do i solve this?
Use the SAPWD switch when you invoke setup.exe, and give it a strong
password?
http://www.aspfaq.com/
(Reverse address to reply.)
"Joo Portela" <joao.portela@.netvisao.pt> wrote in message
news:newscache$6xa43i$l7e$1@.newsfront4.netvisao.pt ...
> As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this
> error message :
> "A strong SA password is required for security reasons.
> Please use SAPWD switch to suply the same. Setup will now exit"
> How do i solve this?
>
|||The problem is that i don't know what SAPWD switch is, as nor how to use
it.
could you please explain me?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||All is explained in the readme file?
Open a command prompt, navigate to the folder with setup.exe from MSDE, and
type
setup.exe INSTANCENAME=WhateverYouWantTheInstanceToBeNamed SECURITYMODE=SQL
SAPWD=WhateverYouWantThePasswordToBe DISABLENETWORKPROTOCOLS=0
http://www.aspfaq.com/
(Reverse address to reply.)
"Joo Portela" <joao.portela@.netvisao.pt> wrote in message
news:OMyzMWGjEHA.712@.TK2MSFTNGP09.phx.gbl...
> The problem is that i don't know what SAPWD switch is, as nor how to use
> it.
> could you please explain me?
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||I did that, but i still get the same error message
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Are you trying to install a NEW instance or are you trying to install the
name of instance that already exists?
Have you tried NOT using SQL authentication / SA password at all (you can
always change that after installation), e.g.
setup.exe INSTANCENAME=MakeSureThisIsANewInstanceName
DISABLENETWORKPROTOCOLS=0
If you are trying to upgrade an existing instance e.g. with MSDE 2000A you
will need the upgradesp switch (again, see the readme file).
http://www.aspfaq.com/
(Reverse address to reply.)
"Joo Portela" <joao.portela@.netvisao.pt> wrote in message
news:u#k1qAIjEHA.3612@.TK2MSFTNGP12.phx.gbl...
>
> I did that, but i still get the same error message
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Error installing MSDE (Microsoft SQL Server Desktop Engine)

As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this
error message :
"A strong SA password is required for security reasons.
Please use SAPWD switch to suply the same. Setup will now exit"
How do i solve this?Use the SAPWD switch when you invoke setup.exe, and give it a strong
password?
http://www.aspfaq.com/
(Reverse address to reply.)
"Joo Portela" <joao.portela@.netvisao.pt> wrote in message
news:newscache$6xa43i$l7e$1@.newsfront4.netvisao.pt...
> As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this
> error message :
> "A strong SA password is required for security reasons.
> Please use SAPWD switch to suply the same. Setup will now exit"
> How do i solve this?
>|||The problem is that i don't know what SAPWD switch is, as nor how to use
it.
could you please explain me?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||All is explained in the readme file?
Open a command prompt, navigate to the folder with setup.exe from MSDE, and
type
setup.exe INSTANCENAME=WhateverYouWantTheInstanceT
oBeNamed SECURITYMODE=SQL
SAPWD=WhateverYouWantThePasswordToBe DISABLENETWORKPROTOCOLS=0
http://www.aspfaq.com/
(Reverse address to reply.)
"Joo Portela" <joao.portela@.netvisao.pt> wrote in message
news:OMyzMWGjEHA.712@.TK2MSFTNGP09.phx.gbl...
> The problem is that i don't know what SAPWD switch is, as nor how to use
> it.
> could you please explain me?
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||I did that, but i still get the same error message
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Are you trying to install a NEW instance or are you trying to install the
name of instance that already exists?
Have you tried NOT using SQL authentication / SA password at all (you can
always change that after installation), e.g.
setup.exe INSTANCENAME=MakeSureThisIsANewInstanceN
ame
DISABLENETWORKPROTOCOLS=0
If you are trying to upgrade an existing instance e.g. with MSDE 2000A you
will need the upgradesp switch (again, see the readme file).
http://www.aspfaq.com/
(Reverse address to reply.)
"Joo Portela" <joao.portela@.netvisao.pt> wrote in message
news:u#k1qAIjEHA.3612@.TK2MSFTNGP12.phx.gbl...
>
> I did that, but i still get the same error message
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

error in updating field thru stor_proc

I'm trying to update 'password' field in a table thru a stored procedure which is called from my program.

I'm passing the values for password and the key fields.

While debugging I can see the values in each parameter, but I get an error that the 'value for password was not passed'.

Here's the program snippet for calling the stored proc.

All three parameters are 'varchar' type

dbConn.Open();

dbConn.CreateParameters(3);

dbConn.AddParameters(0, Pwd, newPwd);

dbConn.AddParameters(1, Login, pwd_Login);

dbConn.AddParameters(2, IdNum, pwd_IdNum);

result = dbMgr.ExecuteNonQuery(CommandType.StoredProcedure, SP_UPDPWD);

--

EXEC @.return_value = [dbo].[usp_UsrMstUpdPwdParaPwdEmailCaseNum]

@.Pwd = N'3Sg7vqowIBRdfgdfgrgdjykFTjTFt5hfHfhFtFghzIG1haWRliBuYW1lPw==',

@.Login = N'xyz@.abc.com',

@.IdNumber = N'00009'

--

What am I missing?

Is Pwd a variable or constant set to "@.Pwd", login to "@.Login", IdNum to "@.IdNum", and "SP_UPDPWD" to the appropriate string for your stored procedure?

Also, is this using an IDBManager pattern?

Thanks,

John

|||

Never mind. found the problem

The parameter for Password was not spelt right!