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 - 15 Oct 2007 23:38 GMT
You need to configure SQL Server 2005 Express to accept remote connections.
See this KB : http://support.microsoft.com/kb/914277
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
> Hello,
>
[quoted text clipped - 19 lines]
>
> Miguel
shapper - 16 Oct 2007 01:09 GMT
On Oct 15, 11:38 pm, "Juan T. Llibre" <nomailrepl...@nowhere.com>
wrote:
> You need to configure SQL Server 2005 Express to accept remote connections.
>
[quoted text clipped - 28 lines]
>
> > Miguel
Thanks!
Cheers,
Miguel