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]
STATE = STARTED
(LISTENER_PORT = 1680, LISTENER_IP =ALL)
FOR TSQL () ;
Looking At Endpoint
SELECT * FROM sys.endpoints