Cannoot see list of DBs - Connecting to a named SQL Server 2014 instance in Crystal 2016

[Former Member]

Hello,

I am trying to setup an OLE ADO connection in Crystal Reports 2016 Support Pack 2 to a SQL Server 2014 named instance where encryption is mandatory on the database side. I am using the Microsoft OLE DB Provider for SQL Server.

The list of databases is not populating. No error message appears.

I have confirmed that the credentials, instance name and port number are all correct. I can also connect using the credentials and instance name in SQL Server Management Studio.

I have tried using the following syntaxes for the server name:

SQL Server Name\Instance Name

SQL Server Name\Instance Name,Port number

SQL Server Name:Port Number

None of these have resolved the issue of not seeing a list of databases

Any suggestions on how to resolve this would be much appreciated.

crystal-reports-oledb-ado.jpg

[former_member11696]

Hi Tony,

For newer SQL Servers you need to install the SQL Server Client Native 10 or 11 clients.

When selecting the Driver use one of those and you'll be able to see the tables.

Don