Error while registering a new sql server

TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

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) (Microsoft SQL Server, Error: 53)

When I try to regiter a sql server, I take this error message. I am using Sql Server 2005. What is the problem,can you help me?

You have to enable remote connections:

http://sqlserver2005.de/sharedfiles/remoteconnection.jpg

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||But how can I reach those properties and settings?
|||

Hi,

if you are using SQL Server 2005 (not Express) as you told below, you can simply go to the SQL Server Surface Area Configuration in the programs menu and execute the program entry.

Start --> Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> Surface Area Configuration

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de