HTTP endpoint error -- sql server new users

sql server new users : HTTP endpoint error

Gouri
3/17/2006 8:18:37 PM

Hi,

Create ENDPOINT AWProduction
STATE = STARTED
As HTTP
(
PATH = '/ADVENTUREWORKS',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'SQLLaunchPc'
)
FOR SOAP
(
WEBMETHOD 'GetProducts'
(NAME = 'AdventureWorks.Production.GetProducts'),
DATABASE = 'AdventureWorks',
WSDL = DEFAULT
)

Msg 7807, Level 16, State 1, Line 1
An error ('0x80070057') occurred while attempting to register the
endpoint 'AWproduction'

Kent Tegels
3/18/2006 2:59:34 AM

Hello Gouri,

[quoted text, click to view]

You wouldn't happen to also have IIS running on this machine, would you?
If so, set CLEAR_PORT to something other than 80. This might also happen
if you have already have a virtual directory named 'adventureworks'

Also, what edition of SQL are you using and on what OS and SP?

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels

Gouri
3/18/2006 9:25:02 PM

Hi

I tried changing create port other than 80 and there is no virtual directory
existing, it still gives the same error with Msg 7807, Level 16, State 1,
Line 1, ('0x80070007')
OS is Win2k3 server, with SP1

Gouri
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn