SQL Server allows you to access its data via a uniform resource locator (URL) over HTTP. The query looks like this:
You must replace the reference to YourServerName with the name of your server.
Before you can run such a query, you must first set up Internet Information Server (IIS) to accept a URL.
Several steps must be fastidiously followed before you can submit a URL request to SQL Server:
Create a folder named Customers in your \Inetpub\wwwroot directory.
Add two subdirectories, one called template and the other called schema.
From the Windows Start menu, select Start, Programs, SQL Server, ...