Re: msde login problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Hodgson (mike.hodgson_at_mallesons.nospam.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 15:01:05 +1100

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
>
>
>  
>

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: ASP 2.0, C#, LDAP Login, and Forms impersonation?
    ... Or, I could just start over with a windows authentication login, and after ... FormsAuthenticationTicket fat = fi.Ticket; ... I do not set any dwFlags. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Not associated with a trusted SQL server connection
    ... >mixed mode for security mode. ... >Login Failed for user 'username'. ... >server connection. ... >I am using DbaMgr 2k to view the database settings. ...
    (microsoft.public.sqlserver.setup)
  • Re: Best approach for authenticating users for various departments in ASP.Net
    ... well you could use windows authentication to do user authentication. ... they get to the login page.) ... a string ... > where the first "0" meant they didn't have permission to department 1, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MS Project Server 2003 login error
    ... > How are they trying to login again? ... > log on", and you are using Windows Authentication, then make sure they're not ... it will authenticate them through to the server. ... Cheryl ...
    (microsoft.public.project.pro_and_server)