Advertisement

09.24.2008 at 08:36AM PDT, ID: 23759102 | Points: 500
[x]
Attachment Details

INTEGRATED authentication not working for SQL endpoints

Asked by sqlconsumer in Web Services, Windows 2003 Server, SQL Server 2005

Hi,

I have recently develop a ASP.NET applications on my XP server and everything is working most excellently. The ASP.NET app consumes SQL Endpoints and displays data, very simple.

Now I am trying to do the same exercise on my Windows server 2003 machine and I can not get the SQL endpoints to work. If I try to open the ?WSDL page for the SQL endpoint I'm asked for authentication, so I supply my user name with domain name and password. I'm asked three times and then nothing further happens.

Attached is my SQL End point which I'm sure is fine....

Do I have a problem with my IIS or Internet explorer configuration?

Thanks,

sqlconsumerStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:

EXEC sp_reserve_http_namespace N'http://DATSQLPROD1:90/CapturedFiles' 
GO
--DROP ENDPOINT sql_BtrieveStandingData
CREATE ENDPOINT sql_BtrieveStandingData
STATE = STARTED
AS
HTTP
(
	PATH = '/CapturedFiles',
	AUTHENTICATION = ( INTEGRATED ),
	PORTS = ( CLEAR ),
	CLEAR_PORT = 90,
	SITE = 'DATSQLPROD1'
)
FOR SOAP
(
	WEBMETHOD 'GetBuildDataSetInfo'
		(name='BtrieveStandingData.dbo.isp_GetBuildDataSetInfo',
		schema=STANDARD ),
 
	WEBMETHOD 'GetCapturedFiles'
		(name='BtrieveStandingData.dbo.isp_GetCapturedFiles',
		schema=STANDARD ),
 
	WEBMETHOD 'GetCapturedExceptionFiles'
		(name='BtrieveStandingData.dbo.isp_GetCapturedExceptionFiles',
		schema=STANDARD ),
 
	WEBMETHOD 'GetBuild'
		(name='BtrieveStandingData.dbo.isp_GetBuild',
		schema=STANDARD ),
 
	WEBMETHOD 'ExportDefaultAccounts'
		(name='BtrieveStandingData.dbo.isp_ExportDefaultAccounts',
		schema=STANDARD ),
 
	WEBMETHOD 'ExportStandingData'
		(name='BtrieveStandingData.dbo.isp_ExportStandingData',
		schema=STANDARD ),
 
	WEBMETHOD 'GetMaxBuild'
		(name='BtrieveStandingData.dbo.ifn_GetMaxBuild',
		schema=STANDARD ),
 
	WEBMETHOD 'GetCurrentConfiguration'
		(name='BtrieveStandingData.dbo.isp_GetVariables',
		schema=STANDARD ),
 
	WEBMETHOD 'ConvertData'
		(name='BtrieveStandingData.dbo.isp_ConvertData',
		schema=STANDARD ),
 
	WEBMETHOD 'UpdateVariable'
		(name='BtrieveStandingData.dbo.isp_ChangeVariable',
		schema=STANDARD ),
 
	WSDL = DEFAULT,
	DATABASE = 'BtrieveStandingData',
	NAMESPACE = 'http://BtrieveStandingData/'
)
--ALTER ENDPOINT sql_ProductCatalog STATE = STOPPED
 
SELECT * FROM sys.endpoints
SELECT * FROM sys.http_endpoints
SELECT * FROM sys.endpoint_webmethods
[+][-]09.27.2008 at 08:55PM PDT, ID: 22589718

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 01:37AM PDT, ID: 22676507

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628