Re: Sql Native Client - Can't reach by instance name
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 27 Sep 2007 08:48:49 +0200
My guess is that something is blocking port 1434 (udp) from that client to the Express instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kevin Chambers" <KBChambers@xxxxxxxxx> wrote in message news:1190849489.301302.39570@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi there--
I'm connecting to SQL Server Express from MS Access via ADO on a
number of older workstations. Of three workstations, two connect just
fine with a connection string like this:
Provider=sqlncli;Network Library=DBMSSOCN;Initial Catalog=MyDb;Data
Source=server\sqlexpress;Integrated Security=SSPI
However, on one machine (W2K), the above does not work, but this does:
Provider=sqlncli;Network Library=DBMSSOCN;Initial Catalog=MyDb;Data
Source=server,2295;Integrated Security=SSPI
There appears to be a problem with getting the connection redirected
to the named instance. It seems like the native client driver should
be all I need for this to happen, but it ain't. Anyone know what's
missing here?
Thanks in advance for any help.
KC
.
- Follow-Ups:
- Re: Sql Native Client - Can't reach by instance name
- From: Kevin Chambers
- Re: Sql Native Client - Can't reach by instance name
- References:
- Sql Native Client - Can't reach by instance name
- From: Kevin Chambers
- Sql Native Client - Can't reach by instance name
- Prev by Date: RE: SQL 2005 Compact Edition - Derived tables
- Next by Date: Disaster Recovery Encrypted DB
- Previous by thread: Sql Native Client - Can't reach by instance name
- Next by thread: Re: Sql Native Client - Can't reach by instance name
- Index(es):
Relevant Pages
|
Loading
