Showing posts with label strong. Show all posts
Showing posts with label strong. Show all posts

Friday, March 9, 2012

MSDE installation problems

hi

i have downloaded the free MSDERelA from the official website but when i wanna run the installation, it says

"A strong SA password is needed for security reasons.Please use the SAPWD switch to supply the same"

i read the readme doc but i still cant understand how to install n where to find the SAPWD switch ??

Please guide me
Thank you very muchInstructions here

Wednesday, March 7, 2012

MSDE Install Question

I installed MSDE using Windows authentication and gave the SA logon ID a
"strong" password. However, when I attempt to logon to the MSDE database
(via OSQL) I get a message stating something to the effect of "the logon ID
is not associated with a trusted account". I realize what this means (i.e.
the logon ID "sa" is not a Windows account). However, what I'm wondering is
how do I logon to a brand new (MSDE) server once it's been installed to use
Windows authentication if I haven't setup any accounts/roles yet?
-- Thanks, Jeff
hi Jeff,
Jeff B. wrote:
> I installed MSDE using Windows authentication and gave the SA logon
> ID a "strong" password. However, when I attempt to logon to the MSDE
> database (via OSQL) I get a message stating something to the effect
> of "the logon ID is not associated with a trusted account". I
> realize what this means (i.e. the logon ID "sa" is not a Windows
> account). However, what I'm wondering is how do I logon to a brand
> new (MSDE) server once it's been installed to use Windows
> authentication if I haven't setup any accounts/roles yet?
> -- Thanks, Jeff
by default, the Windows administrators group will be mapped to the SQL
Server BUILTIN\Administrators WinNT group, so you can log in as a Windows
admin..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Saturday, February 25, 2012

MSDE Install

When I tried to install MSDE I got message :
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."

What should I do ? I'm using XP pro and VS 2003You have to specify a password

Type Setup SAPWD=(Some password) SecurityMode=SQL

See here

http://www.asp.net/msde/Default.aspx?tabindex=0&tabid=1

Instruction 2|||I'be tryed it and it didn't work. Can we Install MSDE on XP Pro ?
Jeff|||Yes you can install MSDE on XP Pro. You can also use Access 2002 to connect to SQL Server or MSDE by creating a project file.

Cheers|||Sounds interesting...how can you connect to MSDE with Access ?
Thanks,
Jeff