Yukon and HTTP.SYS

You can sure tell that everyone is just getting started experimenting with this stuff, because while you can google to find how to *do* something in this space, you can't find the corresponding code to *undo* it :-)

What I'm talking about here is sp_reserve_http_namespace, which is a stored proc in Yukon that talks to HTTP.SYS and reserves an endpoint for its use. You need to use this if you want to expose a web service from the database directly (and your instance is running under LUA, good for you), something that I've been experimenting with for a project I'm currently working on.

So where's the sp_release_http_namespace? Or the sp_unreserve_http_namespace function? I poked around the master database but didn't see anything obvious. I just happen to be trying to move the web service to a different named instance of Yukon, and the old instance has a lock on the URL I need.

In any case, by searching the registry for a fragment of the URL I registered, I noticed that under the services key (HKLM\SYSTEM\CCS\Services), there's a key called HTTP. And under that, there's a subkey at Parameters\UrlAclInfo that has a list of named values, and there I found my registered pattern. I took a chance and deleted the entry with my pattern in it, and rebooted the system. Before rebooting, I tried net stop HTTP, but that just put it in a wacky state - apparently HTTP.SYS is the new RPCSS.EXE - I'll bet someday soon your system will melt if it's not running).

Ahh, my VPC just started back up. That's a good sign. Regedit shows the value I deleted is indeed still gone. Let's see if the pattern has been successfully unregistered, or if my machine is now toast. Bringing up SSMS and calling sp_reserve_http_namespace from my new instance again... WOOHOO it worked!

I'm sure Bob will be here soon with the official fix, but this seems to be working for now...