Post reply

Could not find a login matching the name provided

  • July 23, 2013 at 4:55 pm

    #275566

    I have a classic asp web analytics site that i wrote to track traffic on my website. In my code i specify the SQL account & password, i see the below error in my application log on the SQL server:

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: webserver ip]

    How can i fix this?

    Background info:

    web server is iis 7.5 (separate box)

    SQL 2012 server (separate box)

  • July 24, 2013 at 6:16 am

    #1635324

    paste the contents of your web.config file so we can see if the connection string is correct.

  • July 24, 2013 at 6:55 am

    #1635337

    Is your SQL instance configured using mixed mode?

    Is the SQL login you are using in the connection string present and enabled on the SQL instance?

    Are you able to login the SQL instance with SSMS using the specific login?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • July 24, 2013 at 7:31 am

    #1635345

    I got it now i gave rights as DB_Owner to " NT AUTHORITY\ANONYMOUS LOGON " on the server as well as on the specific database

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

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