Re: GRANT CONNECT to group? - How?

Axel,

Since you created a SQL Server (non-domain) login, your application running
from the web service would need to make its connection as Login=PcUser,
Password=YourPassword. Once you are connected, you can make use of the
endpoint.

If the web service is running already under a domain account, e.g.
Domain\MyWebService, then you should be able to make a trusted connection
and (once you GRANT CONNECT ON ENDPOINT::Cockpit TO [Domain\MyWebService])
the account can use the endpoint.

From the BOL, talks about Endpoint "Authentication and Security"
http://msdn.microsoft.com/en-us/library/ms345123.aspx
And this whitepaper also talks some about endpoint security.
http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

A couple of disclaimers: (1) I don't use endpoints other than the standard
ones, (2) endpoints are mentioned as deprecated in the SQL Server 2008
documentation.

RLF

"Axel Dahmen" <keentoknow@xxxxxxxxxxxxxxxx> wrote in message
news:863870CF-3466-43A0-82D5-1FC1F2AD8D62@xxxxxxxxxxxxxxxx
....
But...

I've set up a SQL Server login which I've granted execution rights to:

CREATE LOGIN PcUser ...
CREATE ENDPOINT Cockpit ...
GRANT CONNECT ON ENDPOINT::Cockpit TO PcUser

How would I now connect to the web service? How would I provide user
credentials?

Your help is very appreciated!

Best regards,
Axel Dahmen


.