Skip to Content
Former Member
Nov 08, 2017 at 04:17 PM

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



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.