MicrosoftSQL and dbgate deployed, but can´t connect to database.
jcostacurta1
PROOP

2 years ago

I´ve deployed both MicrosoftSQL and dbgate, but I can´t make a connection to the database.

I tried from my SSMS, from SQL node in workflow, from dbgate... None of the works. I alwayes get timeout error.

Thanks.

Solved

7 Replies

brody
EMPLOYEE

2 years ago

I will attempt this and let you know how it works out.

pray1
brody
EMPLOYEE

2 years ago

Update, it works fine, make sure sure both dbagte and the microsoft sql services are in the same project, here is how the variables map to the connection settings in dbgate -

  • MSSQL_SERVER - > Server

  • MSSQL_TCP_PORT -> Port

  • MSSQL_USERNAME -> User

  • MSSQL_SA_PASSWORD - > Password

Status changed to Solved Railway • over 1 year ago

jcostacurta1
PROOP

2 years ago

Great. From dbgate it worked fine. Thank you.

Is there any chance to access from my laptop using microsoft management studio?

brody
EMPLOYEE

2 years ago

Connect to the database via the public networking related variables.

jcostacurta1
PROOP

2 years ago

Yes, I tried exactly this way. I´m getting the same error I was getting before.

Attachments

Print%20Log...
brody
EMPLOYEE

2 years ago

I don't have microsoft management studio but I can connect to the database locally with dbgate just fine.

jcostacurta1
PROOP

2 years ago

Forget it. My bad.

Solved now!!!! Thank you so much!!!!

Loading...