Wednesday, March 7, 2012

Problems with Create Endpoint

I'm on XP running SQL 2005 (9.0.1314) trying to create and endpoint on my local machine.

I'm trying to run the Adventureworks sample code:

CREATE PROCEDURE [dbo].[uspGetPersonInfo]

@.ID [int]

AS

BEGIN

SET NOCOUNT ON;

SELECT [FirstName],[MiddleName],[LastName]

FROM [AdventureWorks].[Person].[Contact]

WHERE ContactID = @.ID

END;

CREATE ENDPOINT SQLEP_AWPersons

STATE = STARTED

AS HTTP

(

PATH = '/AWpersons',

AUTHENTICATION = (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP

(

WEBMETHOD 'PersonInfo'

(NAME='AdventureWorks.dbo.uspGetPersonInfo', FORMAT=ROWSETS_ONLY, schema=STANDARD),

BATCHES = DISABLED,

WSDL = DEFAULT,

DATABASE = 'AdventureWorks',

NAMESPACE = 'http://Adventure-Works/Persons'

)
I get the following error message:

Msg 7890, Level 16, State 1, Line 1

An error occurred while attempting to register the endpoint 'SQLEP_AWPersons'. One or more of the ports specified in the CREATE ENDPOINT statement may be bound to another process. Attempt the statement again with a different port or use netstat to find the application currently using the port and resolve the conflict.

I did run netstat but since I am using Ports(Clear) I'm not sure what port could be giving the conflict.

Thanks for any help on this matter.

Did you get this sorted ?
I am having exactly the same problem...
|||Try

http://www.cubido.at/Blog/tabid/176/EntryID/36/Default.aspx
|||Did you checked netstat or httpcfg.exe for that ?

HTH, Jens Suessmeyer.

No comments:

Post a Comment