Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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

Tag
Strumento di conversione degli schemi AWS (AWS SCT)
Lingua
English
sek
posta 3 anni fa417 visualizzazioni
3 Risposte
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
con risposta 3 anni fa
0

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

sek
con risposta 3 anni fa
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
con risposta 3 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente