Hi;

I installed the dev version of SqlServer 2005 and can access it fine on the
server it is on. And the properties say it allows remote connections.

But SqlServer Management Studio cannot connect from my workstation to the
server. And I cannot connect using ADO.NET or JDBC.

SSMS says "An error...Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server)(Microsoft SQL Server, Error: 233)

The ADO.NET exception is:
System.Data.SqlClient.SqlException was unhandled
Message="An error has occurred 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)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=233
Server="lumiere"
State=0
StackTrace:
at
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.SqlServer2005Test.TestSqlServerConnecti on(Boolean
useSSPI) in C:\src\DBConnTest\DBConnTest\SqlServer2005Test.cs: line 31
at DBConnTest.Program.Main() in
C:\src\DBConnTest\DBConnTest\Program.cs:line 29
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context( Object state)
at System.Threading.ExecutionContext.Run(ExecutionCon text
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

Any ideas?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm