in different subnet.
I installed the 3 servers on the same network and registered the
servers and configured for replication on LAN .Because the
registration was very important for replication. there was no
problem.everthing all right.then I moved the server different city
and
again I configured TCP/IP acording to new networks.but MS sql
servers didn't connect each other.but I can ping the servers.
also there is windows 2000 advanced server on servers as a operation
system.
could you help me?
--- In [EMAIL PROTECTED], Justin Greene <[EMAIL PROTECTED]> wrote:
>
> The problem is probably with using named pipes for the connection.
NT wants to authenticate the user before seeing the machine even
though SQL is using standard security. First, try using TCP/IP by
setting the client to TCP/IP in client administrator. 2nd, make sure
the machine names resolve to IP addresses in your LMHosts file if the
machines are not on the same physical subnet. This shouls solve the
problem. Also, when connecting from enterprise manager, make sure
you do not check display server status when registering the machine,
because this uses windows networking and if the PW is not correct
then if will a security failure event in the event log everytime it
tries and fails. Another workaround in this situation is to connect
to the remote machines with NET USE \\machine /user:username password
using the correct username and password for each machine before
trying to use SQLEM. This will establish valid windows IPC$ sessions
which is the layer before trying to connect with SQL. Btw: if you
are on windows 95, this can be difficult because you do not have the
option to connect with a different username and password.
>
> Hope this helps.
>
> -Justin
>
> At 04:30 PM 10/29/98 -0500, you wrote:
> >Hi.
> >
> >I'm ready to kill one of our SQL Servers!
> >We have 3 SQL Servers running on 3 physical machines with 3
different
> >domains, and 3 different NT admin passwords.
> >From my workstation, I can see 2 of the three servers in SQL EM.
The third
> >server "doesn't exist" unless my workstation NT admin password is
the same
> >as the server's admin password.
> >
> >I have all of the servers set to use standard security.
> >I have checked everything I can think of, and still nothing helps
unless
> >the NT passwords are the same.
> >Can anyone help me out???
> >
> >btw: it's SQL Server 6.5
> >
> >- Jonathan
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
