Share
ReportReaching 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?
You’re offline. This is a read only version of the page.
163
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?
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,
Looking at issue , it could be data glitch from Microsoft . I would suggest you to create a case with Microsoft.
Please go through below link as well for limitation of SQL Server connection.
https://docs.microsoft.com/en-us/connectors/sql/
Please try following :
Let me know if above works.
All responses (
Answers (
