# Api Error Required extension or module 'sqlsrv' is not installed or loaded on DF v2 beta 4 **URL:** \ **Category:** Connecting to SQL\ **Created:** [October 27, 2015, 9:04pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670 "2015-10-27T21:04:09Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![scmaverick](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@scmaverick](https://community.dreamfactory.com/u/scmaverick)\ **Post date:** [October 27, 2015, 9:04pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/1 "2015-10-27T21:04:09Z")
Hlelo, I just download bitnami windows installer of DF v2 beta 4, which supposedly fixes the issue with loading MS SQL driver but I keep getting the same error. Bug still present? I am using sqlsrv mode. ---
**Author:** ![angelX](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/angelx/32/437_2.png) [@angelX](https://community.dreamfactory.com/u/angelX)\ **Post date:** [October 28, 2015, 11:29am UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/2 "2015-10-28T11:29:15Z")
Hi scmaverick, I’m newbie. Testing DF for future development. I experienced this bug when installing DF v2 beta 3. Found alternative (unofficial !) drivers here: > **[Unofficial Microsoft SQL Server Driver for PHP (sqlsrv)](http://robsphp.blogspot.com/2012/06/unofficial-microsoft-sql-server-driver.html)** > > Here are unofficial modified builds of Microsoft's sqlsrv and pdo\_sqlsrv drivers for PHP, version 3.0, for: PHP 5.6 for Windows Vista/200... Seems everything works fine (retrieving schema, tables list, etc), except that not able to get records (error _“Table " ;myTableName" ; does not exist in the database.”_. I don’t know if this bug is related to unofficial drivers. ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [October 28, 2015, 2:12pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/3 "2015-10-28T14:12:06Z")
@scmaverick did you install the sqlsrv drivers? @angelX that issue only exists if you installed Bitnami’s 64 bit package (which is the reason to use the unofficial drivers.) The official MS drivers still work with the 32 bit package. ---
**Author:** ![angelX](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/angelx/32/437_2.png) [@angelX](https://community.dreamfactory.com/u/angelX)\ **Post date:** [October 28, 2015, 4:31pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/4 "2015-10-28T16:31:22Z")
@formerstaff right, I have re-installed DF with 32 bits package, and works fine with official drivers (I was not happy using unofficial drivers). Still having trouble retrieving one record, filtering by field value. As a newcomer to DF, I think I need a few more hours for testing. Many thanks for the support ! ---
**Author:** ![scmaverick](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@scmaverick](https://community.dreamfactory.com/u/scmaverick)\ **Post date:** [October 28, 2015, 6:08pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/5 "2015-10-28T18:08:08Z")
Aha! I installed the 64 bits version because its labeled as the recommended one, but you are right, I just remembered that Microsoft drivers only exist for 32 bits, I may have gotten confused as somebody once told me the 64b was already available, but I think he was talking about the linux version. I will try 32b, hopefully it’ll work fine. Thanks! ---
**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\ **Post date:** [November 3, 2015, 8:33pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/6 "2015-11-03T20:33:16Z")
How did the new Bitnami packages work out for you? They removed the 64-bit stacks and now have a GA release of DreamFactory 2.0.1. ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 9, 2015, 3:07pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/7 "2015-11-09T15:07:32Z")
Just a note for anyone following this thread: With the removal of the 64 bit Windows from the Bitnami installers page, there is no need to use the unofficial drivers referenced above. We DO NOT recommend using them. We ONLY recommend using the official sqlsrv drivers from Microsoft. ---
**Author:** ![scmaverick](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@scmaverick](https://community.dreamfactory.com/u/scmaverick)\ **Post date:** [November 10, 2015, 6:36pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/8 "2015-11-10T18:36:22Z")
Actually, not good. I managed to make it work at least for the service creation but it was never able to connect to the database, if I wanted to see the schema it would hang and timeout with an error. If I wanted to test the api calls with the embedded swagger it would fail saying that the token was missing. And that was it for me, only had a couple of days for testing this before changing to something else as I had no more time. I never liked php integration with mssql anyway, starting with the fact that MS drivers as BS and only support 32b which is almost useless nowadays, so will probably wait for a newer more mature release before tetsing this again, but as long as MS doesn’t release any real fully working drivers for php will probably give up on this. ---
**Author:** ![Jabez\_Azariah](https://avatars.discourse-cdn.com/v4/letter/j/5e9695/32.png) [@Jabez\_Azariah](https://community.dreamfactory.com/u/Jabez_Azariah)\ **Post date:** [November 11, 2015, 11:00am UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/9 "2015-11-11T11:00:06Z")
very true. even i couldn’t get this sorted out. I know DF provides good features but it fails for a seamless setup and integration with SQL database. Hope they quickly rectify this problem. I can’t wait anymore as my deadlines have already cross but still following 😄 ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 12, 2015, 1:41pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/10 "2015-11-12T13:41:20Z")
Just wanted to clarify a few things on this post. Since 2.0 is now officially released these types of issues have been resolved. Of course you will still have to install the sqlsrv driver separately. This is due to Microsoft’s licensing restrictions, not any kind of deficiency in the DreamFactory software. If you’d like a seamless install for connecting to MS SQL, you’re welcome to try out a Mac or Linux bitnami image. They come with the FreeTDS dblib driver for connecting to SQL. No licensing issues there. ---
**Author:** ![cosmocracy](https://avatars.discourse-cdn.com/v4/letter/c/8baadc/32.png) [@cosmocracy](https://community.dreamfactory.com/u/cosmocracy)\ **Post date:** [November 30, 2015, 8:44pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/11 "2015-11-30T20:44:35Z")
> [@formerstaff](#): > > not any kind of deficiency in the DreamFactory software. Just my $0.02, I think DF could do better than a cryptic error (API/module not loading) if this is a known issue. Or something during the installation phase of the Bitnami image telling me not to bother with MS SQL 😄 Or better yet a link from the installer to wherever the MS driver is located–I’ll have to Google this now as I’m still confused whether I should keep trying to get DF working against my SQL Server 2012 database… Looks like a fantastically exciting product but I was hoping the Bitnami approach would let me quickly get something up for testing/learning. Thanks, EK ---
**Author:** ![cosmocracy](https://avatars.discourse-cdn.com/v4/letter/c/8baadc/32.png) [@cosmocracy](https://community.dreamfactory.com/u/cosmocracy)\ **Post date:** [December 2, 2015, 6:54pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/12 "2015-12-02T18:54:16Z")
Downloaded 2.0.1-1 and separately downloaded Microsoft’s SQLDRV. Still not working…getting the extension not loading error… It’s unclear (without instructions) what do do after downloading the 8+ DLLs from Microsoft (Use the PDO ones? Need to rename to remove version number and TS/NTS? Need to edit php.ini? Include both drivers/extensions in the .ini file? If so in what order? Higher/lower in the extension list? etc. etc.) I was really hoping this would be easier to do… : - ) ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [December 2, 2015, 7:06pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/13 "2015-12-02T19:06:29Z")
[https://wiki.dreamfactory.com/DreamFactory/Installation#Windows\_3](https://wiki.dreamfactory.com/DreamFactory/Installation#Windows_3) ---
**Author:** ![cosmocracy](https://avatars.discourse-cdn.com/v4/letter/c/8baadc/32.png) [@cosmocracy](https://community.dreamfactory.com/u/cosmocracy)\ **Post date:** [December 2, 2015, 8:06pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/14 "2015-12-02T20:06:47Z")
OMG, thank you! I just assumed I could use the installer : - ) but this looks like it will be very helpful. Thanks!! -EK (Edit to add more since I can’t add further replies as a newbie): Ok, I was close–everything except using the TS vs. NTS versions of the DLL. I can now connect–will try creating some service defs shortly. Thanks again -EK ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [January 6, 2016, 5:30pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/15 "2016-01-06T17:30:09Z")
3 posts were split to a new topic: [Issue with sqlsrv on 2.0.2 in Windows](https://community.dreamfactory.com/t/issue-with-sqlsrv-on-2-0-2-in-windows/1991) ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [January 6, 2016, 5:31pm UTC](https://community.dreamfactory.com/t/api-error-required-extension-or-module-sqlsrv-is-not-installed-or-loaded-on-df-v2-beta-4/1670/16 "2016-01-06T17:31:22Z")