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

Hello Dave,

To resolve this issue, please do the following steps on the server:

1. Start SQL Server Configuration Manager in the Start Menu -> Microsoft
SQL Server 2005 -> Configuration Tools

2. Under SQL Server 2005 Network Configuration, Enabled TCP/IP

3. Right clicked Properties on TCP/IP, on the IP Address tab, enabled the
appropriate, active IP Address and then test to connect to the server again.

If this still could not help, please do the following on the client:
1. Start SQL Server Configuration Manager

2. Under SQL Native Client Configuration, Right click Aliases, click New
Alias.

3. Add the Server name and Port No and then test to connect to the server
again.

Hope this will be helpful.

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

The TCP/IP (and named pipes) was disabled. Turning that on fixed it.

I understand starting with everything locked down but boy is it a pain...

Any suggestions of a good Sql Server 2005 book for someone who knows Sql
Server 2000?

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

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




"Wei Lu [MSFT]" wrote:

Here are a few books to get you started:

Microsoft® SQL ServerT 2005: Database Essentials Step by Step
Solid Quality Learning
Microsoft Press
ISBN 0-7356-2207-8 (exp. 9/6/06)

Microsoft® SQL ServerT 2005: Applied Techniques Step by Step
Solid Quality Learning
Microsoft Press
ISBN 0-7356-2316-3

Inside Microsoft® SQL ServerT 2005: The Storage Engine
Kalen Delaney
Microsoft Press
ISBN 0-7356-2105-5 (exp. 9/27/06)

Administrator's Guide to SQL Server 2005 (Paperback)
Buck Woody
Addison-Wesley
ISBN: 0321397975

Pro SQL Server 2005
Thomas Rizzo, Julian Skinner, Adam Machanic
APress
ISBN: 1590594770

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"David Thielen" <thielen (AT) nospam (DOT) nospam> wrote