New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. CreativeFreedom.org.nz is against this unjust law - help us


A Space for All Things .NET Related


Unable to create SQL ENDPOINT

By James Hippolite, in , posted: 30-Jan-2009 13:47

ProblemI'm doing a SQL Server CREATE ENDPOINT lab.  I have stopped the IIS Admin service, as recommended in the documentation.  I am connected to SQL Server as a Local Admin user (with full SA rights).  But still the CREATE ENDPOINT statement was failing:

CREATE ENDPOINT GetEngineeringList
STATE = STARTED
AS HTTP (
 SITE = 'localhost' ,
  PATH = '/sql/employees' ,
 AUTHENTICATION=(INTEGRATED),
 PORTS=(CLEAR)
)
FOR SOAP (
 WEBMETHOD 'GetEngineeringEmployees'
(
  name = 'AdventureWorks.dbo.GetEngineeringEmployees' ,
  schema =STANDARD
),
 WSDL= DEFAULT ,
  DATABASE = 'AdventureWorks' ,
 BATCHES=ENABLED
)
ExplanationContrary to logic, the CREATE ENDPOINT statement does not run with the rights of the issuing user.  It runs with the rights of the SQL Server service account.  That account doesn't have rights to the PATH I specified.
SolutionReserve the PATH using this command:

EXECUTE sp_reserve_http_namespace N 'http://localhost:80/sql/employees'


More information

Other related posts:
Geek Post Monthly Newsletter Volume 2 Issue 6
Exam 70-300 Objective 3
COALESCE T-SQL Function






Add a comment

Please note: comments that are inappropriate or promotional in nature will be deleted. E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.

Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
Wellington
New Zealand


Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".