Re: SQL Express: is there a commandline way to set the default static port of a named instance?

MS folks, do you have any suggestions or comments on the faliure I listed?
The BOL does not say that CREATE ENDPOINT is for SQL Server 2005 only (vs.
Express) and actually lists specific limitations for Express when using some
options, implying that there should be no other issues.

k

"Keith" <keith@xxxxxxx> wrote in message
news:O54bePP5HHA.484@xxxxxxxxxxxxxxxxxxxxxxx

"Keith" <keith@xxxxxxx> wrote in message
news:uFDtX5B5HHA.1484@xxxxxxxxxxxxxxxxxxxxxxx
Is using the method described, e.g.

USE master
GO
CREATE ENDPOINT [CustomConnection]
STATE = STARTED
AS TCP
(LISTENER_PORT = 1500, LISTENER_IP =ALL)
FOR TSQL() ;
GOequivalent to what happens when the default port is changed using the
Configuration Manager?Does this turn off dynamic ports as well? I
suppose this means that there is no wayto set this up using the installer
and cmd-line flags?k

OK. Tried this, and SQL Server said:

This "CREATE ENDPOINT" statement is not supported on this edition of SQL
Server."

This is against SQL Server 2005 Express, version 9.0.30.42.

Suggestions?




.

Relevant Pages

  • Re: HTTP endpoint WSDL fails to be created; wsdl does not exist (S
    ... IIS is not involved with nor is it needed for web services set up in SQL Server 2005. ... SQL Server works directly with http.sys to set up the endpoint. ... In general you probably wouldn't have IIS running on the server that was running SQL Server, ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Express: is there a commandline way to set the default static port of a named instance?
    ... "Keith" wrote in message ... The BOL does not say that CREATE ENDPOINT is for SQL Server 2005 only and actually lists specific limitations for Express when using some options, implying that there should be no other issues. ... GOequivalent to what happens when the default port is changed using the Configuration Manager?Does this turn off dynamic ports as well? ...
    (microsoft.public.sqlserver.security)
  • Re: CREATE ENDPOINT (Transact-SQL)
    ... URL Namespaces by Using Http.sys" to try to confirm the endpoint. ... WEBMETHOD 'DayAsNumber' ... It's an HTTP SOAP endpoint - HTTP is the ... the sample application available with SQL Server 2005. ...
    (microsoft.public.sqlserver.tools)
  • Re: GRANT CONNECT to group? - How?
    ... I've set up a SQL Server login which I've granted execution rights to: ... CREATE ENDPOINT Cockpit ... ... ENDPOINTs can only have rights granted or denied to server principals, ... That is why the database role cannot get rights. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Express: is there a commandline way to set the default static port of a named instance?
    ... GOequivalent to what happens when the default port is changed using the ... Configuration Manager?Does this turn off dynamic ports as well? ... This "CREATE ENDPOINT" statement is not supported on this edition of SQL ... This is against SQL Server 2005 Express, ...
    (microsoft.public.sqlserver.security)