HTTP EndPoint Security Problems.

Question

I am having trouble getting access to HTTP Endpoints working correctly.

I have a user sqluser on the machine that I granted access to as follows:

grant connect on endpoint:: Test10 to [SQLBETA\sqluser]

In my web service client call, I do the following:

t.Credentials = new System.Net.NetworkCredential("sqluser", "password", "SQLBETA");

But, when I make the call to a method in the web service (HTTP Endpoint), I am getting the following error:

Client, LoginFailure, AccessDenied

This error is returned in the soap:fault portion of the call.  I also get this call if I try to use wsdl.exe from the client PC to generate the wsdl even when using the /user, /password, and /domain items.

Can someone please let me know how to connect to an HTTP Endpoint when not logged on as  valid user and having to connect as a user?

Thanks,

Ashton Hobbs

Answer 1

Is there a valid SQL user for this account [SQLBETA\sqluser] in SQLServer ?  Or are you asking how to do sql auth against an HTTP endpoint ?  SQLServer BOL has a sample of how to add WSSecurity headers to your C# client.




Thanks
Srik