September 17, 2008 at 9:44 am
Hey,
I have been trying to get HTTP endpoints to work on my Dev SQL 2005 SP2 system.
I have tried with two different builds on Server 2003 R2, one with and one without IIS installed.
The accoutnt that I have SQL server running under is both an admin on the local box and Domain admin (this is a personal dev where I can do silly things like this).
Both times I am getting the following error;
Msg 7850, Level 16, State 1, Line 1
The user 'XXX\YYYYYY' does not have permission to register endpoint 'eX_AW' on the specified URL. Please ensure the URL refers to a namespace that is reserved for listening by SQL.
Msg 7807, Level 16, State 1, Line 1
An error ('0x80070005') occurred while attempting to register the endpoint 'eX_AW'.
I have used sp_reserve_http_namespace N'http://XXXXX' to resere the namespace and the endpoint builds but I cannot connect to it.
Can anyone give me some pointers so that I can try to get this working?
September 17, 2008 at 10:07 am
Is the account a sysadmin in SQL Server? Should be by default, but that can be changed.
September 17, 2008 at 10:25 am
The account that I am logged in with is domain admin/SQL sysadmin, the SQL service account has been granted SysAdmin and DBO of all databases.
I have tried being logged in witht he SA account but receive the same error. Also the HTTP SSL service is started. Are there any other services that should be atarted in order for this functionality to work? I have a few SQL Admin guides and they are not to specific on the area of http endpoints.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply