I am trying to move to 2.0 and am having problems. I tried to create a service to connect to SQL database and got a warning about SQL component not installed. I figured this was referring to the PHP driver (maybe I am wrong on this?). I downloaded the Driver for PHP (SQLSRV32) and extracted it to…

Microsoft SQL configuration requirements are the same in 2.0 as in 1.9 – https://github.com/dreamfactorysoftware/dsp-core/wiki/SQL-Database-Services#sqlsrv As for getting everything back to normal, try using API Docs or test_rest or a REST client to delete the offending service. Then clear the cach…

I have narrowed my problem down more. With a fresh install if I navigate to the php.ini file in the php folder, open the file, save the file without making any changes, restart the all the servers and login to the dreamfactory app all of my services now have a trash can icon next to them and look l…

Very strange, even if I open the php.ini file and close it (no changes, no save) the problem occurs.

What I meant was that even if the the UI is having problems, you could use the API to delete the service. The admin UI is breaking probably because you have an improperly configured service (or the drivers are not properly enabled for the service.) Deleting it would resolve that issue. test_rest is…

What service would I delete? this is a fresh install with no changes made to it. Only services are the ones that are automatically created on install. I can delete any of the services from the user interface I just cannot create or alter any of them.

So it appears my problem has nothing to do with the PHP.ini file or SQL. Fresh install, setup admin user everything is working fine. close browser and restart the servers via the bitnami stack interface. Problem occurs.

The service I was referring to you deleting was the sql service that I thought was causing the problem. Clearly that’s not the issue. Which version of the Bitnami stack are you running? beta1 or beta2?

beta2 I uninstalled the 1.9.4 then installed the 2.0 beta. All the services seem to be running fine. I watched them for a bit to make sure nothing was crashing. I tried changing logon accounts for the services to a local admin but it made no difference. I am stumped on this. I am still not enti…

Well any time you have an issue like that, check the dreamfactory log, and the apache logs. In DF 2.0 the dreamfactory log is in storage/logs. (This is in the htdocs folder on a bitnami install.) The apache logs should be in apache2/logs on a bitnami install.

Here is what is in my logs for errors. I tried to filter out what I thought was not meaningful hopefully I did not filter anything important. Dreamfactory Log Errors after initial installation: [2015-09-17 15:51:40] local.ALERT: Could not get cors config from DB - could not find driver [2015-09-…

Problems Getting SQL Server connection setup in 2.0

Connecting to SQL

formerstaff October 7, 2015, 1:47pm 14

There is a known issue with the Bitnami package and port numbers on install/uninstall. See here: Bitnami windows instalar on windows 10 x 64 (dream factory beta 2.0)

Topic		Replies	Views
2012 SQL Server Express troubles Connecting to SQL	2	3066	September 28, 2015
MS SQL connection not creating API's Connecting to SQL	9	3533	November 9, 2015
Api Error Required extension or module 'sqlsrv' is not installed or loaded on DF v2 beta 4 Connecting to SQL	13	7381	December 2, 2015
SQL Connection Bitami 2.0.1 Connecting to SQL	8	3272	November 2, 2015
MSSQL database connection - DF 2 (beta 2 and 3) Connecting to SQL	4	3240	November 9, 2015

Problems Getting SQL Server connection setup in 2.0

Related topics