Member Avatar for Vivek_1986

When i'm trying to create a new SQL Server Database in VB.NET 2005 through Server Explorer i'm getting following error (no matter what authentication i select):

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)

Note: i have properly selected my Server and entered a different name to the new database.

Please help me.
Thanks in advance.

  • 4 Contributors
  • 3 Replies
  • 176 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by reeeeeee
Member Avatar for shaffy kathpal

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)

Member Avatar for reeeeeee

u need to install a full version package of SQL 2005.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.