Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Endpoint

Author  Topic 

nkpriya
Starting Member

34 Posts

Posted - 2011-03-23 : 14:00:24
Hi, I am new to SQL Server Endpoint.

I am trying to create endpoint using below script and it gives error message: Msg 6004, Level 16, State 12, Line 2
User does not have permission to perform this action.
When I try to ask Admin, they are saying I have full rights. What could be the reason? Please help!

use ITDB
go

CREATE ENDPOINT GetCount
STATE = STARTED
AS HTTP
(
PATH = '/Employee',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
CLEAR_PORT = 8088,
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'GetCount'
(NAME='ITdb.dbo.GetCount'),
WSDL = DEFAULT,
DATABASE = 'ITDB',
NAMESPACE = DEFAULT
)
go

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-23 : 14:03:26
Well clearly the admin is wrong. Put simply, you do not have permissions to run that command. Contact your admin again.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -