Re: Login failed for user 'sa'

Do you have any update triggers on the table? Perhaps it contains code
connecting with the wrong 'sa' password.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:uFET$e2IGHA.668@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I havwe small db in sql2000. the db owner is sa, i'm a sysadmin.
> When login sql query analyzer as sa and run the following sql script,
> update table1set name = 'my name' where id = 1.
> I rec'd the error as follows,
> Login failed for user 'sa'
>
> Any ideas?
>
> Thanks
>


.

Relevant Pages

  • Re: How to add a login with Win XP Home workgroup and without doma
    ... To use any command to SQL server we need trusted connection. ... "Dan Guzman" wrote: ... but not others in workgroup. ...
    (microsoft.public.sqlserver.security)
  • Re: TCP 1433 and UDP 1434
    ... I know what the ports are for my question is does SQL Server 2005 have the ... "Dan Guzman" wrote: ...
    (microsoft.public.sqlserver.security)
  • Re: Enumerate databases
    ... Dan Guzman schreef: ... I've also seen the INFORMATION_SCHEMA.SCHEMATA view (SQL 2000) used for this ... That technique will break in SQL 2005 ... enumerate all databases in my SQL Server? ...
    (comp.databases.ms-sqlserver)
  • Re: Nested Partitions?
    ... I would like to influence my query so that a particular index should be ... Considering I am using sql 2005, how do you force use of an index. ... Are there instances where sql server doesn't use an indexes even though ... "Dan Guzman" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Login failed for user sa
    ... SQL Server MVP ... I havwe small db in sql2000. ... When login sql query analyzer as sa and run the following sql script, ...
    (microsoft.public.sqlserver.security)