SSDT failing to publish: “Unable to connect to mas

Question

I'm attempting to use SSDT to publish to a SQL Server database in Azure. When I do so, I am seeing the following error:

Unable to connect to master or target server 'DATABASE_NAME'. You must have a user with the same password in master or target server 'DATABASE_NAME'.

Ignoring the fact that it's listing a database name as the server name in the error, I'm not sure how to resolve it. When I specify the target database, I can successfully Test Connection. I can also connect using the same creds to the database through SSMS.

After researching the error, it seems like it is often that the firewall for the database in Azure does not include the IP address of the machine you're publishing from. It not only contains my IP, but I added another firewall rule to allow every IP (0.0.0.0-255.255.255.255) to eliminate the firewall as a potential cause of the problem.

Any ideas?

Answer 1

* to publish to a SQL Server database in Azure*, you can use "Data Migration Assistant" (DMA).

I just tried it and it works smoothly without any issues (firewall and compatibility level)

please refer to this link SQL Server database migration to Azure SQL Database

for step by step: 10. How to migrate the SQL database to Azure with the Azure Database Migration Service

Answer 2

Try to connect to the SQL Azure database using Sql Server Management Studio and the ip getting listed in the management studio is the right ip address. Try to add to the SQL Azure firewall rules. The ip address listed in the firewall page of Sql Azure portal is not accurate.