Network Connects to Wrong SQL Instance

I have a server running Windows Server 2003 with two instances of SQL Server
2000 - a default instance and a named instance I shall call "INSTANCE_A".
Locally, SQL Server works correctly. Query Analyzer connects to both
instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
network, when I connect to default instance SERVER it actually connects to
SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is unchange
d
and works correctly. Port numbers are set correctly to 1433 and 1226
respectively. The server has been rebooted several times - no change. All
network clients are behaving the same - they all see SERVER\INSTANCE_A when
pointed to SERVER. Any ideas on what's gone wrong?"Jonno" <Jonno@.discussions.microsoft.com> wrote in message
news:57B7981D-0750-43F9-8BB5-F39B4A581570@.microsoft.com...
>I have a server running Windows Server 2003 with two instances of SQL
>Server
> 2000 - a default instance and a named instance I shall call "INSTANCE_A".
> Locally, SQL Server works correctly. Query Analyzer connects to both
> instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the
> network, when I connect to default instance SERVER it actually connects to
> SERVER\INSTANCE_A. Over the network, access to SERVER\INSTANCE_A is
> unchanged
> and works correctly. Port numbers are set correctly to 1433 and 1226
> respectively. The server has been rebooted several times - no change. All
> network clients are behaving the same - they all see SERVER\INSTANCE_A
> when
> pointed to SERVER. Any ideas on what's gone wrong?
Validate that the remote clients are connecting over TCP/IP.
Validate the ports the instances are using by looking into the log file for
each intance.
David|||Thanks David
Both instances have TCP/IP only.
Log files show that both instances are listening on TCP, with default
instance listening on port 1433, and INSTANCE_A listening on port 1226.
Is it possible the publishing of the default instance has become corrupted?
I've tried re-registering from the client side, but the problem persists.
"David Browne" wrote:

> "Jonno" <Jonno@.discussions.microsoft.com> wrote in message
> news:57B7981D-0750-43F9-8BB5-F39B4A581570@.microsoft.com...
>
> Validate that the remote clients are connecting over TCP/IP.
> Validate the ports the instances are using by looking into the log file fo
r
> each intance.
>
> David
>
>

need ur help

hi all,
I was wondering how I can enforce some configurations to sql server
2000, like auditing failure logins for example, but without using the
enterprise manager.
I need to implement a tool that will set some configurations
automatically without human intervention, any idea how can i do
so''
thanx for time and helpQuick answer: You can do the configuration changes in Enterprise Manager
while being connected to the instance with SQL Profiler. That way you can
see what EM is doing on the DB and thereby you can reproduce that. But I'm
not sure if EM does everything by T-SQL or if it partly relies in DMO for
configuration. Question to the experts: In that case, would something show
up in the Profiler log?
Best regards
Nils Loeber
<Eng.Rana@.gmail.com> schrieb im Newsbeitrag
news:1154987176.155861.301430@.i42g2000cwa.googlegroups.com...
> hi all,
> I was wondering how I can enforce some configurations to sql server
> 2000, like auditing failure logins for example, but without using the
> enterprise manager.
> I need to implement a tool that will set some configurations
> automatically without human intervention, any idea how can i do
> so''
> thanx for time and help
>|||thanx for the gr8 help Nils.
i also found while searching the web, something called SQL-DMO, do u
think this may help or no
thanx again
[vbcol=seagreen]
>Nils Loeber wrote:
> Quick answer: You can do the configuration changes in Enterprise Manager
> while being connected to the instance with SQL Profiler. That way you can
> see what EM is doing on the DB and thereby you can reproduce that. But I'm
> not sure if EM does everything by T-SQL or if it partly relies in DMO for
> configuration. Question to the experts: In that case, would something show
> up in the Profiler log?
>
> Best regards
> Nils Loeber
>
> <Eng.Rana@.gmail.com> schrieb im Newsbeitrag
> news:1154987176.155861.301430@.i42g2000cwa.googlegroups.com...|||SQL-DMO is what I was referring to as DMO. Depending on what you want to do,
and with which programming language you want to do it, DMO might also be
well suited for the task.
Best regards
Nils Loeber
<Eng.Rana@.gmail.com> schrieb im Newsbeitrag
news:1155025512.608190.203300@.75g2000cwc.googlegroups.com...
> thanx for the gr8 help Nils.
> i also found while searching the web, something called SQL-DMO, do u
> think this may help or no
> thanx again
>
>