Re: Sql Native Client - Can't reach by instance name

Thanks for the reply. Any suggestions on a method of testing access
to a specific port via a particular protocol? I've never needed to go
past using plain old ping.

On Sep 26, 11:48 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@xxxxxxxxxxxxxxxxxx> wrote:
My guess is that something is blocking port 1434 (udp) from that client to the Express instance.

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"Kevin Chambers" <KBChamb...@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

.

Relevant Pages

  • Re: Need Help Diagnosing Spam Source
    ... Others have recommended blocking port 25 from workstations, ... using Company1 Exchange as the sourcing to send these spam mails or the XP ...
    (microsoft.public.windows.server.sbs)
  • Re: SPAMBOT Symptoms?
    ... To block port 25 from workstations, ... then delete the exception for the SMTP port. ... and that pronounces that server is not an open relay. ... The sender of messages in almost every SMTP queue entry was a single ...
    (microsoft.public.windows.server.sbs)
  • Re: Windows Time Service accessing unknow IP address
    ... The DC is time synced to an external source, and appears to be the only time source listed in the w32time settings. ... The workstations are setup to sync to the DC and this also appears to be the only time source listed on the workstations. ... I can see this on the firewall logs and also using a port scanner on the client PCs. ...
    (microsoft.public.windows.server.general)
  • Re: Please help Domian keeps getting blacklisted
    ... You should be able to turn up the logging on your router/firewall and see what traffic is being sent on port 25. ... Of course if you are allowing guests/employees to connect with a WAP on the router, thereby bypassing the SBS, you will not see any activity on the switch, but the logging in the router should show it to you. ... On the SBS server we hadve AVG 7.5 with exchange plugin. ... Only 5 workstations are in the same location os the server, ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN or RRAS
    ... only thing your router should point to is your server. ... workstations via an RDP client or manually setting up the ActiveX ... If you have enabled the port 6001 here you can just ...
    (microsoft.public.windows.server.sbs)
Loading