Anonymous
Windows 2003 R2
SQL Server 8.0.2039
I am having the same problem described above:
I am trying to update a stored proc on one of our boxes.
I have logged in as SA.
I have logged in as Myself (windows, sysadmin).
I have logged in as a newly created ID with Sysadmin rights.
I have logged in with a newly created ID mapped to the database in question.
Even after trying all of the above I am still getting the same error when I try to "alter proc".
I can select @@servername or @@version just fine...
error:
Msg 18456, Level 14, State 1, Procedure Booked, Line 6
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
when I log in as SA the error is:
Msg 18456, Level 14, State 1, Procedure Booked, Line 6
Login failed for user 'SA'.
There is nothing in the logs. (agent,sql,system,security,application)
There are no linked servers involved.
has anyone fixed this type error before