1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

AWS DMS endpoint test connection error

Discussion in 'Programming/Internet' started by mohan sahu, Oct 8, 2018.

  1. mohan sahu

    mohan sahu Guest

    I am trying to migrate MSSQL databases from on-premises to RDS instance. I have created SQL2014 expr. instance in RDS and i have SQL 2014 express edition in on prem in my corporate network. I am able to connect to RDS instance from my on prem SSMS. While i am using DMS service to migrate and creating endpoints, i am getting below error.

    Error Details: [errType=ERROR_RESPONSE, status=1022506, errMessage=Failed to connect Network error has occurred, errDetails= RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired ODBC general error.]]

    I am getting the same error even when i am testing the target endpoint which is an RDS instance. I have kept RDS and replication instance on the same VPC. Port 1433 is open in my system and as i am able to connect RDS instance via SSMS so there must not be port issue. Please help.

    Login To add answer/comment
     

Share This Page