Azure Migrate - SQL Connection

KashifZahoor-7326 0 Reputation points
2023-04-14T14:30:07.4833333+00:00

Hi, Wonder if someone can assist. I am running an Azure migrate assessment for on-prem sql to get recommendations on the cloud. The assessment says DB Engine Running however Azure Migrate COnnection Status : Disconnected for SQL We ran an assessment yesterday and it has pulled some data down however the confidence level is 1 * I have ran all the troubleshooting steps and can't get sql to talk properly Has anyone had similar issues ? thanks Kash

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
813 questions
{count} votes

2 answers

Sort by: Most helpful
  1. VasimTamboli 5,075 Reputation points
    2023-04-14T20:31:32.9366667+00:00

    If the Azure Migrate assessment is showing that the SQL connection status is "Disconnected", it could indicate a problem with the connection between the Azure Migrate appliance and the on-premises SQL server.

    Here are some steps you can take to troubleshoot the issue:

    Check that the SQL Server is running and can be accessed from the machine running the Azure Migrate appliance.

    Make sure that the SQL Server is configured to allow remote connections. You can do this by opening the SQL Server Configuration Manager on the SQL Server and enabling the "TCP/IP" protocol.

    Verify that the SQL Server instance is configured to use the default SQL Server port (1433). If it is using a non-default port, you will need to specify the port number in the connection string.

    Check that the SQL Server instance is not blocking incoming connections from the Azure Migrate appliance IP address. You can add the IP address to the SQL Server firewall settings to allow incoming connections.

    Ensure that the user account specified in the Azure Migrate appliance has sufficient permissions to connect to and query the SQL Server.

    If none of these steps resolve the issue, you may need to check the Azure Migrate logs to see if there are any error messages or contact Microsoft support for further assistance.

    3 people found this answer helpful.
    0 comments No comments

  2. KashifZahoor-7326 0 Reputation points
    2023-04-17T14:20:01.6933333+00:00

    thanks for the answers. I found out that appliance didn't have SQL discovery and assessment agent in running status which I have ran the diagnostic tools and fixed the SQL status still shows as disconnected for now however it does say that a check-in can take up to 24 Hours for this so I hoping this will help. Going back to firewall etc.

    • SQL and Azure Migrate appliance sit on same network and can talk to one another fine
    • both above can get on to internet fine too
    • SQL instance runs on 1433 and is not filtering any traffic to it
    • TCP/IP named pipes are enabled Will post back further once I have more information by tomorrow

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.