SQL Server Service Instance with Stored Procedure | Community

Symptoms

This is an Appit instance. I am trying to connect to a SQL server on premise to make use of a stored proc.

Diagnoses

As Appit is a cloud-based platform, when registering a SQL server service instance please consider if this SQL server is accessible from the internet via public domain/IP address and/or port. Is this SQL Server Online (Azure) or perhaps SQL Server on premise?

SQL Server Online (Azure):
https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/

SQL Server OnPremise:
https://technet.microsoft.com/en-us/library/aa213767(v=sql.80).aspx

http://help.k2.com/onlinehelp/k2appit/UserGuide/1.3/default.htm_ServiceBrokers/SQLServer/SQL_Server_Service.htm?Highlight=sql

Resolution

Instead of exposing the data via SQL stored procedure, it was exposed as a web service instead in which case either the Endpoint WCF or Endpoint WebService can be used to access this data&colon;

http://help.k2.com/onlinehelp/k2appit/UserGuide/1.3/default.htm_ServiceBrokers/EndPoints/EndPoints_WCF.htm

http://help.k2.com/onlinehelp/k2appit/UserGuide/1.3/default.htm_ServiceBrokers/EndPoints/EndPoints_WEB.htm

Be the first to reply!

Reply