I can;t connect to postgresql: Service Principal oid mismatch for role.

Armando Cordova 10

Weird situation, I am able to connect to my postgresql flexible instance and can query the postgresql version, but after making a change on the query, for some reason I can't event connect:

Service Principal oid mismatch for role[my_user]

I didn't change my_user at all, if I undo my changes the connection works again.

GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2024-04-13T23:20:08.5933333+00:00

@Armando Cordova Thanks for posting your question in the Microsoft Q&A forum.

Can you please share the query you are trying and screenshot of the error you are getting?

Regards

Geetha
GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2024-04-17T15:24:58.4+00:00

@Armando Cordova We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Regards

Geetha
Armando Cordova 10 Reputation points

2024-05-16T05:27:57.3533333+00:00

you may close it as stale, honestly I haven't connected to the db for a while from local and I can't remember details.

Share via

I can;t connect to postgresql: Service Principal oid mismatch for role.

Your answer