Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

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

Tags
AWS Schema Conversion Tool (AWS SCT)
Sprache
English
sek
gefragt vor 3 Jahren418 Aufrufe
3 Antworten
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

ggnanaraj
beantwortet vor 3 Jahren
0

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

sek
beantwortet vor 3 Jahren
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.

sek
beantwortet vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt