VS 2008. Can't create database.

[shapper]

Hello,

I just installed VS 2008.

I opened the Server Explorer window and right clicked on Data
Connections and selected "Create New SQL Server Database".

Then I selected the Server Name and wrote the database name. I have
Windows Authentication selected.

When I click OK I get the error:

"An error has occurred while establishing a connection to the server.
When connection 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 Provides, error: 40 - Could not
open a connection to SQL Server)

Could someone, please, tell me what I am doing wrong?

Thanks,

Miguel

 

[Juan T. Llibre]

You need to configure SQL Server 2005 Express to accept remote connections.

See this KB : http://support.microsoft.com/kb/914277

 

[shapper]

You need to configure SQL Server 2005 Express to accept remote connections.

See this KB :http://support.microsoft.com/kb/914277

Thanks!

Cheers,
Miguel