Azure Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'null'

I wrote an app and I am trying upload it on Azure. The app runs ok locally and has a SQL Server database as the backend; the app is based off MVC.

When I try to access a page such as /person, I get this error:

  • Haversine formula using SQL server to find closest venue - vb.net
  • getting metadata from table sql server (php)
  • Insert binary data into SQL Server using PHP
  • SSRS show value only on last page in body of report
  • MS Sql: Conditional ORDER BY ASC/DESC Question
  • migrate data from MS SQL to PostgreSQL?
  • Azure Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'null'.
    

    Anyone ever dealt with such an error and how did you resolve it.

    I have tried a few suggestions but none seems to work:

    • adding to config file
    • setting Persist Security Info=False to true

    What is the best way to solve this?

    One Solution collect form web for “Azure Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'null'”

    On the app’s data connection, the connection string had no userid. Adding a userid fixed the issue. Even though when the app was published with a proper connection string, the user id was empty.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.