Re: Failed to login with 'sa'

From: Steve Thompson (SteveThompson@nomail.please)
Date: 02/20/03 

From: "Steve Thompson" <SteveThompson@nomail.please>
Date: Thu, 20 Feb 2003 09:01:59 -0500

"John Chen" <johndebest@hotmail.com> wrote in message
news:#eLKwhK2CHA.1636@TK2MSFTNGP10.phx.gbl...
> After messing around with Edit Server Registration Property by swithing
back
> and forth between Windows Authentication and SQL Server Authentication,
now
> I can't login with sa account.
>
> I can only login with Windows Authentication and I've resetted the sa
> password but still no luck. If I try to login(in Enterprise Manager) with
sa
> account, I get the following error:
>
>
> SQL Server registration failed because of the connection failure displayed
> below. Do you wish to Modify anyway?
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server
> connection.

In order to login as 'sa', you need to use SQL Server Authentication.

Steve

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: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server 2005 login issure 2
    ... My programming knowlege is pretty rusty, but if you installed SQL Server ... if you installed with Windows Authentication and then ... ALTER LOGIN sa ENABLE; ... > If by any change you have read my original post titled "SQL Server 2005 ...
    (microsoft.public.sqlserver.connect)
  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)