Adaptive Server is unavailable or does not exist


#1

Getting this error trying to GetRecords:

“Failed to connect to database.\nConnection failed to open the DB connection: SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (severity 9)”

Using Microsoft SQL Server 2008 R2.


#2

is this using the dblib driver? can you provide your connection string?


#3

Here is the connection string:

dblib:host=url:1433;dbname=myDB

Where url is the url to the server with SQL Server and myDB is the name of the database. In API Docs, I see the Gets, Updates, etc…


#4

The error means DreamFactory can’t talk to your sql server at the address you’ve provided.
Usually this is due to SQL server not being configured to listen for external tcp/ip connections.


#5

How did you resolve it?
I’m getting this same error when trying to connect to SQL server using dblib driver on ubuntu. though i’m able to connect from windows using sqlsrv driver. It used to work on 2.0.0-beta but when I upgraded to latest version it isn’t working. What additional setup needs to be done?


#6

are you saying your you upgraded Ubuntu 2.0.0-beta to 2.1 and your dblib connection stopped working?
What is your connection string?
For the Windows one that does work, is it on the same machine as the SQL server?