Wednesday, March 7, 2012

Can't create http endpoint - don't have permission

I am trying to install an application that have following code in SQL Server
installation script
CREATE ENDPOINT RequirementsAuthoring
STATE = STARTED
AS HTTP (
SITE = '*',
PATH = '/sql/RequirementsAuthoring',
AUTHENTICATION = (INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP (...
I get following error
The user 'SIATA\Shimon' does not have permission to register endpoint
'RequirementsAuthoring' on the specified URL. Please ensure the URL refers
to a namespace that is reserved for listening by SQL.
I logged as computer admin on Windows XP with IIS installed.
I tried to run
sp_reserve_http_namespace N'http://Siata:80/sql/RequirementsAuthoring'
That runs just fine. But I still get the same error when I run first script.
Any suggestions?
Thanks,
ShimonHello Shimon,
Although you are logged into Windows as an Admin, that doesn't automatically
make you a member of SA role. Can you do this:
use master
go
grant create endpoint to [your-domain\your-account]
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Thanks for fast replay.
No, I can't do it I got this
Cannot find the login 'Siata\Shimon', because it does not exist or you do
not have permission.
I don't get this but. When I am using Management Studio I get this ID as
logged in ID.
I am probably the member of BUILDIN/Administrators
Any solution?
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>|||Well I created the log in and run your script. It worked. I still have the
same error with original script.
How can I confirm that the namespace 'is reserved for listening by SQL.'
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>

No comments:

Post a Comment