Authentication and Security - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Authentication and Security

Author

Topic

MBeal
Posting Yak Master

110 Posts

Posted - 2004-08-10 : 18:37:16

I am using SQL2000 Query Analyzer and trying to test something in Northwind. When I query the table for customers I get the results but when I try to update the table I get the following error message.

Server: Msg 18456, Level 14, State 1, Line 5
Login failed for user 'sa'.

I may not understand this correctly, but we are using a mixed mode for authentication -- the user that is logged in is NOT 'sa', but it is a system administrator with rights to everything. Where is the 'sa' coming from?

MBeal

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-10 : 19:13:30

Are you doing this against a linked server? Please post the code that is getting this error.

Tara

MBeal
Posting Yak Master

110 Posts

Posted - 2004-08-10 : 19:15:34

Update Customers
Set ContactName = 'ABC'
Where CustomerID = 'ALFKI'

ALFKI is the first one in the table. No, this is done at the server directly. I am not trying to send this command over to a different server.

MBeal

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-11 : 11:57:15

That's very strange. Do you have service pack 3a installed?

Tara

MBeal
Posting Yak Master

110 Posts

Posted - 2004-08-11 : 18:57:27

no. only service pack 2.

MBeal

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-11 : 18:59:07

Before installing sp3a (Hint, hint, hint, ;-)), I would suggest running SQL Profiler to see what is going on.

Tara