Re: Sql server 2005 Endpoints? An error ('0x80070005') occurred while attempting to register the endpoint

Changed it to print suser_sname() so you can see it...

I setup a new virtual machine. This time it's Windows Server 2003 R2.
I verified that port 80 is free with netstat and here is your output.
Below all of that is the command I ran (moving to Northwind--but that's
immaterial, just wanted to keep you in the loop). Below THAT is the
stored procedure I'm using.

WIN2003R201\Administrator
Msg 1088, Level 15, State 103, Line 1
Cannot find the object "myEndPoint" because it does not exist or you do
not have permissions.
Msg 7850, Level 16, State 1, Line 1
The user 'WIN2003R201\Administrator' does not have permission to
register endpoint 'MyEndpoint' 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 'MyEndpoint'.


----------------------------------------------------------------------------------------
create endpoint MyEndpoint
state = started
as http
(
site='localhost',
path = '/sql/MyEndpoint',
authentication=(integrated),
ports = (clear)
)
for soap
(
webmethod 'GetEmployeeCount'
(
name = 'Northwind.dbo.GetEmployeeCount',
schema = standard
),
wsdl = default,
batches=enabled,
database = 'Northwind'
);

-----------------------------------------------------
create proc dbo.GetEmployeeCount
as
select EmployeeCount=count(*) from employee

.

Relevant Pages

  • Re: USB device class is CDC class - which device driver to write.
    ... Baud rate, etc. settings are sent via control requests to Endpoint 0" ... &Read on to the port handle with specific baudrate given by my ...
    (microsoft.public.development.device.drivers)
  • Re: ISDN phone lines
    ... > (An endpoint with both is smart enough to route incoming calls to POTS vs. ... > data port.) ... Do most of the ISDN phone "systems" have this ability? ...
    (sci.electronics.design)
  • Re: ISDN phone lines
    ... > (An endpoint with both is smart enough to route incoming calls to POTS vs. ... > data port.) ... Do most of the ISDN phone "systems" have this ability? ...
    (sci.electronics.basics)
  • Re: Flaw in RPC Endpoint Mapper - NT 4.0 FIX
    ... > Microsoft follows supposedly open DCE specifications for RPC and some ... > port for endpoint on the network interface. ... However I understand that Microsoft cannot ... we don't use the Endpoint mapper. ...
    (microsoft.public.security)
Loading