Re: Queue Reader ODBC Error: Login failed for user "sa"

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

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 07:59:16 -0400

authentication is done on a exe level. Can you right click on your queue
reader agent, select agent properties, run steps, and click on the run agent
command. What is your sa password there? It should be something encrypted.

Is there no way you can use trusted authentication to bypass this problem? 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Salty Dog" <SaltyDog@discussions.microsoft.com> wrote in message
news:805E9ECC-CD66-489C-8977-0B2DF77CD4C6@microsoft.com...
> Still the same error.  I've recreated the Publisher and Subscriptions
several
> time and still not go.  I have Subscription security using sa with
password
> instead of NT authentication.  I'm really stumped or could you tell?
>
> I'm configured for Immediate with Queued for failover. This was working
> prior to adding a password.  Any other help you can give me?
>
> Another note: Prior to a complete startover of creating the Publisher and
> all, I was getting the same error.  The crazy thing was that the Red Error
Xs
> would disappear every once in a while and processing would resume like
> everything was OK for just a few seconds.  It would stay down longer than
> logged on/up and running.
>
>
> "Salty Dog" wrote:
>
> > This looks like the information that I need.  Thank you so much and I
will
> > get back after I apply.
> >
> > "Hilary Cotter" wrote:
> >
> > > does this help?
> > >
> > >
http://support.microsoft.com/default.aspx?scid=kb;en-us;320773&Product=sql2k
> > > "Salty Dog" <Salty Dog@discussions.microsoft.com> wrote in message
> > > news:7B1EB304-FC0E-4495-AB1E-44AC6666634E@microsoft.com...
> > > > After implementing a password for the sa account, I'm getting the
error:
> > > >
> > > > ODBC Error: Login failed for user "sa"
> > > >
> > > > I thought that there was stored procedure where I could set the
password
> > > > for
> > > > the Queue Reader Agent but I can't find it.  Can anyone assist me
here or
> > > > have any insight into this error?
> > > >
> > > > Thanks in advance.
> > >
> > >
> > >

Relevant Pages

  • Re: Apache Software Foundation Server compromised, resecured. (fwd)
    ... OpenSSH distribution has X11 forwarding turned off at the server to ... > 1) we got a possible threat abusing the agent in several manners since ... what I'd like to see is a change in the RSA agent authentication ... forwardings per client session, etc, etc). ...
    (FreeBSD-Security)
  • Re: Subscriber Security Settings for Distributor and Publisher log
    ... I cant check the agent properties from here, as the subscriber is in another ... > It is done through SQL Server authentication or NT Authentication. ... using Authentication it authenticates using the account that your SQL Server ...
    (microsoft.public.sqlserver.replication)
  • Re: challenge-based impersonation: is it possible?
    ... > I am trying to access a service (e.g. Exchange) on behalf of a user> without the user having to reveal her password. ... a user may want to have an agent run on her behalf> without having to give away her password. ... > A better solution is to have an "authentication facilitator" capable of> answering challenges and let the user> grant access to this service for the agent. ... But the> trick is that impersonation has to be done without the knowledge of my> password. ...
    (microsoft.public.platformsdk.security)
  • Re: OWA logins not working properly
    ... There have been no system changes made and it was working fine prior to the ... power outage which now has me thinking that it might be possibly a DNS issue. ... Authentication still enabled for the OWA virtual directory? ...
    (microsoft.public.exchange.misc)
  • RE: Intranet Windows Auth and Forms
    ... seen this post online and was evaluating it for a couple ... days prior to my post in this newsgroup. ... multiple times and then ask them once more. ... web.config authentication method is identified as Windows ...
    (microsoft.public.dotnet.framework.aspnet.security)