Home Forums Cloud Computing SQL Azure - Development Deploying Database project from Visual Studio to Windows Azure SQL Database (WASD PaaS) fails due to Master Database Login failure RE: Deploying Database project from Visual Studio to Windows Azure SQL Database (WASD PaaS) fails due to Master Database Login failure

  • If I create a User on the Master DB for that Login I get a bit further into the Deployment and DDL actions are occuring but it still fails during the Deployment : (bearing in mind that Login/User is db_owner on the target User database).

    SQL72014: .Net SqlClient Data Provider: Msg 916, Level 14, State 1, Line 1 The server principal "xxxxxxxxxx" is not able to access the database

    SQL72045: Script execution error. The executed script: