Connect from Azure to Render DB - need SSL settings?

Hello!

I’m quite new to this but I’m having this issue:

Backend (AspNet Core) was connecting just fine to Render PostgreSQL from localhost but now that I’ve hosted it on Azure it wont connect. I get a “The ConnectionString property has not been initialized” error. I’ve looked over my connection string variable and it should work. AI thinks I need to add SSL settings to my connection string but that doesnt seem to help either and I cant find anything in the documentations about SSL.

I have not turned on IP limitations in Render. My connection string (which worked fine from localhost) is in the format:

Host=****;Port=5432;Database=****;Username=****;Password=****

What is your experience on this, what SSL setting is needed?

Many thanks in advance!

Arvid

Solved it myself, AI was wrong, nothing to do with SSL. For others trying the same setup: In Azure Connection Strings do NOT select PostgreSQL in the “Type” drop-down menu, select Custom.

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.