Home > DeveloperSection > Blogs > HTTP Endpoints in SQL Server 2005, 2008

HTTP Endpoints in SQL Server 2005, 2008

Database Database 
0 Comment(s)
 3486  View(s)
Rate this:

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





Don't want to miss updates? Please click the below button!

Follow MindStick