SQL Server Developer Center >
SQL Server Forums
>
SQL Server Data Access
>
cannot access wsdl from server
cannot access wsdl from server
- I have created a new endpoint with sql server 2005
select
* from sys.http_endpoints:
END_SQL5_AAG_INSERT 65555 1 1 HTTP 1 SOAP 0 STARTED 0 SBS-01 /Insert 0 0 1 443 0 1 0 0 0 0 NULL NULL 0
Create script:
CREATE
ENDPOINT END_SQL5_AAG_INSERT
STATE = STARTED
AS HTTP
(
PATH = '/Insert',
AUTHENTICATION = (BASIC),
PORTS = (SSL),
SSL_PORT=443,
SITE = 'SBS-01'
)
FOR SOAP
(
WEBMETHOD 'ServerInsert'
(NAME='AagSmp.dbo.Aag_Insert'),
BATCHES = DISABLED,
WSDL = DEFAULT,
LOGIN_TYPE = MIXED,
DATABASE = 'AagSmp',
NAMESPACE = 'http://AagSmp/Insert'
)
Everything seems to be oke, but no wsdl is created under http://sbs-01/insert?wsdl
Not on the server, but also not accessible on the client.
Can somebody help me
sql server 2005 standard edition 9.00.1406.00
windows 2003 Microsoft Windows NT 5.2 (3790)
All Replies
- You seem to have configured the endpoint to use SSL over HTTP.
Can you access https://sbs-01/insert?wsdl (note https, not http) - Hi Casey,
I tried the same on an testserver. And that works I can see the wsdl.
But this specific server doesn't let me see the wsdl even with the https.
Greetings Joep - Can you describe what you are seeing? Are there any error messages you can see in IE if you try to access that link? e.g. 404
- There is no specific error message,
Just get Internet explorer cannot display webpage.
Sorry that I didn't answer earlier.
I am only two days at the office (monday en friday)
Yesterday I installed sql server 2008 at home.
Hope I get the same error, so that I can experiment a little bit more at home. - What is the error in IE? (e.g., 404 Page Not Found, 503 Service Not Available, or...)
This post is provided 'as is' and confers no express or implied warranties or rights. - I,m not suer how I can display the real error in Internet Explorer.
I already unchecked "Friendly HTTP messages" but that doesn't change the message.
The next entry I see on displaying the real error lies within IIS.
I don't have IIS, is dat something that is necessary for creating an endpoint? - Please paste your browser contents back to the thread.
- Hi Casey,
This is the source of the "cannot display webpage"
https://cp872522-a/insert?wsdl
Beneath is an example of the page in firefox.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <link rel="stylesheet" type="text/css" href="ErrorPageTemplate.css" > <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>De webpagina kan niet worden weergegeven</title> <script src="errorPageStrings.js" language="javascript" type="text/javascript"> </script> <script src="httpErrorPagesScripts.js" language="javascript" type="text/javascript"> </script> </head> <body onLoad="javascript:initMoreInfo('infoBlockID');"> <table width="730" cellpadding="0" cellspacing="0" border="0"> <!-- Error title --> <tr> <td id="infoIconAlign" width="60" align="left" valign="top" rowspan="2"> <img src="noConnect.png" id="infoIcon" alt="Pictogram Info" width="48" height="48"> </td> <td id="mainTitleAlign" valign="middle" align="left" width="*"> <h1 id="mainTitle">De webpagina kan niet worden weergegeven</h1> </td> </tr> <tr> <!-- This row is for HTTP status code, as well as the divider--> <td id="errorCodeAlign" class="errorCodeAndDivider" align="right"> <div class="divider"></div> </td> </tr> <!-- What you can do --> <tr> <td> </td> <td id="whatToTryAlign" valign="top" align="left"> <h2 id="whatToTry">Mogelijke acties:</h2> </td> </tr> <!-- Check Connection --> <tr> <td > </td> <td id="checkConnectionAlign" align="left" valign="middle"> <h4> <table> <tr> <td valign="top"> </td> <td valign="middle"> <button onclick="javascript:diagnoseConnectionAndRefresh(); return false;" id="diagnose">Verbindingsproblemen vaststellen</button> </td> </tr> </table> </h4> </td> </tr> <!-- InfoBlock --> <tr> <td id="infoBlockAlign" align="right" valign="top"> </td> <td id="moreInformationAlign" align="left" valign="middle"> <h4> <table> <tr> <td valign="top"> <a href="#" onclick="javascript:expandCollapse('infoBlockID', true); return false;"><img src="down.png" id="infoBlockIDImage" border="0" class="actionIcon" alt="Meer informatie"></a> </td> <td valign="top"> <span id="moreInfoContainer"></span> <noscript><ID id="moreInformation">Meer informatie</ID></noscript> </td> </tr> </table> </h4> <div id="infoBlockID" class="infoBlock" style="display: none"> <p> <ID id="errorExpl1">Dit probleem kan verschillende oorzaken hebben, waaronder:</ID> <ul> <li id="errorExpl2">De internetverbinding is verbroken.</li> <li id="errorExpl3">De website is tijdelijk niet beschikbaar.</li> <li id="errorExpl4">De DNS-server is niet bereikbaar.</li> <li id="errorExpl5">De DNS-server heeft het domein van de website niet in een lijst.</li> <li id="errorExpl7">U hebt het adres mogelijk verkeerd getypt.</li> <li id="errorExpl6">Als dit een (beveiligd) HTTPS-adres is, klikt u op Extra en vervolgens op Internetopties en Geavanceerd. Zorg ervoor dat de SSL- en TLS-protocollen zijn ingeschakeld onder de beveiligingssectie. </li> </ul> </p> <p id="offlineUsers"><b>Voor offline gebruikers</b></p> <p id="viewSubscribedFeeds1"> U kunt nog steeds geabonneerde feeds en sommige onlangs bekeken webpagina's weergeven.<br/> Geabonneerde feeds weergeven <ol> <li id="viewSubscribedFeeds2">Klik op de knop Favorietencentrum <img src="favcenter.png" border="0">, daarna op Feeds en vervolgens op de feed die u wilt weergeven.</li> </ol> </p> <p id="viewRecentWebpages1">Onlangs bezochte webpagina's weergeven (werkt mogelijk niet voor alle pagina's) <ol> <li id="viewRecentWebpages2">Klik op Extra <img src="tools.png" border="0"> en vervolgens op Offline werken.</li> <li id="viewRecentWebpages3">Klik op de knop Favorietencentrum <img src="favcenter.png" border="0">, daarna op Geschiedenis en vervolgens op de webpagina die u wilt weergeven.</li> </ol> </p> </div> </td> </tr> </table> </body> </html>
The source of
Firefox:
PAGE LOAD ERROR
Data Transfer InterruptedThe connection to cp872522-a was interrupted while the page was loading.
The browser connected successfully, but the connection was interrupted while transferring information. Please try again.
* Are you unable to browse other sites? Check the computer's network connection.
* Still having trouble? Consult your network administrator or Internet provider for assistance.kind regards Joep
