Can't Connect to Remote MS SQL instance [RESOLVED]

Connecting to SQL
1

Hi,
I’m a new user attempting to get up and running.
I’ve installed DF on my local Win10 computer. As a first step I’m trying to connect to remote MS SQL instances.

  1. I have installed the PHP php_pdo_sqlsrv_55_ts.dll and php_sqlsrv_55_ts.dll in the “EXT” and the PHP ini File.
  2. I have been able to successfully telnet to the remote server on 1433.
  3. I am able to log in with SSMS
  4. I verified SQL is available to external connections.
  5. I’ve successfully created a service to the SQL server DB
  6. I’m unable to connect to the service under “API Docs” It will not retrieve any services.
    6a. When I open the “API Docs” link in a separate tab i get the following “Can’t read swagger JSON from http://localhost/api/v2/api_docs”

Can someone please help guide me to get the connection to succeed?

Thanks,
Gus

2

Ok. I found the problem:

  1. I could not find the server logs. All the posts I read had the incorrect path to the logs, i.e., I used the Bitnami installer with the DreamFactory Stack 2.0.4-2. And, with my install the log file was C:\Bitnami\dreamfactory-2.0.4-2\apps\dreamfactory\htdocs\storage\logs\dreamfactory.log. Once I reviewed the log it immediately highlighted the problem, i.e., “Connection failed to open the DB connection: SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver 11 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86”
  2. Although I had the MS SQL driver 11 installed it was the x64 version. I found the installer here.
  3. I was able to install the x32 and not need to uninstall the x64.

Hopefully this will help anyone else with this problem.

Gus

1 Like
3

If anyone else is running into this problem, the instructions for installing additional resources necessary for ms sql connections are covered in the wiki here: https://wiki.dreamfactory.com/DreamFactory/Installation/Databases/SQLServer