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

I wasn't aware that there was a restriction on CREATE ENDPOINT for SQL Server 2005 Express. I'll work on confirming that and adding the restriction to the documentation. That won't help you much though.
I'm surprised that the registry hack didn't work. We don't support people making direct changes to the registry and I haven't tried it, so I can't offer advice on that.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Keith" <keith@xxxxxxx> wrote in message news:eSpW4bp5HHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
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: 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?
    ... The BOL does not say that CREATE ENDPOINT is for SQL Server 2005 only (vs. ... Configuration Manager?Does this turn off dynamic ports as well? ...
    (microsoft.public.sqlserver.security)
  • 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)