Sql 2005 Connectivity

[SANCHIT SHARMA]

We Are Using Sql 2005. We Loaded Sql On Server. On Client Machine We Loaded Sql Client . From Sql Client We Want To Connect Sql Centralised Server.

How To Connect

 

[SANCHIT SHARMA]

It gives us following error

TITLE: Connect to Server
------------------------------
Cannot connect to COMP-2.
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?Prod...ver&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
pls help

 

[cjard]

sql 2005 surface area configuration tool, enable windows or sql auth, named pipes and remote connections

 

[SANCHIT SHARMA]

Thanks a lot Cjard..