By using AWS re:Post, you agree to the Terms of Use

Error while connecting to SQL Server Express Edition from SCT

0

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

asked a year ago42 views
3 Answers
0

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

answered a year ago
0

Thanks for your reply. I have installed sql server 2019 enterprise edition

answered a year ago
0

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.

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions