CREATE ENDPOINT --- Authentication Question

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

Transact-SQL (2005)

CREATE ENDPOINT --- Authentication Question

Author

Topic

sqldba20
Posting Yak Master

183 Posts

Posted - 2010-06-24 : 11:55:23

Folks:

I am trying to create a web service using CREATE ENDPOINT. Question is for the Authentication how can I use SQL Authentication?

CREATE ENDPOINT GetEmployees
STATE = STARTED
AS HTTP
(
PATH = '/Employee',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'localhost'
)
FOR SOAP
(
WEBMETHOD 'EmployeeList'
(NAME='AdventureWorks.dbo.GetEmployees'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'AdventureWorks',
NAMESPACE = 'http://AdventureWorks/Employee'
)

Thanks!

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2010-06-25 : 10:13:27

If i remember correctly you create a certificate with authorization of a SQL Login. Then when creating the endpoint add AUTHENTICATION = [certificate name].

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources