Does SQL Server connect from Azure to Visual Studio using Windows authentication?

0
votes

I have an application developed using Visual Studio and SQL Server database. The default permission is Windows authentication on my local machine. I have also created an Azure SQL Server. Now I am connecting this database with Visual Studio.

I get this error:

enter image description here

I tried SQL Server authentication as well but it is not accepting user name and Password which I created in SQL Server in SQL Server authentication mode:

SQL Connection error

But the same credentials work in SQL Server:

Same credentials work here

1
visual-studioazureazure-sql-database

1 Answers

1
votes

you cant use windows auth (like the error suggests) to access Azure SQL, you need to use sql auth and\or Azure AD auth.

I tried SQL Authentication as well but It is not accepting UserName and Password which I created in SQL server in SQL server Authentication. - this only means you made a typo somewhere.