SQL Database not listed?

(0) Share

Report

Posted on by KarlNixon

164

Reaching out to the brains trust for some help.

I've created connections to two SQL databases but only one shows up in the pick list for the Database name?

Any ideas why?

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (1)

Anupam.khasia 366 on at

Like (0)

Report
Please try following :

Try removing second sql connection and add it again.
Make sure you have SQL Server services running on server.
Create case with Microsoft Support
Let me know if above works.

Was this reply helpful? Yes No
Anupam.khasia 366 on at

Like (0)

Report

Please go through below link as well for limitation of SQL Server connection.

https://docs.microsoft.com/en-us/connectors/sql/

Was this reply helpful? Yes No
KarlNixon 164 on at

Like (0)

Report

Why would they be visable and active in Powerapps but not Power Automate?

Was this reply helpful? Yes No
Anupam.khasia 366 on at

Like (0)

Report

Looking at issue , it could be data glitch from Microsoft . I would suggest you to create a case with Microsoft.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @KarlNixon ,

I am afraid I did not understand your intention. As far as I know, a connection corresponds to a Database name, so only one Database is expected to appear in the Database name drop-down list.

What authentication method do you choose? If you use SQL Server Authentication and Windows Authentication, we also specify a separate database when creating a connection, so a connection corresponds to only one database.

Best Regards,

Was this reply helpful? Yes No
Verified answer

KarlNixon 164 on at

Like (1)

Report

Thanks - I managed to solve the problem.

The database can be selected by editing the selection on the action ie Insert Row (v2)

Was this reply helpful? Yes No