RE: can't connect to sql server using sa

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 08/28/02 

From: lideng@online.microsoft.com (linda deng[MS])
Date: Wed, 28 Aug 2002 08:01:14 GMT

Hi Sys,

There are two typical kinds of the error 'Login failed'. One is the error
18452: Not associated with a trusted SQL Server connection, the other is
the error 18456: Login failed.

For the first error, it relates to the authentication mode supported by the
SQL Server. If your error is the first one, you can change the Windows NT
authentication to Mixed Mode. Please according to the Knowledge Base (KB)
article Q285097 (specified by oj) to modify the registry, if the SQL Server
is MSDE and you don't have the SQL Server client tools installed on the
machine, for example, the Enterprise Manager (EM). If the SQL Server is not
the MSDE, you can modify the authentication mode with EM.

If the error is the second one, you should make sure the password of the
account 'sa' is right or you can re-set the password for it. You can
implement this operation with the stored procedure 'sp_password' or EM.

For more information, please refer to Microsoft SQL Server Books Online.

Sincerely,

Linda Deng
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • RE: Settig SQL Agent pwd thru code
    ... I think you want to change the MSDE authentication mode to SQL Server ... If you installed MSDE as a named instance, ...
    (microsoft.public.sqlserver.security)
  • Re: Permission problem
    ... SQL Server has two Authentication mode: ... mixed mode (Windows and SQL Server). ... One of my costumers have a program that connects to a servers MSDE ...
    (microsoft.public.sqlserver.msde)
  • Re: Using DelphiSpeedUp hooks in package-based apps
    ... And the bug must be in the code that calls StrLen and not in StrLen. ... SQL Server or MSDE, and modify the connection string in MainFrm.pas. ...
    (borland.public.delphi.language.basm)
  • Re: security
    ... using Windows Authentication. ... SQL Server has two authentication mode: ... Server however he need to be assigned more sql server permissions to ...
    (microsoft.public.sqlserver.setup)
  • RE: How to access SQL Server from a non-privileged domain account
    ... account to be able to access the SQL Server. ... Since your SQL Server 2005 has been running with Windows Authentication ... Contact your network administrator to add your domain account to the ... Change your SQL Server 2005 authentication mode to Mix mode so that you ...
    (microsoft.public.sqlserver.setup)