Trying to get the right registry key through sql script to change listen port

#1

Hi,

I want the change the SQL listen port of a named 2005 sql instance.

Is there a way I can run an sql query against the named instance which
gives me back which registry setting I need to use.

so MSSQL.1 MSSQL.2 or MSSQL.3

Or is there another way I can set the listenport through script or
vbscript for only a specific named instance so if there are other sql
server instances running they don't get affected.

Thanks Bob

#2

On 8 mrt, 13:50, "BF" <b... (AT) faessen (DOT) net> wrote:

Quote:

Hi,

I want the change the SQL listen port of a named 2005 sql instance.

Is there a way I can run an sql query against the named instance which
gives me back which registry setting I need to use.

so MSSQL.1 MSSQL.2 or MSSQL.3

Or is there another way I can set the listenport through script or
vbscript for only a specific named instance so if there are other sql
server instances running they don't get affected.

Thanks Bob

Just found it myself:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL

There are all named instances displayed and so can be read.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Trying to get the right registry key through sql script to change listen port

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Trying to get the right registry key through sql script to change listen port - 03-08-2007 , 06:50 AM

Re: Trying to get the right registry key through sql script to change listen port - 03-08-2007 , 06:55 AM