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?
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
João Marques wrote:
That was the first thing I checked but no luck, I enabled the t2p and opened a firewall connection and everything but keep having the error
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
Nordin Ahdi wrote:
I start having new error, this one:
Connection String test failed: Format of the initialization string does not conform to specification starting at index 11.
You should check your connection string.
There are some examples for SQL server available here.
https://www.connectionstrings.com/sql-server/
Where should I put these codes?
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.