RE: Login failed for user 'sa'.

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 17:56:52 GMT

Check how SQLAgent is connecting to the server.
Use Enterprise Manager, Right Click on SQL Server Agent, Properties,
Connection Tab. Switch the connection to use Windows Authentication.

Thanks,

Kevin McDonnell
Microsoft Corporation

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

Relevant Pages

  • NEWBIE - cant run SSIS package in SQL server agent scheduled job?
    ... I have a SSIS package that runs fine in Visual Studio. ... But if I put it in a scheduled job in SQL Server agent, ... The package does have an ODBC connection in it. ... The connection uses a SYSTEM DSN connection to get data from another source on another machine. ...
    (microsoft.public.sqlserver.dts)
  • Re: Login failed for user sa.
    ... > Use Enterprise Manager, Right Click on SQL Server Agent, Properties, ... > Connection Tab. ... Switch the connection to use Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Sql Server Login Restrictions
    ... There's nothing built in but you could use some of the same logic using the ... and then close the connection with the fact that there's already an existing ... >> should be the higher numbered spid or the spid with the higher timed ... >> soon as the SQL Server Agent is started. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2005: Running TSQL commands in single-user mode
    ... Make sure to stop the SQL Server Agent service before connecting to the instance. ... Use sp_who to find the session ID of the active connection and use KILL to terminate it. ... Plamen Ratchev ...
    (comp.databases.ms-sqlserver)
  • Re: Help with long term network problem
    ... Using a CNET network switch connected to a CNet Wireless G router Model ... Having the chart listing all of the computers is a great start. ... /all" shows only an Intel 2200BG WiFi connection - no Ethernet is apparent. ...
    (microsoft.public.windowsxp.network_web)