This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENF%3C/text%3E%3C/svg%3E)
Azure SQL Migration (SQL to AZURE)
In Step 4 Azure SQL Target:
Keep asking for the target user user name and password
Please advise where I can find this information
Thanks,
Norbert
Hi Norbert,
You can get this from the Azure SQL Properties > Server Admin login and the password that goes with it.
Read more on authentication at the following link:
If this is helpful please accept as answer or upvote.
Best regards,
Dillon Silzer | Cloudaen.com | Cloudaen Computing Solutions
Hi Dilon,
Thanks for your response,I am getting now the following error: An error occurred while connecting to the target server.
========================
Connection error: Login failed for user 'CloudSA94537611'. Reason: Azure Active Directory only authentication is enabled. Please contact your system administrator.
Warmest regards,
Norbert
Hi Norbert,
You can disable this setting:
I would ensure you check whether this conflicts with any jobs in your environment before disabling, but this would be the option to enable Azure SQL username and password.
Oh sorry Dilon I did not see your prior message.
I will follow up with your suggestion
Norbert
Hi Dilon,
I am trying my best, now I am getting this error message:
An error occurred while connecting to the target server.
========================
Connection error: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database).
Thanks,
Norbert
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Hi @NORBERT FOIGELMAN,
I wanted to check in and see if the document you shared helped you resolve the issue.
To connect to the server, please use the Private Endpoint from within your virtual network. You can find more information on how to set this up in the following link: Azure SQL Database Private Endpoint Overview.
Hi @NORBERT FOIGELMAN,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hi @NORBERT FOIGELMAN,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Dear Dillon,
I follow up0 all the steps and now I am getting
An error occurred while connecting to the target server.
========================
Connection error: Login failed for user 'CloudSA94537611'. Reason: Azure Active Directory only authentication is enabled. Please contact your system administrator.
As you can realize I have no experience with Azure, I am trying to make it work to make a decision.
Warmest regards
Norbert