5
Views
7
Comments
Connecting to MSSQL Server


Hi

I'm trying to connect to MSSQL Server database, I have an amazon E2 server and created a database inside it. I tried to add it through serveice center but I keep getting this error:

Connection String test failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

I tried all the recommended solutions in google but still having the error I don't know why.

I also followed the methods in here:

https://www.outsystems.com/forums/discussion/18446/connection-to-external-sql-server-database/#Post71125


I don't know why its still not working, any suggestions?

Rank: #156

Hi Faris,


I have done this before following this documentation and had no problem.

Can you confirm you followed all the steps here?


Hopefully it will help you.

Cheers,

João

mvp_badge
MVP
Rank: #76

Hi Faris,

See if this solution might help you. The original post is describes the same error that occurred while trying to connect to a SQL instance on an AWS server.

Regards,

Nordin

mvp_badge
MVP
Rank: #76

Hi Faris,

You should check your connection string.

There are some examples for SQL server available here.

https://www.connectionstrings.com/sql-server/

Regards,

Nordin

mvp_badge
MVP
Rank: #76

Hi Faris,

You can check out the documentation João shared with you earlier.

If you toggle the Configuration Mode to Advanced configuration, it will allow you to define your own connection string if needed.

Regards,

Nordin