Error while connecting to SQL Server Express Edition from SCT
I have installed SQL Server Express Edition and SCT in my system. I tried connecting to SQL Server from SCT. But, while testing, it throws an error saying "com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <hostname>, port 1433 has failed. Error: "Permission denied: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". Can someone assist. Thanks
As per SCT documentation @ https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html
Microsoft SQL Server (version 2008 and later) are supported as source. What is the version of SQL Server Express Edition being used?
Edited by: ggnanaraj on Jul 12, 2021 6:28 AM
Thanks for your reply. I have installed sql server 2019 enterprise edition
I got it fixed by self. Enabled the tcp/ip in the sql configuration manager and updated the all port as 1433 and restarted the sql server service. This can be done only with windows administrative privileges.
Relevant questions
Error loading metadata using AWS SCT against an RDS SQL Server Instance
asked 5 months agoError while connecting to SQL Server Express Edition from SCT
asked 10 months agoAWS DMS Issues | Duplicate Tables and SCT Conversion Issue
Accepted Answerasked 2 years agoHow to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.
asked 13 days agoSCT connecting to MySQL over SSL
asked a month agoAWS Trusted Advisor optimization checks for Microsoft SQL Server on Amazon EC2
asked 4 months agoWhich application types can use SQL Server Web Edition on RDS?
asked 21 days agoSQL Server master user privilege problem
asked 3 years agoSQL Server on RDS Issue With Linked Server
Accepted AnswerError metadata loading was interrupted because of data fetching issues
asked 2 years ago