Re: msde login problem

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

From: Antonin Koudelka (Antonin.Koudelka_at_fmc.sa.gov.au)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 15:29:22 +1030

Thanks Mike,

It works now.

Antonin
  "Mike Hodgson" <mike.hodgson@mallesons.nospam.com> wrote in message news:eThC6n8FFHA.2156@TK2MSFTNGP09.phx.gbl...
  By default, MSDE is installed with Windows Authentication only. So unless you've changed it to mixed mode you'll only be able to login with trusted logins (not 'sa'). To change to mixed mode you have to change a reg value, viz. "HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode" or "HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode" for a named instance (detailed in http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022). The values for the reg key are:
      1 - Windows only mode
      2 - Mixed mode (Windows & SQL authentication)

  Cheers,

  --
  mike hodgson | database administrator | mallesons stephen jaques
  T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
  E mailto:mike.hodgson@mallesons.nospam.com | W http://www.mallesons.com

  Antonin Koudelka wrote:
I installed MSDE in my computer. When I try to connect to a database from a
program I get an error message:

      Code = 80004005
      Code meaning = Unspecified error
      Source = Microsoft OLE DB Provider for SQL Server
      Description = Login failed for user 'sa'. Reason: Not associated with
a trusted SQL Server connection.

Please help.

Antonin