Deploy to Azure - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON error

  • Hi to all,

    Using the wizard “database – Tasks - Deploy Database to Microsoft Azure SQL database” is prompting the following error when connecting to the (SQL)server:

    "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (.Net SqlClient Data Provider) "

    Loging into AZURE-portal with my xxxxx@xxxx.onmicrosoft.com and password is going OK.

    In AAD I’m not able to see attached roles for the used user-account only that I ‘m an admin…..

    IP addresses in the AZURE firewall are set and OK.

    Registering/connecting to the AZURE databases in SSMS is going OK.

    Server configuration on-premise is mix-modus.

    I even tried to create the SQL login xxxxx@xxxx.onmicrosoft.com on the server I’am working on.

    What do I miss ????

    Regards,

    Guus Kramer

    The Netherlands

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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