Endpoint as a Web method - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Endpoint as a Web method

Author

Topic

juliancastiblancop
Starting Member

1 Post

Posted - 2008-04-19 : 16:25:15

Hello everybody,

I'm making the practice to create an Endpoint to publish a store procedure like a service web. Actually, The endpoing was create succesfully but, when i try to access it, thought my browser I have the next Error:
http://localhost:8088/sql?

Este error (HTTP 501 Sin implementar o HTTP 505 Versión no compatible) significa que, en este momento, el sitio web que está visitando no tiene la capacidad para mostrar la página web o no es compatible con la versión de HTTP usada para solicitar la página.

Para obtener más información sobre errores HTTP, consulte la Ayuda.

I'm using Sql Server 2005 develpment edition, over Windows Xp Professional. There is the code to create my endpoint:

CREATE ENDPOINT sql_endpoint
STATE=STARTED
AS HTTP(
PATH='/sql',
AUTHENTICATION=(INTEGRATED),
PORTS = ( CLEAR ),
CLEAR_PORT = 8088
--SITE='bogit001'
)
FOR SOAP (
WEBMETHOD 'BillofMaterials'
(name='AdventureWorks.dbo.uspGetBillOfMaterials'),
WSDL=DEFAULT,

SCHEMA=STANDARD,
DATABASE='AdventureWorks',
NAMESPACE='http://temUri.org/',
LOGIN_TYPE =WINDOWS

);
GO

EXEC sp_grantlogin @loginame = [BOGIT001\EL_JULY]

Thank you!!!

JULIAN CASTIBLANCO P
BOGOTA, COLOMBIA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources