Post reply

Security / rights / aunthentication problem

  • October 18, 2006 at 3:36 am

    #60881

    When trying to edit a stored procedure I get the following error 'error 18456: login for user 'NT AUTHORITY\ANONYMOUS LOGIN'.' to give you the background I have moved the Db in question from one server to another, the the old server is W2K with SQL2000 SP3 the new server is Windows 2003 with SQL2000 SP3, and have had this problem since.

    I have had a brief search of the topis and they all seem to suggest adding built-in/administrators back in, but it has not been removed (I have checked it is still there), I also don't understand why it is showing 'NT AUTHORITY/ANONYMOUS LOGIN' does this mean it is not getting the windows account information?

    Any ideas, thoughts, suggestions would be helpfull.

     

  • October 18, 2006 at 10:16 am

    #666571

    Does the stored procedure use a linked server?  There are lots of posts about this error being generated in that situation.  Search this site for "NT AUTHORITY\ANONYMOUS LOGIN".

    Greg

    Greg

  • October 19, 2006 at 4:31 am

    #666742

    Hi Mark,

    It sounds as though you  may have an orphaned user as a result of the move.  Check BOL for sp_change_users_login.  Run this against your DB as sp_change_users_login 'Report' first and if the user is orphaned rerun as sp_change_users_login 'Update_One', 'database username', 'login name'.

    Hope that helps

    Cath

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply