Wednesday, March 7, 2012

Microsoft Web Data Administrator

I have download this Front End because MSDE doesnt ship with an Visual
Interface,
i have installed MSDE2000 i believe is MSDE200a
when i installed i pass the SAPWD parameters to the setup and all was
fine...
but i cant loggin with the user SA with no password.
Even if i made an UDL File, i cant connect with that user, i have to check
login USING WINDOWS NT Integrated Security...
:S
how can i connect with the SA user with no password
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
hi Juan,
"Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> I have download this Front End because MSDE doesnt ship with an Visual
> Interface,
> i have installed MSDE2000 i believe is MSDE200a
> when i installed i pass the SAPWD parameters to the setup and all was
> fine...
> but i cant loggin with the user SA with no password.
> Even if i made an UDL File, i cant connect with that user, i have to check
> login USING WINDOWS NT Integrated Security...
> :S
> how can i connect with the SA user with no password
if you can not connect using SQL Server authentication at all, this usually
means that only Windows Authentication is enabled for that instance, and you
have to manually enable it, modifying a Windows registry key, as explained
in http://support.microsoft.com/default...b;en-us;285097
if you can connect with SQL Server authentication, but want to clear the sa
password to a blank password, you can execute
EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
but I strongly warn you not to do it... a strong password always is your
best friend
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jaun
Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank passwords?
Rich
"Andrea Montanari" wrote:

> hi Juan,
> "Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
> news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> if you can not connect using SQL Server authentication at all, this usually
> means that only Windows Authentication is enabled for that instance, and you
> have to manually enable it, modifying a Windows registry key, as explained
> in http://support.microsoft.com/default...b;en-us;285097
> if you can connect with SQL Server authentication, but want to clear the sa
> password to a blank password, you can execute
> EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
> but I strongly warn you not to do it... a strong password always is your
> best friend
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Thks.. for the help for both of you... but finally i have to Uninstall and
Install again passing this parameters : setup SAPWD = "****"
SECURITYMODE=SQL
and know its working... :D
thks.. again... see you..
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> escribi en el mensaje
news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?[vbcol=seagreen]
> Rich
>
> "Andrea Montanari" wrote:
messaggio[vbcol=seagreen]
check[vbcol=seagreen]
usually[vbcol=seagreen]
you[vbcol=seagreen]
explained[vbcol=seagreen]
sa[vbcol=seagreen]
|||hi Richard,
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> ha scritto nel
messaggio news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?
yes it does, but, at install time, you have to force the BLANKSAPWD=1
parameter in order to accept it... an again, I strongly recommend not to
allow blank pwd policies
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment