For the code:
using (IDbConnection sc = new SqlConnection(connStr))
using the connection string
connStr = "Data Source=test23;Initial
it works fine
but using the connection string:
connStr = "Data Source=test23;Initial Catalog=master;Integrated
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 &
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
Note 4: The machines that fail do not have SqlClient listed as a
datasource in Windows.
thanks - dave
Windward Reports -- http://www.yqcomputer.com/
me -- http://www.yqcomputer.com/
Cubicle Wars - http://www.yqcomputer.com/