Cannot Create New Database

when i am trying to connect to sql server2005 thru Visual studio i am getting an Error:

"SQL Server does not allow remote connections (provider: Named Pipes Provider, error: 40 could not open connection to Sql Server)"

Can any body tell me why is it happening and its Solution....

You will have to enable Remote Connections for your SQL Server instance, by default this is turned off. See the screencast on the screencast section on my website for more details.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

cannot connect the sql server

Hi Friends

when i am trying to connect the sql server2005 i got the following error message.

here mw6 is my system name, pls guide me how to rectify this.

TITLE: Connect to Server

Cannot connect to mw6.

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: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

BUTTONS:

OK

Hi,

have a look here: http://www.sqlserver2005.de > Screencast Section > Enable Remote Connections

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de