# Inital configuration of SQL server in Dream factory - SAGE

**URL:** <https://community.dreamfactory.com/t/inital-configuration-of-sql-server-in-dream-factory-sage/3415>\
**Category:** Connecting to SQL\
**Created:** [November 4, 2016, 10:57am UTC](https://community.dreamfactory.com/t/inital-configuration-of-sql-server-in-dream-factory-sage/3415 "2016-11-04T10:57:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_Edwards](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/daniel_edwards/32/881_2.png) [@Daniel\_Edwards](https://community.dreamfactory.com/u/Daniel_Edwards)\
**Post date:** [November 4, 2016, 10:57am UTC](https://community.dreamfactory.com/t/inital-configuration-of-sql-server-in-dream-factory-sage/3415/1 "2016-11-04T10:57:54Z")

</div>

Hi all,

I’m new to Dream factory and was hoping I could get some help with this;

Both Dream factory and SQL Server are installed on the same machine, however I cannot get them to connect… service config is as follows -

Host - 127.0.0.1  
port - 1433  
database - demo  
username - \*\*  
password - \*\*

I then have gone onto the api docs to try and do a get of one of the tables however I keep getting ‘500’ error codes for internal fault.

The setup is basically (SAGE \<-\> SQL Server \<-\> Dream factory \<-\> Salesforce)

Has anybody done any kind of Sage integration or something similar?

Thanks!

---

<div class="post-metadata">

**Author:** ![gnieark](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/gnieark/32/816_2.png) [@gnieark](https://community.dreamfactory.com/u/gnieark)\
**Post date:** [November 7, 2016, 8:42am UTC](https://community.dreamfactory.com/t/inital-configuration-of-sql-server-in-dream-factory-sage/3415/2 "2016-11-07T08:42:29Z")

</div>

Hello,  
You need to install php PDO drivers [https://wiki.dreamfactory.com/DreamFactory/Installation/Databases/SQLServer](https://wiki.dreamfactory.com/DreamFactory/Installation/Databases/SQLServer)