Re: MSDE 2000: Authentication failed despite BLANKSAPWD

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Stefan M. Huber (looseleaf_at_gmx.net)
Date: 10/28/04

  • Next message: Aaron: "MSDE Deployment Toolkit"
    Date: Thu, 28 Oct 2004 14:24:20 +0200
    
    

    On Thu, 28 Oct 2004 10:31:15 +0200, Stefan M. Huber <looseleaf@gmx.net>
    wrote:

    > The installation went fine and I did *no* receive the error about the
    > trusted connections. However, I received "Authentication for user sa
    > failed" when simply doing this
    >
    > osql -Usa -P -dmaster
    >
    > Any clues?

    The only thing that I can tell you is that the MSDE instance accepts the
    administrator password as sa password...So the problem is solved but not
    the circumstances that produced this setup.

    Stefan


  • Next message: Aaron: "MSDE Deployment Toolkit"

    Relevant Pages

    • Re: Connect to SQL 6.5 from Win XP Pro
      ... Check the SQL 6.5 Servers authentication mode. ... Standard, Integrated, or Mixed. ... Authentication using trusted connections ...
      (microsoft.public.sqlserver.connect)
    • Help please to authenticate Windows users
      ... I found documents explaining how authentication process works and authenicates using Active Directory. ... Please help to understand what else should be installed on server or how trusted connections can be created to "a Key Distribution Center " because of Kerberos method is used by Intergrated Windows authentication. ...
      (microsoft.public.inetserver.iis.security)