Sunday, March 25, 2012

Cannot register 6.5 server

Hi,
I'm using my computer (Windows XP Professional) to
administrate remote sql servers 6.5, 7.0, and 2000. I can
successfully register all servers except one, sql server
6.5. Difference between this one and the other 6.5
servers is that it uses Named Pipes server library, and
the other ones use TCP/IP. I created an alias for this
specific server (with named pipes), but still, I get an
error message: "A connection could not be established to
<server name>. [DB Library] Unable to connect: SQL Server
is unavailable or does not exist."
At the same time I can ping the server... I can also
register this server from the other, Windows 2000 PC...
Any ideas?
Thanks,
BakiCan you map a drive to the \\<SQL Server Machine>\IPC$ share from the
WIndows XP machine. Named pipes requires a trusted connection and you may
not be able to establish that from the XP machine. If you cannot map a
drive then you will not be able to use named pipes. You may have to switch
to TCP/IP
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
Are you saying that I cannot connect to this server using
Named Pipes if I'm not logged on to the same domain as
sql server is?
Thanks,
Baki
quote:

>--Original Message--
>Can you map a drive to the \\<SQL Server Machine>\IPC$

share from the
quote:

>WIndows XP machine. Named pipes requires a trusted

connection and you may
quote:

>not be able to establish that from the XP machine. If

you cannot map a
quote:

>drive then you will not be able to use named pipes. You

may have to switch
quote:

>to TCP/IP
>Rand
>This posting is provided "as is" with no warranties and

confers no rights.
quote:

>.
>
|||You have to access to the machine at the OS level. Named pipes requries
that you have access to the machine. You do not have to be in the same
domain, but there does need to be some type of trust to use named pipes. If
your NT account has an account on the SQL Server machine you should be able
to use named pipes.
Either way named pipes requires a trust. This is documented in Books on
Line.
Rand
Thsi posting is proved "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment