Re: Microsoft Web Data Administrator

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 09/13/04 

Date: Tue, 14 Sep 2004 00:10:23 +0200

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.aspx?scid=kb;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.shtm        http://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

Relevant Pages

  • Re: [STAThread]
    ... Java failed on the Windows client. ... SQL Server and many more expsose ... The unmanaged hosting interface ... 'Apartment' threaded COM objects have STA thread affinity, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: 2000k connect from outside domain
    ... You cannot fill in the user name and password because by doing so you are telling the login process to use SQL Server Authentication rather than windows authentication, and you would need a SQL Server authenticated login to do so. ...
    (microsoft.public.sqlserver.connect)
  • How to disable the Windows NT login authenticate at SQL-Server 2000 login Form ? @Thanks
    ... Use Ms SQL Server 2000, There are two way to login, The first is Windows NT ... Authentication, The second is SQL Server Authentication, If you choose ... I think the Database ...
    (microsoft.public.sqlserver.security)
  • Re: Changing passwords / Blocking SA login attempts
    ... Changing a Windows password is always completely invisible to SQL Server. ... The Windows login is completely separate from a SQL Server login, ... If you are using SQL Server Authentication, then one doesn't even have to ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server setup using multiple IP Addresses
    ... So basically i have two networks on the machine and SQL Server is only ... Windows XP and Windows Server 2003 use the "weak host" model. ... A connection on a network interface allows packets coming in on any other ...
    (microsoft.public.sqlserver.setup)
Quantcast