MSDE 2000 install on SQL 2000

Hello,
I have installed MSDE 2000 on Win Server 2003 with instance name brprof,
there SQL Server 2000 already installed as a local instance named SBGBHO.
Now, I registered my new MSDE 2000 on enterprise manager, registration done
successfully, but it display following error
LOGIN FAILED FOR USER SA : REASON NOT ASSOCIATED WITH TRUSTED SQL SERVER
CONNECTION
HARSHA.
hi Harsha,
Harsha Shah wrote:
> Hello,
> I have installed MSDE 2000 on Win Server 2003 with instance name
> brprof, there SQL Server 2000 already installed as a local instance
> named SBGBHO. Now, I registered my new MSDE 2000 on enterprise
> manager, registration done successfully, but it display following
> error
> LOGIN FAILED FOR USER SA : REASON NOT ASSOCIATED WITH TRUSTED SQL
> SERVER CONNECTION
MSDE installs by default only allowing trusted WinNT connections... you can
change this behavior, allowing standard SQL Server connection at install
time providing the
SECURITYMODE=SQL
parameter to the setup.exe boostrap installer, or later accessing the
windows registry, as described in
http://support.microsoft.com/default...b;en-us;285097
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply