MSDE sp3a install w/ no password

I was just wondering how I could install an instance of MSDE sp3a (on an XP
machine) without a SAPWD. Thanks.
Anthony
hi Anthony,
Anthony wrote:
> I was just wondering how I could install an instance of MSDE sp3a (on
> an XP machine) without a SAPWD. Thanks.
just provide the
BLANKSAPWD=1
parameter to the setup.exe boostrap installer...
http://msdn.microsoft.com/library/de...stsql_84xl.asp
BTW, just consider this is not a best practice... :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a million. And I agree, probably not a best practice.
Anthony
"Andrea Montanari" wrote:

> hi Anthony,
> Anthony wrote:
> just provide the
> BLANKSAPWD=1
> parameter to the setup.exe boostrap installer...
> http://msdn.microsoft.com/library/de...stsql_84xl.asp
> BTW, just consider this is not a best practice... :D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>