Endpoint problem - SQL Server Forums

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 2008 Forums

SQL Server Administration (2008)

Endpoint problem

Author

Topic

chris_cs
Posting Yak Master

223 Posts

Posted - 2011-08-25 : 04:53:57

We've created a SOAP endpoint for one of our applications but keep getting the following error:

HTTP authentication failed. [CLIENT: 10.128.68.100]
EventID: 26026

The Endpoint is as follows:


CREATE ENDPOINT [igloo_endpoint] 
	AUTHORIZATION [Domain\user]
	STATE=STARTED
	AS HTTP (PATH=N'/igloo', PORTS = (CLEAR), AUTHENTICATION = (NTLM, KERBEROS, INTEGRATED), SITE=N'uk-ls-devdb-04', CLEAR_PORT = 90, COMPRESSION=DISABLED)
	FOR SOAP (
WEBMETHOD 'LoadRiskTemplates'( NAME=N'[DCC_ad].[etl].[LoadRiskTemplates]'
, SCHEMA=STANDARD
, FORMAT=ALL_RESULTS), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'DCC_ad', NAMESPACE=N'http://server:90/igloo', SCHEMA=STANDARD, CHARACTER_SET=XML)
GO

Has anyone come across this issue before?

Junior DBA learning the ropes

chris_cs
Posting Yak Master

223 Posts

Posted - 2011-08-25 : 06:32:42

Just to add. If we try this all on one local machine we are able to connect with no issues.

Junior DBA learning the ropes

NeilG
Aged Yak Warrior

530 Posts

Posted - 2011-08-25 : 09:13:44

Just a guess as I don't use endpoints often, but it looks like a security problem, have you granted CONNECT to the relevant user

chris_cs
Posting Yak Master

223 Posts

Posted - 2011-08-25 : 09:38:07

I had already tried that but I just tried granting connect to Public to rule this out.

It turns out it doesn't work when everything is on the local machine. I just want to determine if this is a SQL Server issue or a Windows issue.

Junior DBA learning the ropes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources