---
title: "HTTP Endpoints in SQL Server 2005, 2008"  
description: "HTTP Endpoints in SQL Server 2005, 2008A HTTP Endpoint is a Sql Server object which is use by Sql Server to communicate over the network. It includes"  
author: "Chris Anderson"  
published: 2011-08-08  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/217/http-endpoints-in-sql-server-2005-2008  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# HTTP Endpoints in SQL Server 2005, 2008

HTTP Endpoints in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-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](https://www.mindstick.com/interview/746/how-do-you-invoke-a-web-method-of-web-service-in-ajax)(s) which are typically the **[Stored Procedures](https://www.mindstick.com/forum/540/using-stored-procedures-with-entity-framework-in-an-asp-dot-net-application)** (T-Sql or CLR) executed within the [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) and are queried by the [web services](https://www.mindstick.com/articles/942/basics-of-asp-dot-net-web-services).

Web services allow various [applications](https://www.mindstick.com/articles/12847/how-to-choose-the-right-ethernet-cable-for-industrial-applications) to communicate with each other. They are based on certain standards

- [Xml](https://www.mindstick.com/forum/145511/please-explain-json-vs-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](https://www.mindstick.com/articles/895/web-service-introduction) 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](https://www.mindstick.com/articles/43813/new-security-technologies) of a SQL Server.

## Creating Endpoint in SQL

CREATE ENDPOINT [MyFirstUserConnection]\
STATE = STARTED \
AS TCP \
(LISTENER_PORT = 1680, LISTENER_IP =ALL) \
FOR TSQL () ; \
GO

## Looking At Endpoint

SELECT * FROM sys.endpoints

---

Original Source: https://www.mindstick.com/blog/217/http-endpoints-in-sql-server-2005-2008

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.