March 10, 2009 at 7:34 am
try to create a web service in SQL server 2008 to call a stored procedure:
CREATE ENDPOINT Weather_CurConditions
STATE = Started
AS HTTP
(
PATH = '/CurrentConditions',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR), CLEAR_PORT = 8080,
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'GetWeather'
(NAME = 'test.dbo.usp_GetWeather'),
WSDL = DEFAULT,
DATABASE = 'test',
NAMESPACE = DEFAULT
)
and get following error message:
Msg 7850, Level 16, State 1, Line 3
The SQL Server Service account does not have permission to register the supplied URL on the endpoint 'Weather_CurConditions'. 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 3
An error ('0x80070005') occurred while attempting to register the endpoint 'Weather_CurConditions'.
I have put SQL Server Service account in administrators group, should have full permission on local computer.
How to solve this issue?
March 10, 2009 at 11:09 am
The error message gives you what you need to do. In order to setup an HTTP endpoint in SQL Server 2008 (or 2005), you must first reserve a URL which SQL Server will look for. You can do this by using sp_reserve_http_namespace. If you check in Books Online, you should have all the details you need:
SQL Server 2008 BOL: Reserving an HTTP Namespace
K. Brian Kelley
@kbriankelley
July 8, 2009 at 4:51 am
Hi there
I am also trying to create an HTTP end point and i am trying to use the sp_reserve_http_namespace however i keep on getting the following error message:-
The user does not have permission to reserve and unreserve HTTP namespaces.
any ideas
July 29, 2009 at 9:56 am
I am still getting the error
"Msg 7850, Level 16, State 1, Line 2
The SQL Server Service account does not have permission to register the supplied URL on the endpoint 'hello_world_endpoint'. 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 2
An error ('0x80070005') occurred while attempting to register the endpoint 'hello_world_endpoint'."
even after exec the proc
sp_reserve_http_namespace N'http://localhost:80/sql/demo'
GO
August 26, 2010 at 8:08 am
I think this error occurs when we try to execute sp_reserve_http_namespace SP from a account that is in different domain and machine is in different domain. When machine and service account are in same Domain sp_reserve_http_namespace works without any error.
January 7, 2011 at 2:09 pm
Just wondering if you ever got this resolved. We're having a similar issue.
August 25, 2011 at 2:54 am
To reserve/delete the http namespace you need local admin rights on the box.
See BoL: http://technet.microsoft.com/en-us/library/ms190614(SQL.90).aspx
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply