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:
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
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