Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Endpoints Expand / Collapse
Author
Message
Posted Thursday, April 11, 2013 8:33 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:56 AM
Points: 31,376, Visits: 15,845
Comments posted to this topic are about the item Endpoints






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1441537
Posted Friday, April 12, 2013 12:00 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 26, 2014 3:04 AM
Points: 1,972, Visits: 2,410
AS per the explanation:
"You can create three payload types in SQL Server 2012: TCP, Service Broker, and Database Mirroring endpoints. SOAP endpoints were removed in SQL Server 2012."

When I refer to this link:
http://msdn.microsoft.com/en-in/library/ms162560.aspx

I found that SOAP is still in list of payload types.



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1441581
Posted Friday, April 12, 2013 2:03 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, December 25, 2014 4:42 AM
Points: 3,373, Visits: 1,336
Shouldn't TCP in the answers be TSQL?
TCP is one of the two protocols that can be used, TSQL is a payload type.
Post #1441599
Posted Friday, April 12, 2013 2:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, January 3, 2014 3:18 AM
Points: 341, Visits: 186
kapil_kk (4/12/2013)
AS per the explanation:
"You can create three payload types in SQL Server 2012: TCP, Service Broker, and Database Mirroring endpoints. SOAP endpoints were removed in SQL Server 2012."

When I refer to this link:
http://msdn.microsoft.com/en-in/library/ms162560.aspx

I found that SOAP is still in list of payload types.



I agree I looked this up in BOL and found the same quote!!

Steve
Post #1441602
Posted Friday, April 12, 2013 3:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 22, 2014 9:20 AM
Points: 2,634, Visits: 2,472
sfayer (4/12/2013)
kapil_kk (4/12/2013)
AS per the explanation:
"You can create three payload types in SQL Server 2012: TCP, Service Broker, and Database Mirroring endpoints. SOAP endpoints were removed in SQL Server 2012."

When I refer to this link:
http://msdn.microsoft.com/en-in/library/ms162560.aspx

I found that SOAP is still in list of payload types.



I agree I looked this up in BOL and found the same quote!!

Steve

+1
But, starting from SQL Server 2008: Native XML Web Services (SOAP/HTTP endpoints) is deprecated. For more information, see Native XML Web Services: Deprecated in SQL Server 2008.
So, in 2012 is removed!
Post #1441623
Posted Friday, April 12, 2013 5:00 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 10:30 AM
Points: 4,123, Visits: 761
Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.


Post #1441637
Posted Friday, April 12, 2013 5:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:32 PM
Points: 6,159, Visits: 8,420
PurpleLady (4/12/2013)
Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.

No, it is not. SOAP was deprecated in SQL Server 2008, and removed in SQL Server 2012. That may be unusual (normally deprecated features are kept around for a while), but it is true. The documentation Steve links to in the explanation is correct, the conflicting information found by Kapil_kk is incorrect.

Proof:
SELECT @@VERSION;
-- Code copied from SQL 2008 version of Books Online
CREATE ENDPOINT sql_endpoint
STATE = STARTED
AS HTTP(
PATH = '/sql',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'SERVER'
)
FOR SOAP (
WEBMETHOD 'GetSqlInfo'
(name='master.dbo.xp_msver',
SCHEMA=STANDARD ),
WEBMETHOD 'DayAsNumber'
(name='master.sys.fn_MSdayasnumber'),
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = 'master',
NAMESPACE = 'http://tempUri.org/'
);
GO

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


Msg 7878, Level 16, State 1, Line 2
This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1441648
Posted Friday, April 12, 2013 5:59 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 1:45 PM
Points: 1,494, Visits: 1,774
From http://technet.microsoft.com/en-us/library/ms181591.aspx :

"The payload can be one of several supported types: Transact-SQL, service broker, database mirroring.

Note
Native XML Web Services (SOAP/HTTP endpoints) was removed in SQL Server 2012"

Post #1441651
Posted Friday, April 12, 2013 7:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 26, 2014 3:04 AM
Points: 1,972, Visits: 2,410
Hugo Kornelis (4/12/2013)
PurpleLady (4/12/2013)
Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.

No, it is not. SOAP was deprecated in SQL Server 2008, and removed in SQL Server 2012. That may be unusual (normally deprecated features are kept around for a while), but it is true. The documentation Steve links to in the explanation is correct, the conflicting information found by Kapil_kk is incorrect.

Proof:
SELECT @@VERSION;
-- Code copied from SQL 2008 version of Books Online
CREATE ENDPOINT sql_endpoint
STATE = STARTED
AS HTTP(
PATH = '/sql',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'SERVER'
)
FOR SOAP (
WEBMETHOD 'GetSqlInfo'
(name='master.dbo.xp_msver',
SCHEMA=STANDARD ),
WEBMETHOD 'DayAsNumber'
(name='master.sys.fn_MSdayasnumber'),
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = 'master',
NAMESPACE = 'http://tempUri.org/'
);
GO

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


Msg 7878, Level 16, State 1, Line 2
This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.

Actually I was not aware of the ENDPOINT thing so first I search on BOL and find that SOAP is still in 2012 so I post that link...



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1441677
Posted Friday, April 12, 2013 7:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 26, 2014 9:09 AM
Points: 1,425, Visits: 2,449
Mighty (4/12/2013)
Shouldn't TCP in the answers be TSQL?
TCP is one of the two protocols that can be used, TSQL is a payload type.


I was wondering this myself. The documentation for creating an endpoint lists TCP as the only protocol you can select. The possible endpoints are listed as { TSQL | SERVICE_BROKER | DATABASE_MIRRORING }.

http://technet.microsoft.com/en-us/library/ms181591.aspx
Post #1441696
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse