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

HTTP Endpoints in SQL Server 2005, 2008


Database Database 
Ratings:
0 Comment(s)
 3464  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]
STATE 
STARTED
AS TCP
   
(LISTENER_PORT 1680LISTENER_IP =ALL)
FOR TSQL () ;
GO

 

Looking At Endpoint

 

SELECT * FROM sys.endpoints

 

 

 

 


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

Follow MindStick