Advertisement

06.17.2008 at 02:23AM PDT, ID: 23490863
[x]
Attachment Details

EXPOSE HTTP ENDPOINTS

Asked by sqlconsumer in SQL Server 2005, Microsoft IIS Web Server, SOAP

Hi,

I'm trying to put together a very simple wen app that uses SQL server 2005 endpoints. I'm following an example by Peter Debetta. He makes it sound so easy ???

Below is the code I use to create my endpoint. I check sys.http_endpoints and all is fine.

My Machine Name is p004795
If I then type http://p004795/awproducts?wsdl as suggested all I get is the page could not be displayed banner.

Is there something I've missed?Start 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:
CREATE ENDPOINT SQLEP_AWProducts
	STATE = STOPPED
AS HTTP
(
	PATH = '/AWproducts',
	AUTHENTICATION = (INTEGRATED),
	PORTS = ( CLEAR ),
	CLEAR_PORT = 90,
	SITE = 'p004795'
)
FOR SOAP
(
	WEBMETHOD 'prProductList'
		(name='AdventureWorks.dbo.prProductList',
		schema=STANDARD),
	WEBMETHOD 'prProductStockInfo'
		(name='AdventureWorks.dbo.prProductStockInfo',
		schema=STANDARD),
	WEBMETHOD 'fnProductPhoto'
		(name='AdventureWorks.dbo.fnProductPhoto'),
	BATCHES = ENABLED,
	WSDL = DEFAULT,
	DATABASE = 'AdventureWorks',
	NAMESPACE = 'http://Adventure-Works/Products'
)
GO
ALTER ENDPOINT SQLEP_AWProducts STATE = STARTED
[+][-]06.18.2008 at 03:06AM PDT, ID: 21811383

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Microsoft IIS Web Server, SOAP
Sign Up Now!
Solution Provided By: sqlconsumer
Participating Experts: 0
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628