Sunday, February 26, 2012

Enterprise Manager connect issue

On some of my servers under the same workgroup as the SQL
server, the Enterprise Manager can connect to the SQL
using the name of the SQL server, but some of them can't
(can only use IP address of the SQL server). Why is that?
Our application running on those clients are connecting to
the SQL that way, so that some of the clients failed to
connect.
I'm using SQL Server 2k sp3 on W2k.
my client server/pc are installed with SQL 2k client, and
sp3.
your urgent reply would be greatly appreciated.
Thanks and regards,
EricSeems like a DNS name resolution problem. You should talk to the networking people. One thing to
check is the netlib selected in the Client Network Utility on the client machines, of they are the
same on all, for instance.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Eric Lau" <ericlau120@.hotmail.com> wrote in message news:09c401c378fc$26780f40$a301280a@.phx.gbl...
> On some of my servers under the same workgroup as the SQL
> server, the Enterprise Manager can connect to the SQL
> using the name of the SQL server, but some of them can't
> (can only use IP address of the SQL server). Why is that?
> Our application running on those clients are connecting to
> the SQL that way, so that some of the clients failed to
> connect.
> I'm using SQL Server 2k sp3 on W2k.
> my client server/pc are installed with SQL 2k client, and
> sp3.
> your urgent reply would be greatly appreciated.
> Thanks and regards,
> Eric

No comments:

Post a Comment