I'm trying to connect to an Azure SQL database with the use of an Point-to-Site VPN connection based on Azure AD authentication. I can connect with the VPN without any problems and I get a green status that everything is…
I am trying to deploy dacpac to an existing sql db, and getting the following error: ##[error]*** Could not deploy package. ##[error]Unable to connect to target server 'AAA.database.windows.net'. Please verify the connection information such as the server name, login credentials,…
Table storage migration to sql Hello, We’ve got a table held in table storage that contains a value history dating back many many years. Looking at the analytics side, it holds over 0.5TiB. In this format, it’s useless unless you…
I know the question was asked, but non of the suggestions helped. I have databases from multiple users on my Azure SQL server. There is a login 'USER1', and a user created from that login, which is owner of 'DATABASE1'.…
Error 1: Failed to load one or more resources due to no access, error code 403. I checked with the answers here but they don't work for me. As the screenshots below suggest, I am the service administrator, owner and…
I am replicating my data from Azure SQl DB TO Azure SQL DB. I have some tables with date columns and some tables with just the ID columns which are assigning primary key. While performing incremental load in ADF, I…
I have an Azure SQL server and database which have MFA login and I am the admin. But when I try to establish a connection via a new linked service from ADF to this database using System Managed Identity option,…
I am trying to connect to azure sql database through Jupyter notebook and later to load the data into excel/csv .I have the details of server and database only .Username & password i think by default its taking my desktop…
I have been using the Azure Cognitive Search to create the indexes for two or more tables and using the API in .Net code to retrieve the values from the tables. Now I am trying to join two or more…
I'm currently trying to answer a problem that can only be answered by combining the datasets of two different Azure SQL databases (different servers, if that matters). When using user+password authentication, there was a way to do cross-database queries like…