Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- From: "Keith" <keith@xxxxxxx>
- Date: Mon, 27 Aug 2007 13:22:50 -0700
Rick,
I appreciate your looking into this. I've continued to monkey around with
the registry approach but haven't had any luck yet.
I've also discovered issues with the following combination: SQL Server,
dynamic ports, firewall exception for sqlservr.exe, and a Virtual PC VM.
Because I haven't been able to programmatically set a static port for use
with the XP firewall, I've tried to use dynamic ports and added an app
exception as recommended by MSDN. the SQL Browser is also running and I
have a port exception (1434 TCP) for it as well. This setup works just fine
on a "real" machine, but on an XP SP2 virtual machine it doesn't. I can
locate the SQL instance using apps that use the SQL browser (like Management
studio) but I can never conect to it, even using other MS tools. I tried
changing the networking style of the VM (from bridged to NAT) and things
just got worse; SQL Browser-aware apps couldn't find the instance at all.
If I manually change to static ports (for both SQL and the firewall)
everything works as expected.
Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB11ABA0-1461-45C8-A7F7-1F860CEB09C7@xxxxxxxxxxxxxxxx
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.
.
- 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
- Re: 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: Keith
- Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- From: Rick Byham, \(MSFT\)
- SQL Express: is there a commandline way to set the default static port of a named instance?
- Prev by Date: "Severe" Linked Server Error
- Next by Date: Re: "Severe" Linked Server Error
- Previous by thread: Re: SQL Express: is there a commandline way to set the default static port of a named instance?
- Next by thread: Auditing password changes
- Index(es):
Relevant Pages
|
|
