Issues connecting to Remote SQL


#1

Hello,

Installed dreamfactory on my mac and windows server 2012. windows server has the SQL server installed. When I connect to remote sql from MAC, I can connect and have no issues. When I connect from the same server using its ip address (exactly like I do from mac) - it gives me an error

API Error
Failed to launch service “senseiinc”: CDbConnection failed to open the DB connection.
DreamFactory Utility Module
DreamFactory Utility Module: Failed to launch service “senseiinc”: CDbConnection failed to open the DB connection.

I also created a cloud version on dreamfactory server. I am able to connect to the remote sql without issues.

Help!

Thank you


#2

Hi,

Please refer to the guide I created on connecting to sql server within a windows environment:

Connecting to Microsoft SQL Server with DreamFactory. Simply follow the steps and then you should be good to go. Note that the driver you will use is going to change from dblib (linux based) to sqlsrv.

Keep us posted.

  • Mark

#3

Perfect, thank you. The drivers did the trick, all other items were as in the document.

Both dblib and sqlsrv works (on 1.8.0 version - dreamfactory.com and also on the server where the sql is hosted, which originally had issues). However, my local dev machine (MAC which has issues when I upgrade to 1.8, different error thread started) it is broke! This machine is still on version 1.7.8.

May be it is not related but it was working on dev machine before these changes. I will probably upgrade the dev machine to same version and test again (after the upgrade issue is resolved)

For now, I am set to work from the remote machine, until dev is set.

Thanks for help


#4

Update:
On the MAC which is still on 1.7.8 the following connection string worked -
dblib:host=xx.xxx.xxx.xx:1433;dbname=xxxx


#5

Great! Enjoy :smiley: