Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Endpoint with SOAP

Status
Not open for further replies.

byurow

Programmer
Jul 7, 2002
111
US
Hey everyone. I have 2 systems, a development server (SQL Server 9.0.1399) and a Production server (SQL Server 9.0.3042).

I have created an endpoint on each server where the only difference is the server it is pointing to. The code is as follows:

Code:
Create Endpoint Birthday
State = Started
As HTTP
	(
		Site = 'SDGDB03',
		Path = '/Birthday',
		Authentication = ( Integrated ),
		Ports = ( CLEAR, SSL )
	)
For SOAP
	(
		WebMethod 'GetV_Birthdays_Month_Display_SG'
			(
				Name = 'C2KM.dbo.V_Birthdays_Month_Display_SG',
				Schema = Standard,
				FORMAT = ROWSETS_ONLY 
			),
		WSDL = Default,
		Batches = Enabled,
		Database = 'C2KM'
	)

The endpoint works great on the development server but promts me for a logon for the production server. Even after logging in, I do not get results returned on the prod server. Both servers are set for Windows Authentication and both have the same permissions set up. Note that the dev server is running RTM and the production server has SP2 installed. Does anyone know why I would be having this issue and how to address it?

Thank you!

Brenda
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top