Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Using SQL Server 2005's New Web Services Capability : Page 2

Microsoft SQL Server 2005 lets you expose specific stored procedures, user-defined functions, and SQL queries for use via HTTP or secure HTTP, making SQL Server databases more accessible to non-Windows clients, and improving security by eliminating the need to open TCP ports for SQL Server.


advertisement
Syntax for Creating Endpoints
The full SQL syntax for creating an endpoint is:

CREATE ENDPOINT endPointName [ AUTHORIZATION login ] STATE = { STARTED | STOPPED | DISABLED } AS { HTTP | TCP } ( <protocol_specific_arguments>) FOR { SOAP | TSQL | SERVICE_BROKER | DATABASE_MIRRORING } ( <language_specific_arguments>) <AS HTTP_protocol_specific_arguments> ::= AS HTTP ( PATH = 'url' , AUTHENTICATION =( { BASIC | DIGEST | INTEGRATED | NTLM | KERBEROS } [ ,...n ] ) , PORTS = ( { CLEAR | SSL} [ ,... n ] ) [ SITE = {'*' | '+' | 'webSite' },] [, CLEAR_PORT = clearPort ] [, SSL_PORT = SSLPort ] [, AUTH_REALM = { 'realm' | NONE } ] [, DEFAULT_LOGON_DOMAIN = { 'domain' | NONE } ] [, RESTRICT_IP = { NONE | ALL } ] [, COMPRESSION = { ENABLED | DISABLED } ] [, EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> } [ ,...n ] ) ) <AS TCP_protocol_specific_arguments> ::=AS TCP ( LISTENER_PORT = listenerPort [ , LISTENER_IP = ALL | (<4-part-ip> | <ip_address_v6> ) ] [ , RESTRICT_IP = ALL | NONE ] [ , EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> } [ ,...n ] ) ] <FOR SOAP_language_specific_arguments> ::= FOR SOAP( [ { WEBMETHOD [ 'namespace' .] 'method_alias' ( NAME = 'database.owner.name' [ , SCHEMA = { NONE | STANDARD | DEFAULT } ] [ , FORMAT = { ALL_RESULTS | ROWSETS_ONLY } ]) } [ ,...n ] ] [ BATCHES = { ENABLED | DISABLED } ] [ , WSDL = { NONE | DEFAULT | 'sp_name' } ] [ , SESSIONS = { ENABLED | DISABLED } ] [ , LOGIN_TYPE = { MIXED | WINDOWS } ] [ , SESSION_TIMEOUT = timeoutInterval | NEVER ] [ , DATABASE = { 'database_name' | DEFAULT } [ , NAMESPACE = { 'namespace' | DEFAULT } ] [ , SCHEMA = { NONE | STANDARD } ] [ , CHARACTER_SET = { SQL | XML }] [ , MAX_SOAP_HEADERS_SIZE = { int | DEFAULT }]) <FOR SERVICE_BROKER_language_specific_arguments> ::= FOR SERVICE_BROKER ( [ AUTHENTICATION = { WINDOWS* [ { NTLM | KERBEROS | NEGOTIATE* } ] | CERTIFICATE certificateName | WINDOWS[ {NTLM|KERBEROS|NEGOTIATE* } ] CERTIFICATE certificateName | CERTIFICATE certificateName WINDOWS[ {NTLM|KERBEROS|NEGOTIATE* } ]}] [ , ENCRYPTION = {DISABLED|SUPPORTED|REQUIRED*} [ALGORITHM {RC4*|AES|AES RC4|RC4 AES}]]} [ , MESSAGE_FORWARDING = { ENABLED | DISABLED* } ] [ , MESSAGE_FORWARD_SIZE = forwardSize ])

After creating an endpoint, you can alter (ALTER ENDPOINT) or drop it (DROP ENDPOINT), as well as grant permissions for it. This article concentrates on SOAP and HTTP, and ignores the options to use TCP, to provide service brokering, and to provide database mirroring.



Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap