Global Connections Fail, Local Connections Succeed

Global Connections Fail, Local Connections Succeed

Post by christophi » Thu, 08 Jul 2004 14:45:47


I've seen several posts suggesting similar problems, but I haven't
found a solution. I'm connecting using the MMS protocol. I've opened
port 1755 (UDP and TCP) on my router, and have them mapping over to my
Win 2003 box. From within my LAN, connections work fine. From a
remote computer connecting over the internet, I get a 'file not found'
error.

I'm almost 100% certain that my router/firewall is configured
correctly. However, I get no record of a connection in the MMS log
file. I even tried opening all ports on my router. Still to no
avail.

Is this a Win 2003 problem? Has anyone had as much trouble as I?
Please help, before I stab myself in the eye with a spork.

Thanks,
Chris
 
 
 

1. ADO Global Connection does not let a local connection release DBF for 60 seconds

2. connection to master fails, to northwind succeeds

For the code:
using (IDbConnection sc = new SqlConnection(connStr))
{
sc.Open();
...

using the connection string
connStr = "Data Source=test23;Initial
Catalog=Northwind;Integrated Security=SSPI;";

it works fine

but using the connection string:
connStr = "Data Source=test23;Initial Catalog=master;Integrated
Security=SSPI;";

We have the following situation: From some computers it works, from
others we get the exception:

An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)

Note 1: We have tried this with both SSPI and passing a username &
password.

Note 2: Some systems connect fine, others fail - but they are all
connecting to the same server so the server must be ok.

Note 3: All machines can connect to Northwind, it's master that's the
problem.

Note 4: The machines that fail do not have SqlClient listed as a
datasource in Windows.

Any ideas?

thanks - dave

david@ XXXX@XXXXX.COM
Windward Reports -- http://www.yqcomputer.com/
me -- http://www.yqcomputer.com/

Cubicle Wars - http://www.yqcomputer.com/

3. PUZZLE: A call that succeeds N times then fails for any single connection

4. untrusted connection succeeds when it should fail

5. Data Source connection fail in DTS while succeed in Enterprise Man

6. Remote AS Connection fails on Win2k but succeeds on WinXP

7. global connection or seperate connections for each stored proc cal

8. [Info-ingres] Connection in connection, you will create a series of global commerce.

9. Tunneling TCP connections from local zone to the global zone

10. Change the local port of a server connection after connection is established

11. Testing Local Connection / Internet Connection

12. No connection to local SQL Server when no network connection

13. Disable/enable network connection ("Local area connection") by Delphi ?

14. Management of Local Area Connection and Internet Connection (ADSL

15. multiple local connections or single connection in database class?