PDA

View Full Version : Connection Manager - Add a Connection



Ian Smith
21-Feb-2017, 09:30 AM
Server selected - connection tested OK.

The "Select or enter a Database Name" combo fails to load the list of databases on a server with 300+ databases.

(Manually typing the database name works.)

Stephen W. Meeley
21-Feb-2017, 09:58 AM
I've never tried it on a machine with that many databases. Thanks for the report.

Ian Smith
21-Feb-2017, 11:48 AM
Hi Stephen

Really, I’m surprised…

While you are checking this, please also check the logic for the "Select SQL Server" lookup list. This is only returning server names, I think these days it also needs to include server\instance names.

e.g.
Server is called LTP-LT100
Database installed instances are
LTP-LT100\SQLEXP2012 and
LTP-LT100\SQLEXP2014
(there is not a database server that can be referenced with just LTP-LT100)

Regards