Connecting to a second instance of SQL

There are no invalid characters. Even so I tried enclosing in square brackets
and still no joy.
Its a puzzle !
Si
"Arnie Rowland" wrote:

> Does the Instance Name contain any invalid character, such as '-'?
> Try enclosing the instance name in square brackets, e.g.,
> [MyServer\MyInstance].
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:A5D1AFBD-54F6-4600-A7EA-215AEFD7A1C6@.microsoft.com...
>
>
Is UDP 1434 open between the SQL Server you are registering
on and the named instance you are trying to register? That
could be what's causing your problems.
You could try an alias and see if that works -
On the SQL Server box where you are trying to register the
named instance, use the Client Network Utility to create an
alias to the named instance and specify the port number
(check the listening port on the named instance).
In that scenario with the alias, you are specifying the port
so you would bypass the SQL Server Resolution Service and
going through UDP 1434.
-Sue
On Mon, 30 Oct 2006 01:20:02 -0800, Simon
<Simon@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>There are no invalid characters. Even so I tried enclosing in square brackets
>and still no joy.
>Its a puzzle !
>Si
>"Arnie Rowland" wrote:

Connecting on the Server

Hi,
I've SQL 2000 Server installed in a Windows 2000 Server.
On the Server When I try to connect to the instance it
gives me the error "invalid identifier". I've tried to
reconfigure the connection but it never works.
On the WorkStations where I've installed the client tools
i can connect by the entreprise manager with no problem.
Can anyone give some clues why this appends!
Thanks in advance.What is the EXACT error you get and what are you doing when you get it
(what tool, what connection parameters, etc.)? What version of MDAC is on
the client machines (note that older versions of cannot connect to named
instances without a workaround).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Connecting on the Server

Hi,
I've SQL 2000 Server installed in a Windows 2000 Server.
On the Server When I try to connect to the instance it
gives me the error "invalid identifier". I've tried to
reconfigure the connection but it never works.
On the WorkStations where I've installed the client tools
i can connect by the entreprise manager with no problem.
Can anyone give some clues why this appends!
Thanks in advance.
What is the EXACT error you get and what are you doing when you get it
(what tool, what connection parameters, etc.)? What version of MDAC is on
the client machines (note that older versions of cannot connect to named
instances without a workaround).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.