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