Problem in creating endpoint

Hello Everybody,

I dont know whether this is right forum to post these type of query or not. but please help me in solving this problem.

I am creating Endpoint in sql server 2005.

but in very first line its giving error.

plz let me know whats wrong with this code.

USE [Northwind]

GO

CREATE ENDPOINT customer_endpoint

STATE=STARTED

AS HTTP (

PATH='/sql',

AUTHENTICATION= (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP (

WEBMETHOD 'http://tempUri.org'.'GetCustomerInfo'

(

NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,

schema=STANDARD

),

WSDL=DEFAULT,

BATCHES=ENABLED,

DATABASE='Northwind'

)

GO

and the Error i am getting is:

Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'ENDPOINT'.

Please Help me ASAP.

Regards,

Vineet

I just did a cut and paste of the DDL and it worked for me. I ran it against SQL2K5 RTM build. The Northwind database is not available by default with SQL2K5, even then it should merely fail by saying "Database not found".

Problem in creating endpoint

Hello Everybody,

I dont know whether this is right forum to post these type of query or not. but please help me in solving this problem.

I am creating Endpoint in sql server 2005.

but in very first line its giving error.

plz let me know whats wrong with this code.

USE [Northwind]

GO

CREATE ENDPOINT customer_endpoint

STATE=STARTED

AS HTTP (

PATH='/sql',

AUTHENTICATION= (INTEGRATED),

PORTS = (CLEAR),

SITE = '*'

)

FOR SOAP (

WEBMETHOD 'http://tempUri.org'.'GetCustomerInfo'

(

NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,

schema=STANDARD

),

WSDL=DEFAULT,

BATCHES=ENABLED,

DATABASE='Northwind'

)

GO

and the Error i am getting is:

Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'ENDPOINT'.

Please Help me ASAP.

Regards,

Vineet

I just did a cut and paste of the DDL and it worked for me. I ran it against SQL2K5 RTM build. The Northwind database is not available by default with SQL2K5, even then it should merely fail by saying "Database not found".

sql

Problem consuming SQL Server SSL Endpoint

I try to consume a SSL Endpoint that is locate in localhost, but i get the follow error msg:

The underlying connection was closed: An unexpected error occurred on a receive.

m_safeCertContext is an invalid handle.

I do not know what gone wrong with my VS2005, i tried in IE with https://localhost/test?wsdl, and it was okay and display the wsdl document successfully. Beside i also tried with CLEAR port, everything is ok and i managed to consume the web service too.

any suggestion would be appreciated. Thank q

You might have more luck asking in the Visual Studio Forum for this. Seems to be a VS issue. However, looking at some of the forums, I was able to find http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=232760&SiteID=1.

HTH

Riyaz

|||

I would also recommend specifying the machine name in the URL in your VS2005 application. I would imagine that the SSL certificate installed on the SQL Server machine is issued to the machine name and not "localhost". One possibility is that since you specified "localhost" in the URL, Visual Studio may be trying to validate the SSL certificate info (machine name) against "localhost" which do not match; thus causing the error.

Jimmy