First published on MSDN on Oct 26, 2005
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
Updated Mar 23, 2019
Version 2.0SQL-Server-Team
Microsoft
Joined March 23, 2019
SQL Server Blog
Follow this blog board to get notified when there's new activity