Failed to launch service

Connecting to SQL
1

Getting the below error. I am using the Bitnami Vmware Image and have this setup locally on my network.
I am using MSSQL 2008 Server R2. I can connect to sql server from other computers on network. Also followed MS SQL Connection String Format

Response Body
{
“error”: [
{
“context”: null,
“message”: “Failed to launch service “sql”: CDbConnection failed to open the DB connection.”,
“code”: 500
}
]
}

Response Headers
{
“Pragma”: “no-cache”,
“Date”: “Thu, 25 Sep 2014 17:40:29 GMT”,
“Server”: “Apache”,
“X-Frame-Options”: “SAMEORIGIN”,
“X-Powered-By”: “PHP/5.4.32”,
“Transfer-Encoding”: “chunked”,
“P3p”: “CP=“IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT””,
“Cache-Control”: “no-store, no-cache, must-revalidate, post-check=0, pre-check=0”,
“Connection”: “close”,
“Content-Type”: “application/json; charset=utf-8”,
“Expires”: “Thu, 19 Nov 1981 08:52:00 GMT”
}

2

JaY0,

Can you telnet to this sql server instance from your local machine?

Also, what does your connection string look like - I assume that you’re using the dblib driver. Most of these issues are related to cloud security in some fashion. Have a look here, though it is with Azure, still provides some useful hints.

Let me know about your progress.

Thanks,

  • Mark
3

Thanks Mark putting in the port number after the IP sorted it.