HTTP Endpoints in SQL Server 2005, 2008

A HTTP Endpoint is a Sql Server object which is use by Sql Server to communicate over the network. It includes the web method(s) which are typically the Stored Procedures (T-Sql or CLR) executed within the database and are queried by the web services.

Web services allow various applications to communicate with each other. They are based on certain standards

  • Xml -> It represents the data across various platforms.
  • SOAP (Simple Object Access Protocol) -> SOAP is a simple XML-based protocol to let    
    applications exchange information over HTTP.
  • WSDL (Web Service Description Language) -> WSDL is an XML-based language for describing Web services and how to access them.


Advantage of Endpoints

a.    The advantage of a user-defined endpoint is that traffic must be authorised before it even reaches SQL Server.


b.    A SQL Server endpoint is a useful point where one can enhance the security of a SQL Server.

Creating Endpoint in SQL


CREATE ENDPOINT [MyFirstUserConnection]


Looking At Endpoint


SELECT * FROM sys.endpoints





  Modified On Sep-18-2014 01:23:58 PM

Leave Comment