Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- From: "Keith" <keith@xxxxxxx>
- Date: Wed, 22 Aug 2007 12:27:13 -0700
"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?
.
- Follow-Ups:
- References:
- SQL Express: is there a commandline way to set the default static port of a named instance?
- From: Keith
- Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- From: Rick Byham, \(MSFT\)
- Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- From: Keith
- SQL Express: is there a commandline way to set the default static port of a named instance?
- Prev by Date: Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- Next by Date: xp_cmdshell permission denied SQL 2005
- Previous by thread: Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- Next by thread: Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- Index(es):
Relevant Pages
|
|
