Re: Trouble with sa password

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 07/05/02 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Thu, 4 Jul 2002 23:07:39 +0100

In your DTS packages how are your SQL Server
connections defined - if any use sa then you will
need to change the password or better still use NT authentication

HTH
Jasper Smith

"Namir Rodriguez" <Namir_Rodriguez@hotmail.com> wrote in message
news:12fde01c2239b$15cdb120$a5e62ecf@tkmsftngxa07...
> I have Windows Authentication in the Connection
> Properties.-
>
> I'm looking that the problem is only with the jobs that
> run DTS packages.
>
>
> >-----Original Message-----
> >In EM goto Management Folder>SQL Server Agent.
> >Right click and choose Properties and click on the
> >connection tab. Change the password or alternatively
> >use NT authentication
> >
> >HTH
> >Jasper Smith
> >
> >"Namir Rodriguez" <namir_rodriguez@hotmail.com> wrote in
> message
> >news:1545c01c22364$a04df300$3aef2ecf@TKMSFTNGXA09...
> >> Hi all!..
> >>
> >> I have a SQL Server with 25 jobs running.... The jobs
> >> executes Database Maintenance Plans over the databases
> and
> >> other run DTS Packages...
> >>
> >> When I change the 'sa' password, all the jobs fail with
> >> the message:
> >> Invalid password for user sa
> >>
> >> What can I do, I need to change de sa password
> >
> >
> >.
> >

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: C# connection string using Windows NT Authentication
    ... you indicate that you are using Windows ... If you are connecting to a local instance of SQL Server on your ... it sounds much less like a connection string ... you'll need to resort to SQL Authentication. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problems Using Laptop As SQL Server - Log On Failed
    ... > connected to the network and no password for windows. ... > the name of the laptop as name of the SQL Server. ... > trusted SQL Server connection ... you have to change the authentication mode... ...
    (microsoft.public.sqlserver.msde)
  • Re: No Windows, Only SQL Server Authentication
    ... To establish a Windows authenticated connection from OSQL, ... SQL Server programatically. ... Your connection string needs to specify the type of authentication desired. ...
    (microsoft.public.sqlserver.security)
  • Re: That $%#@ "Trusted Connection" Thing Again...
    ... SQL Server ODBC Driver Ignores Authentication ... What is the connection string you are using? ... Have you run Component checker to ...
    (microsoft.public.sqlserver.security)
Quantcast