CREATE ENDPOINT SQLEP Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

CREATE ENDPOINT SQLEP Issue

Author

Topic

micnie_2020
Posting Yak Master

232 Posts

Posted - 2012-09-13 : 21:54:50

Hi All,

I try:-
CREATE ENDPOINT SQLEP_GetProductInfo
AUTHORIZATION [Domain\MyUserName]
STATE = STARTED
AS HTTP
(
PATH = '/getProductInfo',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'assetser'
)
FOR SOAP
(
WEBMETHOD 'ContactInfo' (NAME='eAsset.dbo.getProduct'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'eAsset',
NAMESPACE = 'http://assetser/getProductInfo'
);

Error:-Msg 7850, Level 16, State 1, Line 1
The SQL Server Service account does not have permission to register the supplied URL on the endpoint 'SQLEP_GetProductInfo'. Use sp_reserve_http_namespace to explicitly reserve the URL namespace before you try to register the URL again.
Msg 7807, Level 16, State 1, Line 1
An error ('0x80070005') occurred while attempting to register the endpoint 'SQLEP_GetProductInfo'.

Then i try:-sp_reserve_http_namespace N'https://assetser:443/getProductInfo'
@
sp_reserve_http_namespace N'http://assetserv:80/getProductInfo'

Error:-Msg 7827, Level 14, State 1, Procedure sp_reserve_http_namespace, Line 1
The user does not have permission to reserve and unreserve HTTP namespaces.

Please advise.

Thank you.

Regards,
Micheale

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources