Tuesday, March 20, 2012

Can't see named instance

I have a client running NT 4.0 on one of his workstations. For some reason f
rom that machine he can't see the named Instance on the Server (MyServer\MyI
nstance) and therefore can't connect to the database. If I pull up a list of
available servers, the Ser
ver comes up on the list, just not the named instance. ANy ideas on what mig
ht be causing this?Old version of MDAC. Apply the latest supported MDAC for NT 4.0 and the
client can connect. Alternatively, you can create an alias on the client
that includes the port number and connect via it.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sean" <anonymous@.discussions.microsoft.com> wrote in message
news:2E49EBDD-9A7E-4772-9241-FA5A3EFA50C1@.microsoft.com...
> I have a client running NT 4.0 on one of his workstations. For some reason
from that machine he can't see the named Instance on the Server
(MyServer\MyInstance) and therefore can't connect to the database. If I pull
up a list of available servers, the Server comes up on the list, just not
the named instance. ANy ideas on what might be causing this?|||Yeah, thanks, that was it. Was getting burned by the user rights. The instal
l is supposed to load version 2.7 but I don't think the user had enough righ
ts on the box to do it.

No comments:

Post a Comment