You must Sign In to post a response.
  • Category: SQL Server

    Login failed for user 'nt authority anonymous logon'

    Hi All,

    we are in progress of changing our windows services from sql account to windows authentication.
    So conn string will be changed to "data source=XXX ; initial catalog: XXX ; integrated security=true"

    for one of the services, it is working but for another it generates error
    login failed for user 'nt authority anonymous logon'
    i have tried with integrated security=SSPI, still same error.

    No idea what is the reason, the one it is not working is c# console application.

  • #769403
    1. In SQL Server Management Studio go to Security. Expand Logins.
    2. Right click NT Authority\ANONYMOUS LOGON.
    3. Change the default database to the database that you are trying to access.

    4. In the left pane, click server roles. Check the sys admin server role.
    5. Click OK to save the changes.

  • #769419
    Solution is:

    1.Create a user in sqlserver from Security section as SqlAuthentication
    2.IN VS 2012 ,Create your connection String with SqlAuthentication
    (determin Username and Password)
    3.there is no need to change any IIS configuration.

  • Sign In to post your comments