cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarlNixon
Resolver I
Resolver I

SQL Database not listed?

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?

 

 
1 ACCEPTED SOLUTION

Accepted Solutions

Thanks - I managed to solve the problem.

 

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

 

 

 

View solution in original post

6 REPLIES 6
anupam8555
Continued Contributor
Continued Contributor

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.

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

 

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

 

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

anupam8555
Continued Contributor
Continued Contributor

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

v-bacao-msft
Community Support
Community Support

 

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.

187.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks - I managed to solve the problem.

 

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

 

 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,266)