Re: sa password

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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 08:38:30 +0100

Seems your SQL Server is configured to only accept windows logins. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"thejackofall" <thejackofall@discussions.microsoft.com> wrote in message
news:CFA673B5-E810-468C-9016-B0A084EA375D@microsoft.com...
> I lost my password for sa.  So, I do the following, but it doesn't seem to
> work.
>
> 1)  I login to SQL Server thru the query analyzer using Windows
> Authentication.
> 2)  sp_password NULL, 'password', 'sa'
> 3)  It indicates with "Password changed"
> 4)  I log out from the query analyzer.
> 5)  I try login to SQL Server thru query analyzer using SQL Server
> authentication.
> 6)  It indicates with a login error, and it says "Reason: Not associated
> with a trusted SQL Server connection.
>
> Does anyone shine some light?
>
> Thanks.

Relevant Pages

  • 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: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Why CAN I log in?
    ... Get into Query Analyzer however you got into it the first time. ... "bing" wrote in message ... Did you suggest login to SQL ... > installed on the sql server. ...
    (microsoft.public.sqlserver.server)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • 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)