Creation of SOAP(HTTP) SSL endpoint fails with error 0x80070494

Say you want to create an SSL endpoint for SOAP such as the following

CREATE ENDPOINT SOAP_ssl_endpoint
STATE = STARTED
AS HTTP (
SITE = 'localhost',
PATH = '/MySoapPath',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( SSL ),
SSL_PORT=443
)
FOR SOAP (
…………
);

And the creation fails with the error message

Msg 7807, Level 16, State 1, Line 1
An error ('0x80070494') occurred while attempting to register the endpoint 'SOAP_ssl_endpoint'

The windows error code 0x494 (1172 or ERROR_NO_TRACKING_SERVICE) usually implies that a service dependency failed. SSL endpoints require the windows "HTTP SSL" service to be enabled. The "HTTP SSL" service doesn’t have to be started. Creation of an SSL endpoint will automatically start the "HTTP SSL" service.

If you see the 0x80070494 error, try to start the "HTTP SSL" service (net start "HTTP SSL"). If the service fails to start, check the service manager for any services that "HTTP SSL" is dependent on and try to start those services to isolate the cause of failure. Normally the "HTTP SSL" service has a dependency on the "HTTP" service. But when IIS is installed on the machine, it creates a dependency from "HTTP SSL" to the "IIS Admin Service" The "IIS Admin Service" is more likely to be the cause of failure than the "HTTP" service.

Anuradha Rawal, SQL Server Protocols

Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights

Comments

• Anonymous
  February 28, 2006
  The comment has been removed

• Anonymous
  February 28, 2006
  Hi Perry,
  
  SQL 2005 exposes functionality to reserve a namespace using sp_reserve_namespace stored procedure.  See:
  
  http://msdn2.microsoft.com/en-us/library/ms190614.aspx
  
  So you have to log into SQL using the local administrator account and then use the sp_reserve_namespace stored proc to pre-reserve the namespace.  Then a non-local admin account can create URLs under the namespace.
  
  Let me know if this works for you.

• Anonymous
  May 22, 2006
  Quisiera saber porque al crear un ENDPOINT en mi SQL-SERVER 2003 no lo reconoce y me vota error,  
  gracias por su repuesta,
  PD. he creado un procedimiento almacenado
  este es el codigo que empleo
  USE MASTER
  go
  CREATE PROCEDURE prueba
  (@msg nvarchar(256))
  AS BEGIN
     select @msg as 'message'
  END
  go
  CREATE ENDPOINT prueba_endpoint
   AS
     AUTHENTICATON = ( INTEGRATED ),
     PATH = '/sql/demo',
     PORTS = ( CLEAR ),
     STATE = STARTED
  FOR SOAP (
   METHOD
     'http://tempuri.org/'.'prueba'
     (NAME = master.dbo.prueba)
   WITH
     BATCHES = ENABLED,
     WSDL = DEFAULT
   )
  go

• Anonymous
  May 24, 2006
  The comment has been removed

• Anonymous
  October 22, 2007
  Help, I am getting this error as stated above and When i try to pre-reserve the namespace i get an error that says the account does not have permission.   Where can i located the stored procedure.  i used the sys admin login and local admin, i is not working.

• Anonymous
  November 02, 2007
  The comment has been removed

• Anonymous
  April 16, 2008
  No puedo iniciar cecion me marca el error 0x80070005 y la verdad no se que hacer y les agradeceria mucho me puedan ayudar

• Anonymous
  September 05, 2009
  The comment has been removed