Posted by BF on 03/08/07 12:55

On 8 mrt, 13:50, "BF" <b...@faessen.net> wrote:
> 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.

• Next in forum: Backup of a MS SQL 2000 DB
• Prev in forum: Trying to get the right registry key through sql script to change listen port
• Thread view: Re: Trying to get the right registry key through sql script to change listen port

[Reply to this message]