Accessing Database Objects Using HTTP

Question

Is it possible to access database object using HTTP in SQL Server 2012 the way it was done using SQL Server 2000?

I referred following article but it is about SQL Server 2000.

Accessing Database Objects Using HTTP

I want to access the database object in following manner

http://iisserver(my machine ip)/nwind/dbobject/Test4[@Id='1']/@x

Answer 1

As shown in the article http://technet.microsoft.com/en-us/library/cc646023.aspx#BKMK_ssde, the SQL server can be configured to be accessed via HTTP. To achieve this you firstly need to create and endpoint (as described here). Among this, the firewall issue is also need to be checked because of the additional ports usage. But, according to this article, the HTTP endpoints will not be supported in the future versions of SQL Server.