Report this

What is the reason for this report?

How do i connect postgresql db from visual studio 2019 ?

Posted on November 16, 2019

hi everyone , here’s what i’ve been trying : step#1 : sign in to DO , in the Database CLuster, select Connection Details . step#2 : in Visual Studio 19 , Tools > Connect to Database > Change Data source to PostgresSQL step#3 : fill in the fields (SSL mode = Require) step#4 : Test connection

so far, what im getting is 28P01 : Password authentication failed for user ‘xxxxx’

Anyone can help me?

TQIA



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi @menarsikya,

From the error you are getting it would seem the password you are using is incorrect. Please make sure you are using the PostgreSQL user with it’s proper password.

Despite that, it does seem like you can connect to the server and everything. As soon as you’ve placed the proper password, everything should be working as expected.

Regards, KDSys

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.